Iterate through the List Item and Grid Item of the List

AVEVA Work Tasks allows you to loop through the list items and grid items of a list. An XML List Iterator type XML variable can be used to iterate through the list items, where XML Iterator type XML variable can be used to iterate through the grid items of a list. This feature can be explained with the help of a Purchase Order list scenario.

The Purchase Orders contain details like:

• Reference Number

• Purchase Order Date

• Raised By User

• Deliver To User

• Status

• Purchase Order Details

  • Item Name

  • Quantity

  • Unit Price

  • Item Total

• Total Purchase Amount

Now you want to loop through the approved purchase order items (items with status as Approved) as well as its child items.

To iterate through the list item and grid item of the list

1. Login to the Enterprise Console and go to Workflow Designer.

   Note: As a first step, you need to create an XML List type XML variable for the Purchase Orders list. If the variable is not created, follow the procedure mentioned below to create a variable.

2. Click the More button in the XMLVariables property from the Start Activity Properties.

3. Click New Variable to add a new variable.

4. Enter the variable name as purchaseorders.

5. Select XML List from the Type drop-down list.

6. Enter the List name or click the Select List to select the list. In this case, select Purchase Orders list.

7. Select the scope from the Choose the ListItem to work on options. Later you can change the scope of the variable to List Query to query the approved purchase orders using List Navigator activity.

8. Click Save Variable. A message is displayed saying ‘Variable Updated’.

9. Now, you need to create XML List Iterator type XML variable to iterate through the approved purchase order items. For that click New Variable from the XML Variable screen.

10. Type the variable name as purchaseorderiterator.

11. Select XML List Iterator from the Type drop-down list.

12. Select purchaseorders from the List XML Variable drop-down list.

13. Click Save Variable. A message is displayed saying ‘Variable Updated’.

14. Now, you need to create XML Iterator type XML variable for the purchaseorderiIterator (XML List Iterator type) XML variable to iterate through the child nodes of the currently iterating purchase order item. For that click New Variable from the XML Variable screen.

15. Type the variable name as purchaseorderdetails.

16. Select XML Iterator from the Type drop-down list.

17. Select purchaseorderiterator from the XML Variable drop-down list.

18. From the Node Select drop-down LIST, select the repeating node, i.e. PurchaseOrderDetails.

19. Click Save Variable. A message is displayed saying ‘Variable Updated’.

20. Use List Navigator activity to query the approved purchase order items.

    In this case, the following query is used to retrieve the approved purchase orders. SKEListItemDataNV(t1).nvarchar3 = 'Approved', where SKEListItemDataNV is the table used to store the list items and nvarchar3 is the table column mapped to the Status field.

21. Use ForEach-Loop and Next Loop activities to loop through the approved purchase order items.

22. Select purchaseordersiterator from the XML Iterator drop-down list of ForEach Loop activity.

23. Use any action as per the requirement to retrieve the data. You need to access the value of the parent nodes from the purchaseordersiterator XML variable.

24. Use another set of ForEach-Loop and Next activities within the existing loop to iterate through the grid items (PurchaseOrderDetails).

25. Select purchaseorderdetails from the XML Iterator drop-down list of ForEach Loop activity.

26. Use any action as per the requirement to retrieve the data. You need to access the value of the parent nodes from the purchaseorderdetails XML variable.