Config Queries Folder

The Catalog folder \\Public\Meridium\Modules\Inspection\Config Queries contains the following items.

Query	Behavior and Usage
Asset Query	This query is used to identify the records that store information about pieces of equipment for which you perform inspections. In the baseline database, this query returns a count of all Equipment records with the Entity Key specified in the query prompt (i.e., one or zero).
Base Summary Query	Used by the Inspection History Summary Query.
Inspection History Summary Query	Returns a list of all Inspection records that are linked to a certain Equipment or Functional Location record. This query uses the Base Summary Query to determine the Entity Key of the Equipment or Functional Location record.
Published Documents	Returns a list of all Inspection records whose Published fields are set to true. This query contains a Load Inspection hyperlink that lets you open Inspection records in the Record Manager.
Published Documents by Asset	This query returns the same results as the Published Documents query; however, this query contains a prompt on the Asset Key field in the Inspection record.
User Key for HR Key	Returns the Entity Key of each Security User record and the Entity Key of each Human Resource record to which that Security User record is linked. This query exists simply to support the workflow facilitated by the following queries, which exist in the Review Queries folder: Bundle Inspections for Review for Current User - Choose State Bundle Inspections Pending Approval for Current User Full Inspections for Review for Current User - Choose State Full Inspections Pending Approval for Current User General Inspections for Review for Current User - Choose State General Inspections Pending Approval for Current User Pressure Inspections Pending Approval for Current User Pressure Test Inspections for Review for Current User - Choose State