Page History
Anchor | ||||
---|---|---|---|---|
|
Table of Contents | ||
---|---|---|
|
Overview
Styleclass | ||
---|---|---|
| ||
...
Create a Freehand SQL Report
Styleclass | ||
---|---|---|
| ||
...
- 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.
horizontalrule |
---|
Styleclass | ||
---|---|---|
| ||