Set up the 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 any task based on that 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. Then click the Query button of List Query property.

2. Click the Query button. The List Query dialog box appears.

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

   Field	Description
   ListName	Select the list from List Name drop-down list.
   Table	By clicking on this textbox,  a popup allows you to select the corresponding table for query. The respective table name will display in the popup window based on the list selected by the user.
   Column	You can select this drop-down list to select the column or field of the corresponding list.
   Operator	You can select this drop-down list to select an operator (either one of =,>, <,>=, <=, <>, IN, Not IN, Like) to build the query.
   Type	You can select this drop-down list to select a type. The value is automatically displayed in the textbox.
   Condition	You can select this drop-down list to 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. As an example, you have a list named 'Purchase Orders' and you want to update the records that have the Reference No value '456789' and  '123456' . This query can be built using list query.

7. Click the Query button to build the query for the list 'Purchase Orders'.

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

9. Click on SKEListItemDataNV. This will display 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 (below one).

10. Click the Column drop-down list.

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 '456789' in the textbox.

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

16. Click Add to add the condition in the textfield.

17. Here, SKEListItemDataNV is the table name where the list has been stored and t1 is the internal name that has been used for the main table. If there is any child table also, it will display as t2. int1 in the field name, to that you need to point your XML variable and 456789 is the value for that field.

18. Repeat the same steps for the list item having '123456' as Reference No.

19. Enter the value as '123456'.

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. A list query that uses a variable will look like this :  (SKEListItemDataNV(t1).int1 = '<%#XmlVariables.purchaseorders.PurchaseOrders.ReferenceNo%>'.

26. Click Update and close the window.