and
then selecting a saved search. The SQL Where Clause search of the User Search dialog box is only available for users who are members of the SYSADMIN group. It allows you to create more complex selection criteria by creating your own SQL Where Clause. PM Compass then uses that SQL Where Clause to query the database and find records that meet your selection criteria. You can edit and save the information as a Global search for other users.
For more information on search types and options, see Search Overview.
This field displays SQL Where Clause. You can also select one of the following options from the drop-down list:
In addition, modifying the display type changes the interface of this dialog box.
After changing the information on the dialog box, you must click this button to populate the list box of results. The records that PM Compass displays in a grid depend on the search filters that you define. The columns in the grid vary, depending on the display type that you select.
This field is optional. It allows you to enter the name of saved search,
or it displays your selection after clicking and
then selecting a saved search.
Click this button to display the Organize Options dialog box, which allows you to save your search and give it a name.
Enter or modify an SQL statement that you want to use for a search. If you enter a wrong syntax, an error message displays.
Select this check box to display the SQL Where Clause used in the search and any error messages on another box below the Where Clause box.
If you do not select this check box, the box below the Where Clause box is initially empty. Clicking Search displays the search results in a grid, replacing the empty box.
This grid displays the search results after you define your filter criteria and then click Search. The column headings of this grid vary depending on the field that you select from the Search By drop-down list.
This field displays the total number of records that are available in the result set of the search.
Select a workflow from the grid and click this button to display the corresponding data. You can select multiple records by pressing either the CTRL key or the SHIFT key and then clicking the selected entries. The search dialog box displays the first record that best matches the criteria, following the numerical-alphabetical order for all records.
For field searches, selecting a record and clicking Select closes the search dialog box and displays the selected record in the field.
For filter searches that present records for a screen (for example, a workflow search), selecting a record and clicking Select closes the search dialog box and populates the application form with the values of the selected record.
For Dashparts (but not the global filter for Dashboards) and Reports, the label of this button is Apply.
Click this button to select and display all available records in numerical-alphabetical order.
Click this button to exit the dialog box.
Click this button to display the help topic of the search dialog box. Clicking this button, however, displays the Standard display type by default.
Perform an SQL Where Clause search