Creating Queries

Load Saved Query :

Double Click a Query in the Define Query Screen, or select a Query and then Click Modify.

Delete Saved Query :

Select a Query in the Define Query Screen and then Click Delete.

Preview Saved Query :

Select a Query in the Define Query Screen and then Click Run.

New Query :

Click New button in the Define Query Screen.

Give your New Query a name and write a description to make it more easily identifiable. Select a SharePoint List on which to base the new query. At this stage you can click Preview Query and review the set of SharePoint List items returned, allowing you to refine your query.

You may use an available SharePoint List View to restrict the returned items by selecting from those presented in the Select View control. When you select a List View to use, only the items in the view will be retrieved. Remove this restriction by simply deleting the value in the Select View control.

An alternative to using available SharePoint List Views is to fine tune your query by adding where clauses to filter your data, select an Order By Field and limit the records returned if you require.

If the Add Where Clause button is not enabled, then simply delete any text in the Select View control. List Views override CAML where clauses so they are mutually exclusive at this stage. At any point clicking the Preview Query button will show you the results of your current query specification.

When you are satisfied, click the Save button.