Queries Folder

The queries listed in the following table are provided in the Catalog folder \\Public\Meridium\Modules\Asset Strategy Management\Implementation\Queries. In this table, the values listed in the Query column refer to the query names. The baseline captions are the same as the names.

IMPORTANT: With the exception of the Get SAP ID for Equipment and Get SAP ID for Functional Location queries, you should not modify these queries in any way or move them to another Catalog folder. Also, while modifying the design of the Get SAP ID for Equipment and Get SAP ID for Functional Location queries is allowed, if you are using the baseline Equipment and Functional Location families, it is not necessary.

Query	Behavior and Usage
ASI - Package Count	Returns the number of packages that currently exist in the database.
ASI Overview Filter Query	Returns the parameters used for filtering on the ASI Overview page.
ASI Packages - No Assets	Returns all packages in the database, but without associated assets.
ASIAllPackages	Returns all packages that currently exist in the database.
Asset Is Equipment	This query is used in the ASI Action Mappings to determine if the Asset tied to the Asset Strategy is a piece of Equipment or a Functional Location. Counts greater than 0 represent Equipment where counts equal to 0 represent Functional Locations.
Get Equipment for SAP ID	Returns the Equipment record that contains the ID corresponding to the value supplied for the SAP Equipment ID prompt and is linked to the SAP System record identified by the value supplied for the SAP System prompt. In the baseline GE Digital APM database, the query returns records in the Equipment family. This query is not meant to be run on its own. Instead, the GE Digital APM system runs this query automatically to determine which Equipment record to link to the new Asset Strategy record when you create an Asset Strategy by importing Maintenance Items, Notifications, or Operations from SAP. When the GE Digital APM system runs this query, it performs several actions automatically: It passes the Equipment ID of the imported SAP item to the SAP Equipment ID prompt in the query. It locates the Site Reference record that you selected on the Select SAP Object(s) screen of the Asset Strategy Builder and locates the SAP System record that is linked to that Site Reference record. It then passes the value in the Name field in that SAP System record to the SAP System prompt in the query. If the query returns a record using the provided values, the GE Digital APM system links that record to the new Asset Strategy record. If the query does not return a record using that value, the GE Digital APM system runs the Get Functional Location for SAP ID query. Note: Because the documentation for importing SAP items to create Asset Strategies assumes that you began the workflow by importing Equipment and Functional Location records using the SAP Interfaces, this documentation assumes that you will link your Asset Strategy records to either an Equipment or Functional Location record. You will not, therefore, need to modify the baseline Get Equipment for SAP ID query to include a family other than the baseline Equipment family.
Get Functional Location for SAP ID	Returns the Functional Location record that contains the ID corresponding to the value supplied for the SAP Functional Location ID prompt and is linked to the SAP System record identified by the value supplied for the SAP System prompt. In the baseline GE Digital APM database, the query returns records in the Functional Location family. This query is not meant to be run on its own. Instead, the GE Digital APM system runs this query automatically to determine which Functional Location record to link to the new Asset Strategy record when you create an Asset Strategy by importing Maintenance Items, Notifications, or Operations from SAP. When the GE Digital APM system runs this query, it performs several actions automatically: It passes the Functional Location of the imported SAP item to the SAP Functional Location ID prompt in the query. It locates the Site Reference record that you selected on the Select SAP Object(s) screen of the Asset Strategy Builder and locates the SAP System record that is linked to that Site Reference record. It then passes the value in the Name field in that SAP System record to the SAP System prompt in the query. If the query returns a record using the provided values, the GE Digital APM system links that record to the new Asset Strategy record. Note: Because the documentation for importing SAP items to create Asset Strategies assumes that you began the workflow by importing Equipment and Functional Location records using the SAP Interfaces, this documentation assumes that you will link your Asset Strategy records to either an Equipment or Functional Location record. You will not, therefore, need to modify the baseline Get Functional Location for SAP ID query to include a family other than the baseline Functional Location family.
Get Package Implemented Action Count	Returns the number of implemented actions for a particular implementation package.
Get SAP ID for Equipment	After providing a prompt for an Entity Key, returns the record with the provided Entity Key. In the baseline GE Digital APM database, the query returns records in the Equipment family. This query is not meant to be run on its own. Instead, GE Digital APM runs this query automatically to determine whether to populate the Equipment or Functional Location field when you build Notification or Maintenance Item records from Actions.
Get SAP ID for Functional Location	After providing a prompt for an Entity Key, returns the record with the provided Entity Key. In the baseline GE Digital APM database, the query returns records in the Functional Location family. This query is not meant to be run on its own. Instead, it is run automatically to determine whether to populate the Equipment or Functional Location field when you build Notification or Maintenance Item records from Actions.

