| Anchor | ||||
|---|---|---|---|---|
|
| Table of Contents | ||
|---|---|---|
|
Overview
To write freehand SQL reports you will need to be granted specific user access. SQL reports require knowledge of ‘Structured Query Language’ and a sound knowledge of the data source that you wish to query.
...
- 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) - Clicking on “Validate” will inform you if the SQL syntax is valid, as well as the number of parameters present.
