Query Editor

You create queries to search resources using the Query Editor.

What to do next

The Query Editor is very flexible and allows you to create queries to show exactly what you want to see:
  • Use a query to search for resources based on their criteria against a set of expressions.
  • Create, delete, edit, run, and view queries in the Query view menu.
  • Name the query keeping to the naming guidelines using Valid query and folder names.
  • The Resources view displays the results of running a query.

You can specify two main criteria in a query: the parts of an interaction that you want to see and the interactions that you want to include.

The parts of an interaction to see

When you have selected the type of resource that you want to query, you can choose the information that you want to be shown in the tree structure of the Resources view when the query has run. The screen capture below shows the Create IMS™ Query view, showing a menu that lists the type of resource that you can query. You can select multiple resources.

Screen shot of the Create Query window

To add a resource to the tree, use the green plus green plus button above the tree structure. To remove a resource, use the red cross red cross button while the resource is selected. You can move up and down the tree using the down arrow yellow downward arrow and up yellow upward arrow arrow buttons.

Interactions to include

To further refine the query for the resources that you have chosen, use the Filter results panel. You can create multiple expression filters and each resource is provided with a set of filter possibilities. To add filters use the green plus green plus button above the table of all expressions. To remove a filter, use the red crossred cross button while the expression is selected.

The example below shows a CICS Query called CICS Query Programs F that will show the Resource Name, at the top of the tree, followed by Resource Type, Transaction, and Program, where the only programs shown in the query results will begin with 'F' as requested in the far right panel.

Screen shot of create query window

The result of running the CICS Query Programs F is displayed in the Resources view in the order specified by the query.

Screen shot of the resources view that shows the results of running the CICS Query Programs F query. The tree includes Map, APPLID, JOURNAL, FILE, ENQNAME, and PROGRAM.

If an expression does not have a choice entered against it on the right side of the query editor, that expression is removed from the query, is not stored, and is not retrieved when the query is edited the next time.

You can add an expression with a suitable value in the right side of the query editor when you next edit a query.

If the column name you want to filter has a name relationship with another column, that is they have the same name, use the radio button to select either, the column of the same name or, to select a value that can by entered in the panel below. The example below shows the Filter panels when there is a single column name relationship:

Screen capture that shows the filtering available when the column name chosen to be filtered by, in this example Transaction, has a single column name relationship, in this example, with Resource Name

If the column name you have chosen to filter the results by has a name relationship with more than one other column name, they are listed in a menu as shown in this example:

Screen capture that shows the filtering available when the column name chosen to be filtered by, in this example resource Name, has multiple column name relationships, in this example, with Program, Transaction and Region Applid.