Saved Query Definition - Values and Sort Order

This page is accessed via Business Process Automation > Power Data > Event Management. This page appears if you select the Use In Finder check box.

Use this page to further define your saved query by selecting saved query values and sort orders. The fields that are displayed are retrieved from your default finder set for the query chosen on the Saved Query Header tab.

Criteria

1. If you selected the Use in Finder option, the Saved Query Manager directs you to a Saved Query Definition page where you can enter Saved Query Values and Saved Query Sort Order.
2. Select a column for the query. The Column field displays a list of the fields that you can choose from. The list is based on the business object type you are using. For example, if the business object is Order Base, then the fields listed are the same as those that appear on the Order Base Search page (all tabs) in the Order Manager.

   Note: You cannot set a date of "today" and have it be the current date in the future. If you select a column with a date field, such as Early Delivery Date, you can select the current date and then select an option of Range From/To Today. The "today's date" that is stored is hard-coded and not a variable date of the current date.

3. Enter a search value for that column. The search values are field values where you can record the business object.
4. Click Save.

Advanced Filter Criteria

This section is for advanced filtering. The list contains all of the derived fields that are filterable. If this finder set has filterable derived fields defined, then they appear in this section.

1. Select a column from the Column drop-down list.
2. Enter the criteria for the filter. The criteria appears to the right of the column name and changes depending on the column that is selected.
3. Click Save for each column you select.

Sort Order

You can control the order of the data that appears on the Results page by defining a sort order for up to three columns. The default sort order is typically by the ID of the business object for which you are conducting a query. To define a meaningful sort, you should change the default sort for the first column and then proceed to specify a sort by additional columns in ascending or descending order.

1. Select a sort order column. Once you choose a Column field, you can enter the appropriate Value for the field.
2. Select the Ascending check box if you want the query results to be displayed in an ascending order.
3. Click Save.
4. Click Finished when you are done to save the query.

Note: The Sort Order section is not applicable to saved queries for agents.