Overview Queries Folder

The Catalog folder \\Public\Meridium\Modules\Inspection\Overview Queries contains queries that are used on the following pages:

The Inspection Management Overview page for the selected hierarchy level.
The Inspection Management Overview page for the selected asset.

The following table provides a list of queries that are used on the Inspection Management Overview page for the selected hierarchy level.

Query Name	Behavior and Usage
All Inspection Assets for Unit	Returns a list of assets with at least one inspection. This query is used to display results in the grid in the Inspection Assets section.
All Inspections for Unit	Returns all the inspections performed against the selected Functional Location. This query is used to display results in the All Inspections for This Location subsection in the Underlying Inspections section.
Count of Task Types due Within the Year	Returns the number of Task Types that are due within the calendar year. This query is used in the graph in the TASK TYPES COMING DUE WITHIN THE YEAR section.
Inspection Overview Parameters	Returns the parameters used to navigate through the Asset Hierarchy.
My Open Inspections	Returns a list of open inspections assigned to you. This query is used to display results in the My Open Inspections subsection in the Underlying Inspections section.
Open Inspection Recommendations by Asset	Returns the number of open Inspection Recommendations for each asset contained within the unit. This query is used in the graph in the OPEN INSPECTION RECOMMENDATIONS BY ASSET section.
Open Inspections for Unit	Returns a list of open inspections for Equipment or Functional Locations contained within the unit. This query is used to display results in the Underlying Open Inspections subsection in the Underlying Inspections section.
Open Recommendations for Asset	Returns a list of Inspection Recommendations for the given asset. This query is used to display results in the Open Recommendations for this Location subsection in the Overdue Recommendations section.
Open Recommendations for Unit	Returns a list of open Inspection Recommendations for assets within the unit. This query is used to display results in the Underlying Open Recommendations subsection in the Overdue Recommendations section.
Overdue Inspection Recommendations for Unit	Returns a list of Inspection Recommendations that are overdue and associated with the Equipment and Functional Locations in the unit. This query is used to display results in the Overdue Recommendations subsection in the Overdue Recommendations section.
Overdue Tasks for Unit	Returns a list of Inspection Tasks that are overdue and associated with the Equipment or Functional Locations in the unit. This query is used to display results in the Overdue Tasks subsection in the Inspection Tasks subsection.
Top-Level Work Packs	Returns a list of top-level work packs in GE Digital APM. This query is used to display results in the Work Packs section.

The following table provides a list of queries that are used on the Inspection Management Overview page for the selected asset.

Query Name	Behavior and Usage
All Inspections for Asset	Returns a list of inspections performed on the selected asset. This query is used to display results in the Inspections section.
All Tasks for Asset	Returns a list of Inspection Tasks for the selected asset. This query is used to display results in the Inspection Tasks section.
Open Recommendations for Asset	Returns a list of Inspection Recommendations and RBI Recommendations for the given asset. This query is used to display results in the Recommendations section.
Top-Level Work Packs	Returns a list of top-level work packs in GE Digital APM. This query is used to display results in the Work Packs section.