SQL Include Text

Under the Table viewer there is a field labelled SQL Include Tab;

This field allows the user to modify the SELECT statement used to retrieve data from the SQL database by appending a WHERE statement. For the INCLUDE text to work it must conform to standard SQL syntax.

Some Eamples : inside this box you could put

assetID='PB46CRA'                           This will return a single line PB46CRA

assetID LIKE 'PB%'                               This will return multiple lines. All lines will begin with PB -

assetID LIKE 'PB*' AND assocKey LIKE '23%'   Return lines with assetID starting with PB and the assocKey starting with 23.

NOTES:
Values must be surrounded by ' single quotes.

Wildcard for like is % NOT *

The keywords AND and OR both work as you would expect.

Read an SQL guide for more information one the WHERE clause to get more details.