You can use the View query module to create data queries using predefined database views and thus control user access permissions.
Property | Meaning |
---|---|
Name |
Name of the data source. |
Description |
Description of data source. |
Max. lines |
Maximum number of result lines for this query. If this number is exceeded, the report stops generating. |
Parent query |
Not used. |
Query module |
Select the View query module. |
View name |
Name of the database view. |
Condition |
Condition for limiting the data set returned from the database table. You formulate the condition as a valid WHERE clause for database queries. You may use SQL parameters in the condition. Add these parameters subsequently to the report by entering them on the Parameters tab. Syntax for parameters: @<Parametername> |
Sort order |
The data queries are sorted by these database view columns. |