Configure the Query Get Tasks for Work Order Generation

The query Get Tasks for Work Order Generation is used to determine which Task records to use to create Orders in SAP.

The query contains the Task query source. For each record that is returned by the query, GE Digital APM will create an Order in SAP. The baseline query is configured to transfer Task records that meet specific criteria. If desired, you can modify the query to further limit the Task records that you want to transfer.

Steps

Access the Catalog page.
In the left pane, select Public, then select Meridium, then select Modules, then select SAP Integration Interfaces, and then select Queries.

A list of queries appears.
Select the Get Tasks for Work Order Generation query.

The workspace appears.
Select Design.
Modify the query to meet at least the following requirements:
- Contains the following column:
  - Field: ([Task].[Next Date]-[Task].[Call Horizon])
  - Alias: Expr
  - Criteria (>=(? :d :caption='Last Successful Execution Date': id=LAST_DATE) AND < Now())
- Includes at least one field from the source family record.

What's Next?

Return to the workflow for the next step in the deployment process.