Catalog Items

Queries Folder

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

Query NameBehavior and Usage
LOPA Approved QueryReturns the list of LOPA that are in the Complete state. This query populates the Approved section on the LOPA Overview page with the list of LOPA that is retrieved.
LOPA Under Review Query Returns the list of LOPA that are not in the Complete state. This query populates the Under Review section of the LOPA Overview page with the list of LOPA that is retrieved.
ALL LOPA QueryReturns the list of LOPA associated with a specific Site. This query is used to display a list of LOPA that you can link to a Hazards Analysis Consequence.
Consequence Modifier LOPA QueryReturns the list of Conditional Modifiers that are associated with a LOPA.
Safeguard LOPA QueryReturns the list of Safeguards that are associated with a LOPA.
LOPA Page Filter QueryReturns the list of LOPA that are associated with the Equipment or Functional Location that you choose.
LOPA_ASSET_CONTEXT_APPROVEDReturns the list of LOPA that are in the Complete state and are associated with the Equipment or Functional Location that you choose.
LOPA_ASSET_CONTEXT_UNDER_REVIEWReturns the list of LOPA that are not in the Complete state and are associated with the Equipment or Functional Location that you choose.
IPL Checklist Admin QueryReturns the list of IPL criteria that have been configured in the LOPA Application Settings. This query is used to display the criteria in the IPL Checklist workspace in LOPA Application Settings.
Active IPL QueryReturns the list of Active IPL records. This query is used to display the Active IPL ID and the Default Value fields in the Active IPL workspace in LOPA Application Settings.
Consequence Adjustment Probabilities QueryReturns the list of Consequence Adjustment Probabilities records. This query is used to display the Modifier ID and the Default Value fields in the Consequence Adjustment Probabilities workspace in LOPA Application Settings.
Human IPL QueryReturns the list of Human IPL records. This query is used to display the Human IPL ID and the Default Value fields in the Human IPL workspace in LOPA Application Settings.
Initiating Event type queryReturns the list of Initiating Events. This query is used to display the Initiating Event ID, Default Value, Lower Boundary, and Upper Boundary fields in the Initiating Events workspace in LOPA Application Settings.
Passive IPL QueryReturns the list of the Passive IPL records. This query is used to display the Passive IPL ID and the Default Value fields in the Passive IPL workspace in LOPA Application Settings.