10.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:

Element Catalog: elementcat_id - Element Catalog
  • Datatype: String.
  • Mandatory: Sí.
  • Editable: Sí.
  • Dvquerytext: The values of this dropdown are determined by the query: SELECT id, id as idval FROM cat_element WHERE element_type = 'EMANHOLE'
  • 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.

The fields in the layout lyt_data_1 are:

Code: code - Code
  • Datatype: String.
  • Mandatory: No.
  • Editable: Sí.
  • Widgetcontrols: Field controls
    • setMultiline (False): Sets the possibility of multiline fields for writing with enter
Number Of Elements: num_elements - Number of Elements
  • Datatype: Integer.
  • Mandatory: No.
  • Editable: Sí.
  • Widgetcontrols: Field controls
    • setMultiline (False): Sets the possibility of multiline fields for writing with enter
Function Type: function_type - Function Type
  • Datatype: String.
  • Mandatory: No.
  • Editable: Sí.
  • Dvquerytext: The values of this dropdown are determined by the query: SELECT function_type as id, function_type as idval FROM man_type_function WHERE 'ELEMENT'=ANY(feature_type) OR 'EORIFICE' = ANY(featurecat_id::text[])
  • Widgetcontrols: Field controls
    • setMultiline (False): Sets the possibility of multiline fields for writing with enter
Category Type: category_type - Category Type
  • Datatype: String.
  • Mandatory: No.
  • Editable: Sí.
  • Dvquerytext: The values of this dropdown are determined by the query: SELECT category_type as id, category_type as idval FROM man_type_category WHERE 'ELEMENT'=ANY(feature_type) OR 'EORIFICE' = ANY(featurecat_id::text[])
  • Widgetcontrols: Field controls
    • setMultiline (False): Sets the possibility of multiline fields for writing with enter
Location Type: location_type - Location Type
  • Datatype: String.
  • Mandatory: No.
  • Editable: Sí.
  • Dvquerytext: The values of this dropdown are determined by the query: SELECT location_type as id, location_type as idval FROM man_type_location WHERE 'ELEMENT'=ANY(feature_type) OR 'EORIFICE' = ANY(featurecat_id::text[])
  • Widgetcontrols: Field controls
    • setMultiline (False): Sets the possibility of multiline fields for writing with enter
Workcat Id: workcat_id - Workcat Id
  • 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 - Workcat Id End
  • 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
Built Date: builtdate - Built Date
  • Datatype: Date.
  • Mandatory: No.
  • Editable: Sí.
  • Widgetcontrols: Field controls
    • setMultiline (False): Sets the possibility of multiline fields for writing with enter
End Date: enddate - End Date
  • Datatype: Date.
  • Mandatory: No.
  • Editable: Sí.
  • Widgetcontrols: Field controls
    • setMultiline (False): Sets the possibility of multiline fields for writing with enter
Owner Catalog: ownercat_id - Owner Catalog
  • Datatype: String.
  • Mandatory: No.
  • Editable: Sí.
  • Dvquerytext: The values of this dropdown are determined by the query: SELECT id, id as idval FROM cat_owner WHERE id IS NOT NULL AND active IS TRUE
  • Widgetcontrols: Field controls
    • setMultiline (False): Sets the possibility of multiline fields for writing with enter
Brand: brand_id - brand_id
  • Datatype: Text.
  • Mandatory: No.
  • Editable: Sí.
  • Dvquerytext: The values of this dropdown are determined by the query: SELECT id, id as idval FROM cat_brand WHERE 'MANHOLE' = ANY(featurecat_id::text[])
Model: model_id - model_id
  • Datatype: Text.
  • Mandatory: No.
  • Editable: Sí.
  • Dvquerytext: The values of this dropdown are determined by the query: SELECT id, id as idval FROM cat_brand_model WHERE 'MANHOLE' = ANY(featurecat_id::text[])
Rotation: rotation - Rotation
  • Datatype: Double.
  • Mandatory: No.
  • Editable: Sí.
  • Widgetcontrols: Field controls
    • setMultiline (False): Sets the possibility of multiline fields for writing with enter
Top Elevation: top_elev - Top Elevation
  • Datatype: Double.
  • Mandatory: No.
  • Editable: Sí.
  • Widgetcontrols: Field controls
    • setMultiline (False): Sets the possibility of multiline fields for writing with enter

The fields in the layout lyt_data_2 are:

Exploitation Id: expl_id - Exploitation Id
  • Datatype: Integer.
  • Mandatory: No.
  • Editable: Sí.
  • 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

The fields in the layout lyt_data_3 are:

Municipality Id: muni_id - Identifier of the municipality
  • Datatype: String.
  • Mandatory: No.
  • Editable: Sí.
  • Dvquerytext: The values of this dropdown are determined by the query: SELECT muni_id as id, name as idval from v_ext_municipality WHERE muni_id IS NOT NULL
Observations: observ - Observations
  • Datatype: String.
  • Mandatory: No.
  • Editable: Sí.
  • Widgetcontrols: Field controls
    • setMultiline (True): Sets the possibility of multiline fields for writing with enter

The fields in the layout lyt_bot_1 are:

Sector Id: sector_id - Sector Id
  • Datatype: Integer.
  • Mandatory: No.
  • Editable: Sí.
  • 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.
State: state - State
  • Datatype: Integer.
  • Mandatory: No.
  • Editable: Sí.
  • 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 - State Type
  • 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
  • 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.