Queries Folder

The Catalog folder \\Public\Meridium\Modules\Policy Manager\Queries contains the following items.

Query	Behavior and Usage
Email Address Query	Returns values in the First Name, Last Name, and Email Address fields in Human Resource records whose Email Address field contains a value. This query is used to display results in the grid on the Choose User window.
Events Query	Returns information about the Severity, Name, Description, Type, Start Time, End Time, and Duration (in seconds) of Policy Events. This query can be used with the Query node in the policy diagram to bring in policy events related to pieces of equipment or functional locations. The Events Query includes an Asset Key prompt, which can be passed to the Query node via the Entity Key system field of a family-based predecessor node. By default, the results of the Events Query are sorted in ascending order by start time. This query works with an SQL database. See Events Query (Oracle) for use with an Oracle database.
Events Query (Oracle)	Returns the same values as the Events query. This query, however, works in an Oracle database.
Policy Overview- Active Tile	Returns either all active or all inactive policies. The results of this query are displayed in the Inactive Policies and Active Policies lists in the Policy Designer Overview page.
Policy Overview - Execution	Displays a summary of the execution results for the 20 most active policies within the past 30 days. The results of this query are used by the Policy Overview- Execution graph which is displayed on the Policy Designer Overview page.
Policy Overview - Overdue Recommendations Tile	Returns the Policy Recommendations assigned to any user for which the Target Completion Date has passed. The results of this query are displayed in the Overdue Policy Recommendations list in the Policy Designer Overview page.
Policy Overview - Recent Tile	Returns the policies updated by the current user within the past 30 days. The results of this query are displayed in the Recent Policies list in the Policy Designer Overview page.
Policy Overview - Recommendations Tile	Returns the Policy Recommendations that are open and assigned to the current user. The results of this query are displayed in the My Policy Recommendations list in the Policy Designer Overview page.