Queries screen - HxGN EAM - Version 11.07.01 - Feature Briefs - Hexagon

HxGN EAM Equipment Rankings

Language
English
Product
HxGN EAM
Search by Category
Feature Briefs
HxGN EAM Version
11.7.1

The Queries screen has these important attributes:

  1. Query - The unique identifier for the database query.

  2. Description - Short description of the query.

  3. SQL Statement - Actual database select statement. See the instructions on this screen for available features. In the context of equipment rankings, you can use the :OBJECT and :OBJECTORG parameters to bind your query to the relevant equipment the ranking is associated to. Also make sure that the query only returns one answer, i.e., one record and one column only.

    If the question is numeric obviously the returned column must also be numeric. For example: SELECT number FROM table WHERE equipment = :OBJECT and organization = :OBJECTORG.

    If the question has predefined answers, make sure the returned value is a character value and is matching with one of the provided answers. For example: SELECT answer FROM table WHERE equipment = :OBJECT and organization = :OBJECTORG.

    Additionally, you have access to parameter :RANKINGLEVEL to bind your query to the relevant level code of the equipment ranking. Note that this code must be globally unique across all equipment rankings. And for linear equipment records the from and to of any of the linear condition records can be represented in the query using the :FROMPOINT and :TOPOINT parameters.

    Click the Test SQL button to verify if the query passes the syntax test.

  4. Query Options - Make sure you select the relevant checkbox. If Equipment Ranking is selected the query will be listed as a possible selection on the Add / Edit Levels popup.

    Additionally, the system will also list Inbox and KPI queries there, because these queries also must return one row and one column. However, Inbox and KPI configurations do not support the use of the :OBJECT and :OBJECTORG parameters and therefore may be less relevant.

    For calculated numerical answers the system will not verify whether the resulting number is an Integer or whether the result falls between the stated Minimum and Maximum as defined on the Add / Edit Levels popup. If required, this must be coded in the query directly instead.