Queries Explained

This article will list and explain all of the queries available within the dynamic data configuration settings

Dan Thody avatar
Written by Dan Thody
Updated over a week ago

Queries are used to show specific rows of data, these are configured when adding your dynamic data plugin.

Click 'Add a query' to add queries to show specific data from the selected sheet.

Basic Queries

  • 'Equals' - Search sheet selected for rows where the 'column' option equals the value specified in the next input box (must be exactly as it is written in the excel sheet - capital letters, spelling etc)

  • 'Does not equal' - Search sheet selected for rows where the 'column' option does not equal the value specified in the next input box

  • 'Contains' - Search sheet selected for rows where the 'column' option contains the value specified in the next input box

  • 'Does not contain' - Search sheet selected for rows where the 'column' option does not contain the value specified in the next input box

  • 'Less than' - Search sheet selected for rows where the 'column' option is less than the value specified in the next input box

  • 'More than' - Search sheet selected for rows where the 'column' option is more than the value specified in the next input box

Device Item Queries

  • 'Less than device specific column' - Search sheet selected for rows where the 'column' option is less than the device item column selected in the next option

  • 'More than device specific column' - Search sheet selected for rows where the 'column' option is more than the device item column selected in the next option

  • 'Equals the device specific column' - Search sheet selected for rows where the 'column' option equals the device item selected in the next option

  • 'Does not equal the device specific column' - Search sheet selected for rows where the 'column' option does not equal the device item selected in the next option

  • 'Contains the device specific column' - Search sheet selected for rows where the 'column' option contains the device item selected in the next option

  • 'Does not contain the device specific column' - Search sheet selected for rows where the 'column' option does not contain the device item selected in the next option

Touched Item Queries

  • 'Less than touched item column' - Search sheet selected for rows where the 'column' option is less than the touched item column selected in the next option

  • 'More than touched item specific column' - Search sheet selected for rows where the 'column' option is more than the touched item column selected in the next option

  • 'Equals the touched item specific column' - Search sheet selected for rows where the 'column' option equals the touched item selected in the next option

  • 'Does not equal the touched item specific column' - Search sheet selected for rows where the 'column' option does not equal the touched item selected in the next option

  • 'Contains the touched item specific column' - Search sheet selected for rows where the 'column' option contains the touched item selected in the next option

  • 'Does not contain the touched item specific column' - Search sheet selected for rows where the 'column' option does not contain the touched item selected in the next option

Device Queries

Device queries use the devices' time and date as the value to search for depending on which option you select. The options you can select are 'Day of the month', 'Day of the week', 'Month', 'Year', 'Hour', 'Minute'.

  • 'Less than device ...' - Search sheet selected for rows where the 'column' is less than the devices option selected in the next box

  • 'Less than, or equal to device ...' - Search sheet selected for rows where the 'column' is less than, or equal to the devices option selected in the next box

  • 'More than device ...' - Search sheet selected for rows where the 'column' is more than the devices option selected in the next box

  • 'More than, or equal to device ...' - Search sheet selected for rows where the 'column' is more than, or equal to the devices option selected in the next box

  • 'Equal to device ...' - Search sheet selected for rows where the 'column' is  equal to the devices option selected in the next box

Did this answer your question?