Set up List Query Scope

This property allows you to build the query for the list and retrieve the data based on the query. You need to point to any particular item to perform a task based on the respective item. This can be done by building the query using List Query.

To set up the list query scope

1. Select List Query as the scope and click Save. Click the edit icon of List Query property. The following screen is displayed.
   
    

2. Click the search icon. The following screen appears.
   
   

3. The following are the field values for List Query window:

   Field	Description
   List Name	Select the list from List Name drop-down.
   Table	By clicking on this text box,  a pop up allows you to select the corresponding table for query. The respective table name will display in the pop up window based on the list you select.
   Column	From this drop down you can select the column or field of the corresponding list.
   Operator	From this drop down you can select an operator (either one of =,>, <,>=, <=, <>, IN, Not IN, Like) to build the query.
   Type	From this drop down you can select a type. The value will be  automatically displayed in the text box.
   Condition	From this drop down you can select the condition [either of End, And, Or, '),' '('].
   Add	You can click this button to add a query in the field.
   Clear	You can click this button to clear the query contents.
   OK	You can click this button to save this query.
   Close	You can click this button to close this window.

4. Enter the details, and click Add to add the List Query.

5. Click OK and then click Close.

6. For example, you have a list named Workflow and you want to update the records that have the Id value '12345' and '6789' . This query can be built using list query.

7. Click the  icon to build the query for the list Workflow. The List Query screen appears.

8. The list name Workflow is selected automatically. If the list is not selected, select your list from the List Name drop-down. Click the Table field. The pop up window allows you to select the table of the 'Workflow'. 
   

9. Click SKEWorkflowDefinition. This will be displayed automatically in the text box. Here, the table names displayed in the tree view are the parent table (one on the top) and the child table (the one below).

10. Click the Column drop-down.

11. Select int1 from the options since the field Reference No is mapped to this column of the database.

12. Select '=' operator from the Operator drop-down list.

13. Select Value from the Type drop-down list.

14. Type '12345' in the text box.

15. Select OR from the Condition drop-down list to add another query. 
    

16. Click Add to add the condition in the text field.

    

17. Here, SKEWorkflowDefinition is the table name where the list has been stored and t2 is the internal name that has been used for the main table. If there is any child table, it will be displayed as t2. Id is in the field name, to which you want to point your XML variable and 12345 as the value for that field.

18. Repeat the same steps for the list item that has '6789' as Reference No.

19. Enter the value as '6789'.

20. Select End from the Condition drop-down list.

21. Click Add. The build query will be displayed in the text field. 
    

22. Click OK, and then click Close.
    

23. Click Update.

24. You can replace the value for the query, with the variables. To replace, select the text/value to be replaced, and then select the respective field from the drop-down list and click Append.  
     

25. Click Update, and then close the window.