Update the List Item that Alerted the Workflow

AVEVA Work Tasks allows you to update the list item that alerted the workflow using XML List Type XML Variable. Update Variable activity can be used to add/update an item to the list. To update an item you need to select the scope as Current from Choose the List Item to Work on options. You can also use List Navigator Activity to set the scope. With the help of a scenario, we will explain this function.

Assume that you have created a list called Purchase Orders with the following fields and alerted the workflow.

• 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 update an item in the same list. Follow the procedure.

To update the list item that alerted the workflow

1. Logon to the Enterprise Console and go to Workflow Designer page.

2. 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 the variable.

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

4. Click New Variable to add a new variable.

5. Type the variable name as 'purchaseorders'.

6. Select type as XML List from Type the drop-down list.

7. Type the List name in the Select List field or click the Query button to select the list. In this case, select 'Purchase Orders' list.

8. Select Current as the scope from the Choose the ListItem to work on options to point to an item in the Purchase Orders list.

9. Now you can see the XML nodes in a tree-view that are mapped to the controls while creating the list.

10. Then click Save Variable. A message is displayed saying ‘Variable Updated’. Close the window.

    Note: If you set the scope as New while creating the Xml List type XML variable, you can change it in to Current using List Navigator activity.

11. Drag and drop Update Variable activity to update an item in the list.

12. Click the More button in the Set Variables property.

13. Click the Select link and select the respective field of the XML List type XML Variable created for the list (in this case purchaseorders). The fields displayed in the tree-view are representing the XML nodes of the controls in the list.

14. Select a field for which you want to set the value from the tree menu. Then enter the value for the field in the right-hand side text box or click the Value button to set the value.

15. If you want to set the value, then select enter a value from the tree-view, and then enter the value. Also you can select variables or contents or any XML variables nodes directly by selecting the respective node from the tree-view. If you want to combine multiple node values, you can build an expression by selecting Build Expression.

16. Similarly, you can set the value for other fields that you want to update. In this case, you are only updating the field Title which has the value Order for Illustrator.

17. Click OK. When you execute this workflow, the item gets updated based on the value that you have set.