Filtering Records

A filter can be applied to any query using a simple language. The filter statement is used both on the Reader and Lookups.

Examples

To retrieve just the match which are GBP the ‘OSQL Where Statement’ would be:

CustomerID = 20010

Query elements can be joined with an AND statement:

ExternalRef = 'ORD000293949' And CustomerID = 'WebSales'