Query

Behavior and Usage

ASI - Package Count

Returns the number of packages that currently exist in the database.

ASI Overview Filter Query

Returns the parameters used for filtering on the ASI Overview page.

ASI Packages - No Assets

Returns all packages in the database, but without associated assets.

ASIAllPackages

Returns all packages that currently exist in the database.

Asset Is Equipment

This query is used in the ASI Action Mappings to determine if the Asset tied to the Asset Strategy is a piece of Equipment or a Functional Location. Counts greater than 0 represent Equipment where counts equal to 0 represent Functional Locations.

Get Equipment for SAP ID

Returns the Equipment record that contains the ID corresponding to the value supplied for the SAP Equipment ID prompt and is linked to the SAP System record identified by the value supplied for the SAP System prompt. In the baseline GE Digital APM database, the query returns records in the Equipment family.

This query is not meant to be run on its own. Instead, the GE Digital APM system runs this query automatically to determine which Equipment record to link to the new Asset Strategy record when you create an Asset Strategy by importing Maintenance Items, Notifications, or Operations from SAP. When the GE Digital APM system runs this query, it performs several actions automatically:

It passes the Equipment ID of the imported SAP item to the SAP Equipment ID prompt in the query.
It locates the Site Reference record that you selected on the Select SAP Object(s) screen of the Asset Strategy Builder and locates the SAP System record that is linked to that Site Reference record. It then passes the value in the Name field in that SAP System record to the SAP System prompt in the query.

If the query returns a record using the provided values, the GE Digital APM system links that record to the new Asset Strategy record. If the query does not return a record using that value, the GE Digital APM system runs the Get Functional Location for SAP ID query.

Note: Because the documentation for importing SAP items to create Asset Strategies assumes that you began the workflow by importing Equipment and Functional Location records using the SAP Interfaces, this documentation assumes that you will link your Asset Strategy records to either an Equipment or Functional Location record. You will not, therefore, need to modify the baseline Get Equipment for SAP ID query to include a family other than the baseline Equipment family.

Get Functional Location for SAP ID

Returns the Functional Location record that contains the ID corresponding to the value supplied for the SAP Functional Location ID prompt and is linked to the SAP System record identified by the value supplied for the SAP System prompt. In the baseline GE Digital APM database, the query returns records in the Functional Location family. This query is not meant to be run on its own. Instead, the GE Digital APM system runs this query automatically to determine which Functional Location record to link to the new Asset Strategy record when you create an Asset Strategy by importing Maintenance Items, Notifications, or Operations from SAP. When the GE Digital APM system runs this query, it performs several actions automatically:

It passes the Functional Location of the imported SAP item to the SAP Functional Location ID prompt in the query.
It locates the Site Reference record that you selected on the Select SAP Object(s) screen of the Asset Strategy Builder and locates the SAP System record that is linked to that Site Reference record. It then passes the value in the Name field in that SAP System record to the SAP System prompt in the query.

If the query returns a record using the provided values, the GE Digital APM system links that record to the new Asset Strategy record.

Note: Because the documentation for importing SAP items to create Asset Strategies assumes that you began the workflow by importing Equipment and Functional Location records using the SAP Interfaces, this documentation assumes that you will link your Asset Strategy records to either an Equipment or Functional Location record. You will not, therefore, need to modify the baseline Get Functional Location for SAP ID query to include a family other than the baseline Functional Location family.

Get Package Implemented Action Count

Returns the number of implemented actions for a particular implementation package.

Get SAP ID for Equipment

After providing a prompt for an Entity Key, returns the record with the provided Entity Key. In the baseline GE Digital APM database, the query returns records in the Equipment family. This query is not meant to be run on its own. Instead, GE Digital APM runs this query automatically to determine whether to populate the Equipment or Functional Location field when you build Notification or Maintenance Item records from Actions.

Get SAP ID for Functional Location

After providing a prompt for an Entity Key, returns the record with the provided Entity Key. In the baseline GE Digital APM database, the query returns records in the Functional Location family. This query is not meant to be run on its own. Instead, it is run automatically to determine whether to populate the Equipment or Functional Location field when you build Notification or Maintenance Item records from Actions.