Page History

...

To write freehand SQL reports you will need to be granted specific user access. SQL reports require knowledge of 'Structured ‘Structured Query Language' Language’ and a sound knowledge of the data source that you wish to query.

...

1. The inclusion of user prompt or source filter in your SQL reports is done by adding a {?} parameter.
   For example: select * from client where country = {?}
   If inserting a source filter with multiple possible input parameters use: select * from client where country in ({?}) (Note the additional Brackets)
2. Clicking on "Validate" “Validate” will inform you if the SQL syntax is valid, as well as the number of parameters present.
   

...