1. Orchestrator Guide for Studio Version 8 and Prior
  2. Configuring a Data Request to Return Field Data

Configuring a Data Request to Return Field Data

A data request includes filtering criteria and indicates the fields that contain data that you want returned. For example, a business analyst wants to add a data request to an orchestration that returns a customer's credit limit amount. The orchestration has "Customer Number" defined as in input. To configure the data request, the business analyst:

  • Sets up filter criteria with a condition that filters on Address Number.

  • Selects the Credit Limit and Alpha Name fields for the return data.

  • Adds the data request to the orchestration, mapping the Customer Number input in the orchestration to the Address Number in the data request.

    When the data request is added to the orchestration, the Credit Limit and Alpha Name fields automatically become additional inputs to the orchestration, which the business analyst can then map to subsequent orchestration steps.

> tutorial: Click here to view a recording of this feature.

To configure a data request to return field data:

  1. Create a data request as described in Creating a Service Request.

  2. In the Available Actions area, enter the name of the table or business view in the Table/View Name field.

    If you do not know the table or business view name, but you know the application that uses the table or business view, you can use the JD Edwards EnterpriseOne Cross Reference Facility (P980011) to identify the table or business view associated with the application. From the Cross Reference form, click the Interactive Applications tab, then click Business Views Used by an Interactive Application or Tables Used by an Interactive Application. If you do not have access to the Cross Reference Facility, ask an administrator to look up this information for you.

  3. Click the Load button.

    The Orchestrator Studio loads all fields from the table or business view into the grid.

    Note: You can use the Data Set Variable Name field to configure the data request to return a data set. See Retrieving and Passing Data Sets in an Orchestration (Orchestrator Studio 6.0.x) for more information.

  4. Define the filtering criteria for the data request:

    1. In the Fields grid on the left, click the "Filter" icon next to the field or fields that contain data that you want to filter on.

      The Orchestrator Studio displays each field in the Filter Criteria area on the right.

    2. For each field in the Conditions box, select the appropriate operand and in the adjacent field, enter a hard coded value or a variable.

      A variable appears in the field by default. If you modify the variable name, make sure the syntax includes the $ sign and brackets, for example:

      ${Address Number 1}

    3. Select the Match All or Match Any option to determine how the conditions are applied.

      You can also click the Options button, and from the Query drop-down list, select a predefined query to use for the filtering criteria. You can use a query instead of or in combination with the filtering criteria defined in a data request. The queries that you can see in this list are based on UDO security permissions.

  5. Specify the data you want returned:

    1. In the Fields grid, click the "Return" icon next to each field for which you want data returned.

      Each field appears in the "Return Fields and Variable Names" on the right.

    2. (Optional) You can use a variable for the return by entering a name for the variable in the adjacent blank field.

      Note: Return variables do not need the ${} notation. This notation is only necessary for input variables to distinguish between a variable and a hard coded value.

      When you add a data request to an orchestration, these variables are automatically added to the orchestration as inputs, which you can use to map return data to subsequent orchestration steps.

  6. (Optional) For the return data, determine the order by which you want the data returned:

    1. In the grid on the left, select the Order By icon next to any field that was selected for the return data.

      The Orchestrator Studio adds the field name to the Order By area on the right.

    2. In the drop-down list next to the field name, select Ascending or Descending.

  7. (Optional) Click the Options button to configure settings that control how the AIS Server processes a data request at runtime. See Configuring Form Request and Data Request Processing.