Named Queries

Defining Named Queries

Named Queries define data subsets for easy reference

By default, Omniscope works with 4 defined sets/subsets of the integrated data set;  ALL data, filtered IN data, filtered OUT data and Selected data. Files open with all records in the inegrated data set visible in the default filtered IN subset.

Omniscope has two query modes; Sidebar instant filtering, or Main Toolbar Selection, Moves & Keeps, whereby some records are transfered to the filtered OUT data subset as shown in the barometer.

You can define additional subsets of data which can be displayed alone or in conjunction with the defined data sets/subsets using Named Queries.

The Named Queries drop-down menu is immediately right of the Barometer, and provides all the commands required to define and manage Named Queries, combinations of filter settings or record selections which define selected or filtered subsets of the file data expected to be used frequently in configuring the views in the file. In the example below, 3 Named Queries have been defined; 'Basket One', 'Errors for Correction' and 'Other Named Query'. At right, the example Venn View toolbar has been set to display the records contained in the Named Query 'Basket One'.

 

Each View Toolbar includes a Data Subset drop down where you specify which of your defined Named Queries (in brown) should be displayed in the view:



 

Named Queries can be defined using either Create empty query or Create query from filters.

Create empty query - give the query you plan to populate a unique name for this file. The new query will appear at the top of the Named Queries drop-down list, and become a side menu option for commands such as such as Clear, Rename and Delete Query. The Show button for option places a button with the name of the selected Named Query/data subset on the Main Toolbar to the right of the Named Queries drop-down menu. These button(s) make it easier to manage adding or deleting selected/filtered IN records from multiple Named Queries. Once an empty query has been created, e.g. 'Basket One' or 'Errors for Correction' you can add filtered IN or Selected records to these queries at any time using Add or Remove selected/filtered data to query (if records are Selected, these records will be added/removed, if not, then the current contents of the Filtered IN subset will be added/removed to/from the Named Query you select from the sub-menu at right.

Create query from filters - this option lets you preserve the current pattern of filters set in the Side Bar as a Named Query. You can subsequently refine the data set defined using Add or Remove selected/filtered data to query.

Import/export XML query file- the definition of any query in the file can be saved in XML file format and exchanged with others using the same Omniscope file. This is useful for example, for highlighting anomalies and errors in the data requiring correction.