Condition (Where Clause)

To limit the amount of data fetched from database we should always use conditions.

To add a condition click on Display Condition… button.

This will show following screen

Here select field to which you want to apply condition, select the type of condition and the value for that condition which can either be a Value or Parameter or Result of Query.

Now click on the Save button to add the condition.

This way create as many conditions you require and finally click on Save to save all the conditions you have created.

Once your query is completed click on Save button to save your query and when prompted to generate Web-service click on Yes.