Query template settings

You can create a query template to filter the data that you will display on the dashboard. In particular, such a query template can be used as a Data Source of the dashboard widgets.

This is suitable if you have lots of data ingested in your project, coming from different sources.

For example, we will show you here how to create a query template that filters only for data coming from the simulator.

Proceed as follows:

1. On the left navigation, go to Data Explorer and click Add Query Template in the upper right area.
   

   

2. In the Template Designer that opens, add a Name for the new template, for example Device simulator latest data.

3. In the Parameters area click Add Parameter in order to add two parameters, namely:

   1. Name: device with Data Type: STRING and Parameter Type: SCALAR

   2. Name: timerange with Data Type: TIMESTAMP and Parameter Type: RANGE
      

      

4. In the Template Definition area enter a query. You can see an example on the screenshot below.
   

   

   
   

     Click here to expand the query example...

   [

   {

   "$match": {

   "metaData.thingId":"${device}",

   "metaData.receivedAt": {"$gt":{"$date":"${timerange.from}"}, "$lt":{"$date":"${timerange.to}"}},

   "metaData.generator": "device-simulator"

   }

   },

   {"$sort": {"metaData.receivedAt": -1}},

   {"$limit": 1000}

   ]

   
   

5. When ready, click the Create New Query Template button on the bottom.

6. As a final step, Run the template, to see if it is generating data. For that, you need to enter the ID of one of your devices.
   

   The correct format of the device ID is the one that you can see on the list of devices under the device name: