Queries Folder

The following table lists the queries that are stored in the Catalog location \\Public\Meridium\Modules\Operator Rounds\Queries. The queries are listed by name in the table. The query name and caption are the same unless otherwise noted.

Query	Behavior and Usage
Aging Query - Oracle	Returns Measurement Locations that are overdue.
Aging Query - SQL Server	Returns Measurement Locations that are overdue.
All Lubricants	Returns the list of Lubricant records that is displayed in the Lubricants list on the RD Overview page.
Allowable Values	This query is used to view and allow updates for Operator Rounds Allowable Values.
AllTemplates	Returns all Measurement Location Template records. This query is used to populate the picklist for Template field on datasheets for the Measurement Location family.
Asset Context Filter	This query is used to select a particular asset context from Asset Hierarchy.
Last 30 Days Dates	This subquery is used to return the dates of the last 30 days.
LRs From LRT	Returns the Lubrication Requirement records that were created from a given Lubrication Requirement Template record.
LRT For LRs	Returns the Lubrication Requirement Template details to update existing Lubrication Requirements.
Measurement Location Template	Returns details for a single Measurement Location Template record.
MLs From MLT	Returns the ML records that were created from a given Measurement Location Template record and provides content for the Update Existing MLs page.
MLT For MLs	Returns the ML template details to update existing Measurement Locations and provides content for the Update Existing MLs page.
Most Recent Reading	Returns a list the most recent readings. This query is used by the Measurement Locations in the Alert query.
Non-Compliant CPs	Returns non-compliant readings. If you need to modify this query, you may append additional columns, but the existing columns must remain in their original order to ensure that Compliance Tracking functions as expected.
Non-Compliant CPs With Duplicate Readings	Returns the Entity Keys of checkpoints with duplicate non-compliant readings. This query supports the Non-Compliant CPs query. If you need to modify this query, you may append additional columns, but the existing columns must remain in their original order to ensure that Compliance Tracking functions as expected.
Operator Rounds Recommendations - Conditional Alert	Returns all of the Operator Rounds Recommendation records that have been created since the previous day.
OPR Recommendation Geolocation	Returns readings for a Route on a map. This query is also a sub-query used by the Route Geolocation Data query.
Readings Geolocation data	Returns readings for a Route on a map. This query is also a sub-query used by the Route Geolocation Data query.
Route Geolocation Data	Returns the Route geolocation data that is saved for readings, recommendations, and photos. This query can be used to view Route geolocation data on a map.
Route Management	Returns existing Routes.
Route Management Configuration	This query is used to configure the Route Management screen.
Template Management	Returns existing templates.
TemplateUniqueness	This query is used by the GE Digital APM system to determine if the value you entered in the Template ID field in the Measurement Location Template record is already used by a different Measurement Location Template record.
Update Allowable Values	Returns BDF with selected values. This query is used by the Allowable Values query.
Update Measurement Locations from MLT	Returns the Measurement Location records that were created from a given Measurement Location Template record.
Dashboard Queries Subfolder
Active Recommendations	Returns all the active Recommendations (with state created) related to the Measurement Locations filtered by the related Route and Asset.
Completed Reading Count	Returns the count of the completed readings filtered by the Route, asset (Equipment/Functional Location), Start Date, and End Date.
Completed Reading Count AC	Returns the count of the completed readings filtered by the Asset Context.
Compliance	Returns the count of the completed and non-compliant readings filtered by the Route, Asset (Equipment/functional Location), Start Date, and End Date. This query uses two existing queries to find the counts and joins them.
Compliance AC	Returns the count of the completed and non-compliant readings filtered by the Asset.
Compliance Percentage	Returns the percentage of completed readings from the completed and non-compliant readings.
Compliance Percentage AC	Returns the percentage of completed readings from the Reading taken and non-compliant reading.
MLAHI	Returns the health indicator alert level for all of the Measurement Locations under the selected route. This query also filters results based on the asset chosen and displays the health indicator alert for the selected assets. When both the filters are selected, the health indicator alert is shown for the health indicators which are linked to Measurement Locations under the selected route and linked to the selected asset.
Non-compliance Reading Count	Returns the count of the non-compliant readings filtered by the Route, Asset (Equipment/functional Location), Start Date, and End Date.
Non-compliance Reading Count AC	Returns the count of the non-compliant readings filtered by the Asset Context.
OPR Parameters Query	Returns the same values that the user enters. This query is used in the parameter widget on the OPR dashboard.
Overdue Measurement Locations	Returns all Measurement Locations that are overdue (Next Date has passed) and filters them by related Route and Asset.
Route Completion	Returns the number of Routes completed each day, based on Route History, and the number of Routes expected to be completed.
Route Completion Percentage	Returns the percentage of Routes completed each day based on the number of Routes expected to be completed.
Graph Queries Subfolder
Trend of Readings	Displays a trend of reading values compared against the limit levels.
ML Administration Queries
Readings	Displays details about all of the readings linked to a specified Measurement Location.
Readings-Oracle	Displays details about all of the readings linked to a specified Measurement Location when using an Oracle database.
Recommendations	Displays details about all of the Operator Rounds recommendations linked to a specified Measurement Location.
Stored Ref Docs	Displays details about all of the reference documents linked to a specified Measurement Location.
Report Queries Subfolder
Measurement Location Data Capture	Displays a prompt asking you to select a Route record, and then returns all Measurement Location records that are linked to the selected Route record, sorted by the sequence number from the Measurement Location records.
Measurement Location In Alert	Displays Measurement Location records whose last reading value entered on the device triggered an alert. Each row represents a Measurement Location record. In each row, you can select the hyperlink to view the Route record to which the Measurement Location record is linked, the Measurement Location record, and the Trend of Readings Plot graph. Note: This query works on a SQL Server database only. To see the query results on an Oracle schema, use the query Measurement Locations in Alert - Oracle.
Measurement Location in Alert - Oracle	Displays the same results as the query Measurement Locations in Alert. This query, however, works on an Oracle schema only.
Overdue Measurement Locations	Displays Overdue Measurement Locations.
Overdue Measurement Locations - Oracle	Displays Overdue Measurement Locations. This query, however, works on an Oracle schema only.