config_form_list - Giswater/giswater_dbmodel GitHub Wiki
Description:
Configuration table of table views visible on web forms.
Fields:
| Column name | Data type | Description | Example |
|---|---|---|---|
| listname | character varying(50) | Description | |
| query_text | text | Select with definition of visible fields | SELECT rid as sys_id, * FROM v_ui_node_x_connection_upstream WHERE rid IS NOT NULL |
| device | smallint | Device id | 3 |
| listtype | character varying(30) | Type of list | tab |
| listclass | character varying(30) | Class of list | list |
| vdefault | json | Definition of field order on table view | {"orderBy":"1", "orderType": "DESC"} |
| addparam | json | Description |