21.1. Data

Data

If you want to check the layout distribution, you can go to Form Parts

The fields in the layout lyt_top_1 are:

Link Type: link_type - Type of link. It is auto-populated based on the linkcat_id
  • Datatype: String.
  • Mandatory: Sí.
  • Editable: No.
  • Dvquerytext: The values of this dropdown are determined by the query: SELECT id, id as idval FROM cat_feature_link WHERE id IS NOT NULL
  • Widgetcontrols: Field controls
    • setMultiline (False): Sets the possibility of multiline fields for writing with enter
    • labelPosition (top): If this value is defined [top, left, none], the label will occupy the relative position with respect to the widget. By default, left is understood. If the label field is empty, labelPosition is omitted.
    • valueRelation:
      • layer: ve_cat_feature_link
      • activated: True
      • keyColumn: id
      • nullValue: False
      • valueColumn: id
      • filterExpression: None
Linkcat Id: linkcat_id - To be selected from the catalog of arcs. It is independent of the type of arch
  • Datatype: String.
  • Mandatory: Sí.
  • Editable: Sí.
  • Dvquerytext: The values of this dropdown are determined by the query: SELECT id, id as idval FROM cat_link WHERE id IS NOT NULL AND active IS TRUE
  • Filterc: The previous query is filtered by: AND cat_link.link_type IS NULL OR cat_link.link_type
  • Widgetcontrols: Field controls
    • setMultiline (False): Sets the possibility of multiline fields for writing with enter
    • labelPosition (top): If this value is defined [top, left, none], the label will occupy the relative position with respect to the widget. By default, left is understood. If the label field is empty, labelPosition is omitted.
    • valueRelation:
      • layer: cat_link
      • activated: True
      • keyColumn: id
      • nullValue: False
      • valueColumn: id
      • filterExpression: None

The fields in the layout lyt_data_1 are:

Link Id: link_id - Link Id
  • Datatype: Integer.
  • Mandatory: No.
  • Editable: No.
  • Widgetcontrols: Field controls
    • setMultiline (False): Sets the possibility of multiline fields for writing with enter
Feature Type: feature_type - Feature type
  • Datatype: String.
  • Mandatory: No.
  • Editable: No.
  • Dvquerytext: The values of this dropdown are determined by the query: SELECT id, id as idval FROM sys_feature_type WHERE id IS NOT NULL
  • Widgetcontrols: Field controls
    • setMultiline (False): Sets the possibility of multiline fields for writing with enter
Exit Type: exit_type - Exit type
  • Datatype: String.
  • Mandatory: No.
  • Editable: No.
  • Dvquerytext: The values of this dropdown are determined by the query: SELECT id, idval FROM inp_typevalue WHERE typevalue='inp_pjoint_type'
  • Widgetcontrols: Field controls
    • setMultiline (False): Sets the possibility of multiline fields for writing with enter
Exit Id: exit_id - Exit Id
  • Datatype: String.
  • Mandatory: No.
  • Editable: No.
  • Widgetcontrols: Field controls
    • setMultiline (False): Sets the possibility of multiline fields for writing with enter
Omzone Id: omzone_id - Omzone Id
  • Datatype: Integer.
  • Mandatory: No.
  • Editable: No.
  • Dvquerytext: The values of this dropdown are determined by the query: SELECT omzone_id as id, name as idval FROM omzone WHERE omzone_id = 0 UNION SELECT omzone_id as id, name as idval FROM omzone WHERE omzone_id IS NOT NULL
  • Widgetcontrols: Field controls
    • setMultiline (False): Sets the possibility of multiline fields for writing with enter
    • valueRelation:
      • nullValue: False
      • layer: ve_dma
      • activated: True
      • keyColumn: dma_id
      • valueColumn: name
      • filterExpression: None
Fluid Type: fluid_type - fluid_type
  • Datatype: String.
  • Mandatory: Sí.
  • Editable: Sí.
  • Dvquerytext: The values of this dropdown are determined by the query: SELECT id, idval FROM om_typevalue WHERE typevalue = 'fluid_type'
  • Widgetcontrols: Field controls
    • setMultiline (False): Sets the possibility of multiline fields for writing with enter
