Table sola.system.query_field
Optionally defines the fields returned by the queries listed in the system.query table. It is not necessary to specify query fields for every dynamic query. Query fields are only required where the results displayed to the user will vary and localization of the field titles is required. For example the Information Tool in the map displays different result fields for each map layer in the same form.
Tags: FLOSS SOLA Extension, Reference Table, System Configuration

Generated by
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
Column Type Size Nulls Auto Default Children Parents Comments
query_name varchar 100 query_field_query_name_fk121 C
Identifier/name for the query
index_in_query int4 10 Indicates the position of the result field in the query result set. The index is zero based. The number must not exceed the number of fields in the select part of the query.
name varchar 100 Identifier/name for the query field
display_value varchar 200  √  null The title to display for the query field when presenting results to the user. This value supports localization.

Analyzed at Tue May 31 09:59 NZST 2016

Column(s) Type Sort Constraint Name
query_name + index_in_query Primary key Asc/Asc query_field_pkey
query_name + display_value Must be unique Asc/Asc query_field_display_value
query_name + name Must be unique Asc/Asc query_field_name
query_name Performance Asc query_field_query_name_fk121_ind

Close relationships  within of separation:

Excluded from diagram's relationships: approle_appgroup.change_action  user_pword_expiry.pword_change_user  appuser.change_action  appuser_appgroup.change_action  appuser.change_user  appuser_appgroup.change_time  appuser.rowidentifier  approle_appgroup.rowidentifier  appuser_appgroup.change_user  extracted_rows.rowidentifier  appuser_appgroup.rowversion  approle_appgroup.change_user  appuser_appgroup.rowidentifier  approle_appgroup.rowversion  appuser.rowversion  approle_appgroup.change_time  appuser.change_time