Adding a Criterion to a Query

To add a criterion to a criteria-based query, proceed as follows:

1. Select Queries in the left window pane.
2. Select the query to which the new criterion is to be added in the left window pane.
3. Select the Criteria tab in the right window pane.
4. Select Edit > Add Criterion .
    The Select Criterion dialog box appears on the screen, displaying a list of available criteria.
5. Select the desired criterion.InformationThis will define the contents of the drop-down lists in the Criterion Description box of the same dialog box.
6. Define the operator by selecting the desired entry from the Operator list.
7. Define a value in the Value box by either entering the desired value directly or:InformationIf the value is not a free text value but must be chosen from values registered in the database, such as the inventory type, this box is dimmed and the method described following must be used to enter the value.
   1. Click Find next to the Value box.
       The Search Criteria dialog box appears on the screen.
   2. Select the operator according to which you want to launch the search from the Operator list.
   3. Enter the characters for the search into the Value box.Information

      If you are looking for a specific software, select Contains as the operator and enter the name completely or partially into the Value box.

      For example, if Contains Maker is defined, the search can return Filemaker , Framemaker , Pagemaker , and so on.

   4. Select the desired value from the results list.
   5. Click OK to continue.
8. If you selected a criterion with a time parameter in step 5, enter the desired time in either the Value or the Timeframe text box.InformationYou can simply enter a date and time in the standard user defined format in the Value box or find the value via the search functionality described in the second set of substeps of step 7. To enter a dynamic time value select the newly displayed Timeframe radio button. Enter then the desired time value into the text box next to it and select the corresponding unit from the drop down list to the right.
9. If the result of the criterion definition is to be reversed, check the Reverse Criterion Result box.InformationIf the criterion defines for example to find all devices on which Microsoft IE is installed and this option is activated, the final result of this criterion will be all devices on which IE is not installed.
10. Click Add to add the defined criterion to the Selected Criteria list.InformationYou can add further criteria by repeating steps 5-9.
11. Click OK to add all selected criteria to the query.
12. Select active from the Query Status list.

The selected criteria were added to the query selected in step 2 and the query was reactivated.