Gis Length: gis_length - Gis length
  • Datatype: Double.
  • Mandatory: No.
  • Editable: No.
  • Widgetcontrols: Field controls
    • setMultiline (False): Sets the possibility of multiline fields for writing with enter

The fields in the layout lyt_data_2 are:

Is Operative: is_operative - is_operative
  • Datatype: Boolean.
  • Mandatory: No.
  • Editable: No.
  • Widgetcontrols: Field controls
    • setMultiline (False): Sets the possibility of multiline fields for writing with enter
Connecat Id: conneccat_id - A seleccionar del catálogo de acometida. Es independiente del tipo de acometida
  • Datatype: String.
  • Mandatory: No.
  • Editable: No.
  • Dvquerytext: The values of this dropdown are determined by the query: SELECT id, id as idval FROM cat_connec WHERE id IS NOT NULL AND active IS TRUE
  • Widgetcontrols: Field controls
    • setMultiline (False): Sets the possibility of multiline fields for writing with enter
    • valueRelation:
      • nullValue: False
      • layer: cat_connec
      • activated: True
      • keyColumn: id
      • valueColumn: id
      • filterExpression: None
Workcat Id: workcat_id - Related to the catalog of work files (cat_work). File that registers the element
  • Datatype: String.
  • Mandatory: No.
  • Editable: Sí.
  • Dvquerytext: The values of this dropdown are determined by the query: SELECT id, id as idval FROM cat_work WHERE id IS NOT NULL AND active IS TRUE
  • Widgetcontrols: Field controls
    • setMultiline (False): Sets the possibility of multiline fields for writing with enter
Workcat Id End: workcat_id_end - Id of the end of construction work.
  • Datatype: String.
  • Mandatory: No.
  • Editable: Sí.
  • Dvquerytext: The values of this dropdown are determined by the query: SELECT id, id as idval FROM cat_work WHERE id IS NOT NULL AND active IS TRUE
  • Widgetcontrols: Field controls
    • setMultiline (False): Sets the possibility of multiline fields for writing with enter
Builtdate: builtdate - Date the element was added. In insertion of new elements the date of the day is shown
  • Datatype: Date.
  • Mandatory: No.
  • Editable: Sí.
  • Widgetcontrols: Field controls
    • setMultiline (False): Sets the possibility of multiline fields for writing with enter
Enddate: enddate - End date of the element. It will only be filled in if the element is in a deregistration state.
  • Datatype: Date.
  • Mandatory: No.
  • Editable: Sí.
  • Widgetcontrols: Field controls
    • setMultiline (False): Sets the possibility of multiline fields for writing with enter
Top Elev 1: top_elev1 - top_elev1
  • Datatype: Integer.
  • Mandatory: No.
  • Editable: No.
  • Widgetcontrols: Field controls
    • setMultiline (False): Sets the possibility of multiline fields for writing with enter
Depth1: depth1 - depth1
  • Datatype: Integer.
  • Mandatory: No.
  • Editable: No.
  • Widgetcontrols: Field controls
    • setMultiline (False): Sets the possibility of multiline fields for writing with enter
Elevation1: elevation1 - elevation1
  • Datatype: Integer.
  • Mandatory: No.
  • Editable: No.
  • Widgetcontrols: Field controls
    • setMultiline (False): Sets the possibility of multiline fields for writing with enter
Top Elev 2: top_elev2 - top_elev2
  • Datatype: Integer.
  • Mandatory: No.
  • Editable: No.
  • Widgetcontrols: Field controls
    • setMultiline (False): Sets the possibility of multiline fields for writing with enter
Depth2: depth2 - depth2
  • Datatype: Integer.
  • Mandatory: No.
  • Editable: No.
  • Widgetcontrols: Field controls
    • setMultiline (False): Sets the possibility of multiline fields for writing with enter
