This topic discusses what Queries are and how to use them.
What is a Query?
You can think of a query as a storage location for your filter rules. This means you can create one or more storage locations (multiple queries) to store different filter settings. Once created, a query can be used as a data source for the data visualisations ('views'), to show only the data that matches those filter rules e.g. female customers, where age is between 35-45 years.
Queries will appear as devices in the Filter view, so the user can add them to the filtering menu, as ready-made data subsets with desired characteristics.
Types of Queries
There are two kinds of queries in Omniscope:
Filtered IN query
In Omniscope all filter rules are stored in a "Query". By default, if you don't create your own queries, they get stored in a query called "Filtered IN", which always exists. This type of query is tab-specific, and each tab has its own “Filtered IN” state, which is result of the current filter states. If nothing is filtered, the views will display the whole dataset. On interaction with filter devices, by default, the views will display the data that is filtered in. You also have an option within each view to opt for the filtered out, or 'inverse' state.
User-created queries can be either tab-specific or multi-tab and there are two places from where you can create/manage them from:
Dynamic vs read-only queries
Once created, Omniscope queries can still be edited and new data and filter states can modify existing queries, if desired.
The user controls whether or not those rules are dynamically updated, or are stored as “read-only”.
You can create queries which are dynamic and continuously change when the user changes filter rules. For example, if you have a multi-tab query, and you use “Filters view" to modify one of the filter rules within that query, then all the tabs containing that query will pick up the changes and update the views.
Advanced feature - synchronised filter behaviour across the tabs (end-user in control)
In a situation when report editor would like to enable the end user to pick a filter state on one tab, and for that choice to be reflected on all or multiple report tabs, advanced dynamic query feature could be used.