Query Explorer

Use the query explorer to view a list of queries and folders.  Folders can contain other folders and are a way of organizing and grouping queries.  Queries are a definition of resources to be searched for, and defined using the Query window. 

QueryExplorer

To create a new query use the toolbar menu options File > New > New Query which will open the Query window where you enter the kind of resources to you want to find and interactions to search.

NewQuery

To create a new folder use the toolbar menu option File > New > New Folder.  This creates a folder called New Folder which you can rename by overtyping.

newfolder

You can also us the New option on the pop-up menu to perform actions on a query.

querypopupmenu

Copy, will copy the definition of the query to the clipboard, which you can paste into either the same folder or a different folder in the Query window.  If you paste the clipboard contents into a text editor you will see the raw SQL strings that are run against the DB2 tables, a feature which is useful for users who have their own ways of executing SQL and collecting results. 

The Run option executes the query and the results are shown in the Resources window.

When the Resources window shows the result of running a query you can save the resources to be recorded against the query.  Use the toolbar File > Save menu option.  For example, if the query in the screen dump above is run, the May have affinities query is executed and the results are shown in the Resources window.

mayhaveaffinityresults

If you select the menu option File > Save brings up the Save query results window box in which you enter a relevant name to record against the results, as shown in the screen dump below: 


savequeryresults

The results for a query shown in the Query window are children of the query.  The screen dump below shows the Before Fix 123456 applied data beneath the May have affinities query.  The date and time are appended to the name entered in the Save query results window so you can view information about why and when the query was run.

queryresults

The copy option on the pop-up menu for a set of query results will take all of the query data and place it into the clipboard, then you can paste it into a spreadsheet, or other tool, to do additional analysis as required.
The run option on the pop-up menu for a set of query results will open the saved data in the Resources window.  After opening different query results, for the same query, run on different dates. You can use the Compare Resources window to see what has changed and build up a picture of change over time.
Query results can be individually deleted, if a query is deleted then all of its results are deleted as well.