config_report - Giswater/giswater_dbmodel GitHub Wiki
Description:
Configuration table used for raport tool. Definition of raports, defined on database as SQL queries, available for user in Giwater toolbox.
Fields:
| Column name | Data type | Description | Example |
|---|---|---|---|
| id | integer | Additional description for the report | |
| alias | text | This is the name that goes to the toolbox | |
| query_text | text | Field where you write the query through which you want to generate the report | |
| addparam | json | Additional parameters | |
| filterparam | json | Description | |
| sys_role | text | Permission role of the user who has access to report, non-customizable, defined on sys_role | |
| descript | text | Descript | |
| active | boolean | If true, catalog value is being used | |
| device | integer[] | Description |