Get More than One Record from AgilePoint NX Entity

Prerequisites

• AgilePoint NX OnDemand (public cloud), or AgilePoint NX PrivateCloud or AgilePoint NX OnPremises v7.0 or higher.

Good to Know

• In most text fields, you can use process data variables as an alternative to literal data values.
• You can configure whether this activity waits for other activities before it runs.

  For more information, refer to How Do I Configure an Activity to Wait for Other Incoming Activities?

How to Start

1. On the Application Explorer screen, do one of these:
   • Open a Process.
   • Create a Process.
2. Do one of these:
   • Add an activity:
     1. In the Process Builder, in the Activity Library, open the AgilePoint Data Entities tab.
     2. On the AgilePoint Data Entities tab, drag the Query Multiple Records activity onto your process.
   • Change an activity:
     1. In your process, double-click your activity.
3. Click Query Multiple Records Configuration .

Procedure

1. On the Query Multiple Configuration screen, in the Entity Name list, select your entity..
2. (Optional) Complete this field:

   Field Name	Definition
   Custom Entities Only	Function: Specifies whether to show only custom entities in the Primary Entity Name list. Accepted Values: Selected - Shows only the custom entities in the Primary Entity Name list. Deselected - Shows both standard entities and custom entities in the Primary Entity Name list. Default Value: Deselected Accepts Process Data Variables: No

3. To filter the records with a condition, do this procedure.
   1. On the Where tab, Click Create .
   2. On the Query Multiple Records Configuration > Create Conditions screen, in the Column field, select the entity field to use in your query.
   3. In the Comparer field, select the operator to compare the values in your logical expression.

      Field Name	Definition
      Comparer	Function: Specifies the operator to use in your query. Accepted Values: Equal NotEqual GreaterThan LessThan GreaterEqual LessEqual Like NotLike In NotIn Between NotBetween Null NotNull Yesterday Today Tomorrow Last7Days Next7Days LastWeek ThisWeek NextWeek LastMonth ThisMonth NextMonth On Default Value: Equal

   4. In the Value field, enter the value to compare or drag a process data variable from the Process Data screen.
   5. (Optional) Click Add Row to add a condition that can be connected to the previous expression with a logical AND or OR operator.
   6. (Optional) Click Subcondition to add a statement that adds a subordinate condition to a query.
   7. Click Back to save your condition.
4. Click the Response tab.
5. To connect the response to your process schema, complete this field as necessary.

   Field Name	Definition
   Map Response to AgilePoint Schema	Function: Maps AgilePoint NX entity fields to your schema. Accepted Values: Click the Schema Mapping button to open the Schema Mapper. Use this screen to connect the response to the data model for your process. Default Value: None