Elevation2: elevation2 - elevation2
  • Datatype: Integer.
  • Mandatory: No.
  • Editable: No.
  • Widgetcontrols: Field controls
    • setMultiline (False): Sets the possibility of multiline fields for writing with enter
Exploitation Id: expl_id - Exploitation to which the element belongs. If the configuration is not changed, the program automatically selects it based on the geometry
  • Datatype: Integer.
  • Mandatory: No.
  • Editable: No.
  • Dvquerytext: The values of this dropdown are determined by the query: SELECT expl_id as id, name as idval FROM exploitation WHERE expl_id IS NOT NULL
  • Stylesheet: Aesthetic modifications of the field
    • label:
      • color: green
      • font-weight: bold
  • Widgetcontrols: Field controls
    • setMultiline (False): Sets the possibility of multiline fields for writing with enter
    • valueRelation:
      • nullValue: False
      • layer: ve_exploitation
      • activated: True
      • keyColumn: expl_id
      • valueColumn: name
      • filterExpression: None

The fields in the layout lyt_bot_1 are:

Sector Id: sector_id - Sector identifier.
  • Datatype: Integer.
  • Mandatory: No.
  • Editable: No.
  • Dvquerytext: The values of this dropdown are determined by the query: SELECT s.sector_id AS id, s.name AS idval FROM sector s WHERE s.sector_id IS NOT NULL AND s.active IS TRUE ORDER BY CASE WHEN s.sector_id = 0 THEN 1 WHEN s.sector_id = -1 THEN 3 ELSE 2 END, s.sector_id
  • Stylesheet: Aesthetic modifications of the field
    • label:
      • color: blue
      • font-weight: bold
  • Widgetcontrols: Field controls
    • setMultiline (False): Sets the possibility of multiline fields for writing with enter
    • labelPosition (top): If this value is defined [top, left, none], the label will occupy the relative position with respect to the widget. By default, left is understood. If the label field is empty, labelPosition is omitted.
    • valueRelation:
      • layer: ve_sector
      • activated: True
      • keyColumn: sector_id
      • nullValue: False
      • valueColumn: name
      • filterExpression: None
State: state - State:
  • Datatype: Integer.
  • Mandatory: No.
  • Editable: No.
  • Dvquerytext: The values of this dropdown are determined by the query: WITH psector_value AS ( SELECT value::integer AS psector_value FROM config_param_user WHERE parameter = 'plan_psector_current' AND cur_user = current_user), tg_op_value AS ( SELECT value::text AS tg_op_value FROM config_param_user WHERE parameter = 'utils_transaction_mode' AND cur_user = current_user) SELECT id::integer as id, name as idval FROM value_state WHERE id IS NOT NULL AND CASE WHEN (SELECT tg_op_value FROM tg_op_value)!='INSERT' THEN id IN (0,1,2) WHEN (SELECT tg_op_value FROM tg_op_value) ='INSERT' AND (SELECT psector_value FROM psector_value) IS NOT NULL THEN id = 2 ELSE id < 2 END
  • Widgetcontrols: Field controls
    • setMultiline (False): Sets the possibility of multiline fields for writing with enter
    • labelPosition (top): If this value is defined [top, left, none], the label will occupy the relative position with respect to the widget. By default, left is understood. If the label field is empty, labelPosition is omitted.
State Type: state_type - The state type of the element. It allows to obtain more detail of the state. To select from those available depending on the chosen state
  • Datatype: Integer.
  • Mandatory: No.
  • Editable: Sí.
  • Dvquerytext: The values of this dropdown are determined by the query: SELECT id, name as idval FROM value_state_type WHERE id IS NOT NULL
  • Filterc: The previous query is filtered by: AND value_state_type.state
  • Widgetcontrols: Field controls
    • setMultiline (False): Sets the possibility of multiline fields for writing with enter
    • labelPosition (top): If this value is defined [top, left, none], the label will occupy the relative position with respect to the widget. By default, left is understood. If the label field is empty, labelPosition is omitted.