Saved Queries

This page is accessed via:

• Business Process Automation > Power Data > Event Management > Saved Queries
• Master Data > Power Data > Configurations > Saved Queries

A saved query is a collection of selection and sort criteria that must be met to satisfy a search. It can also include sort criteria that determine how records are displayed. You can create a saved query from any Search page or from Agent Manager. Then you can use this option to display, edit or delete a saved query. Saved queries are domain-specific.

Note: Public saved queries are used exclusively by agents and do not appear on the Search pages for their respective managers.

Note: Pseudo fields are not supported in saved queries.

Saved Query

1. Enter a User Query Name. The user query name identifies the saved query and must be unique. The text that you enter is also used as the Saved Query ID.
2. Select an Object Type ID from the drop-down list. The object types correspond with different managers in Oracle Transportation Management. For example, if you want to add a saved query for the order base finder, select an object type of ORDER BASE.
   
   OR
   
   Enter a Query Table ID.
3. The Use In Finder option allows you to display your query in finders throughout Oracle Transportation Management. In order to enter Structured Query Language (SQL) for either the Check One SQL or Find All SQL definitions in your saved query, you must leave this check box unselected. Entering queries with SQL allows you to create definitions that do not display in finders when performing standard query searches. Enabling parameterized queries requires the configuration of several parameters. Advanced filtering using derived fields is available only if the Use In Finder check box is selected.
   
   This field works with the property glog.webserver.finderresults.showquerycount. The property only affects saved queries where 'Use In Finder' is selected.

   Note: If you need to create a query using SQL and need it to be run from a finder, set the glog.savedquery.show_all_savedqueries to TRUE. Doing so enables all saved queries for this object type to be run from the associated finder.

   Note: If you need to create a query using parameterized SQL and need it to be run from a finder, set the glog.ui.useSavedQueryParameters to TRUE. You also configure the glog.ui.userListSavedQueryParameters and glog.ui.savedQueryParameter properties.

4. If necessary, select a domain from the Domain Name drop-down list.
5. If you selected the Use In Finder check box, click the View/Define Query button. Doing so will enable you to define what columns to select.
   OR
   If you did not select the Use in Finder check box, you can enter SQL statements in the SQL Query Definition page by clicking the View/Define Query button.