Query criteria

By adding criteria to your query, you specify that certain conditions must be met for a record to appear in the results list. The values available differ according to the condition and data type selected. The values could be dates, times, categories, user names and so on.

You can specify criteria for any attribute, including collection attributes. If you specify criteria for collection attributes, the query returns only data that matches those criteria. However, if you have also added the collection attribute to the query results list, then when you click the corresponding collection tab in the results list, all of the items in the collection appear, not just those collection items that match the criteria.
For example, a query based on the Request business object that also includes collection attributes from the Tasks business object, and criteria to select only those processes with a Task status of Open displays only Requests that have Tasks at the with a Status of Open. However, if you click the Tasks tab on the query results list, ALL of the Tasks for the selected Request appear – not just those Tasks at the Open status.

If you add the top level related attribute (represented by on the Attributes tree), you can select a condition of Is Current User or Is Current Group. These conditions are only available at this level. For example, if you add the top level Current Assignment related attribute, you can select Is Current User or Is Current Group. However, if you expand that attribute and select Name, then you cannot select those conditions.

To add a date and time criteria to your query, you can specify a condition of Is Equal To Nearest. Using this criteria, you specify the value and select whether it is nearest to the minute, hour, day, month or year.