Show TOC

Procedure documentationLegacy: Selecting a Query to Execute Locate this document in the navigation structure

 

You use Query to execute query programs that reside in target ERP systems. You can use the queries to perform unplanned tests of non-SAP and SAP Query scripts.

Before setting up and running queries with Process Control, the query must already exist in the target ERP system. For more information about creating a query in the target system, see your system administrator.

Note Note

In the target SAP systems, we recommend that you create your queries using the user group type Standard Area. You may also create a rule using a rule script with type Query to automate query execution. For more information, see Rule Script Types.

End of the note.

Procedure

To execute or search for queries in target applications, perform the steps below.

  1. Choose   Rule Setup   Legacy Automated Monitoring   Query  

    The Find Queries screen displays.

  2. Choose one or more of the fields in the table below to filter your data. The system supports wildcards (*).

    Query Filters

    Filter

    Description

    Target Connector (required)

    Enter the target system where you want to search for a query program. To search for the available connectors, select the value help. Choose the desired connector and select OK.

    Query Name (optional)

    If you know the query name, enter it here.

    User Group (optional)

    If you know the name of the user group in the target system, enter it here.

  3. Select Go.

    The Query screen displays all queries based on your search criteria and authorization.

    Note Note

    The system only displays those queries on the target system that you are authorized to run.

    End of the note.

  4. Select the row of the query that you want to execute.

  5. Choose Select Query to Execute.

    The Query screen displays the query criteria.

  6. Enter your query criteria, keeping in mind the rules below:

    • You can specify the maximum rows you want the system to return in the Max Rows parameter. This can be useful to check the logic of your query and criteria.

    • Filter criteria can be optional or mandatory. This is defined in the query program.

    • The diamonds on the left of the criteria fields allow you to display Selection Options (operators to refine your query).

    • The arrows on the right of the criteria field enable you to make multiple selections.

  7. Choose Execute Query.

    The Query screen displays your query results.

  8. Choose Print Version to print the query results to a PDF file. To export the results to an Excel file, choose Export.