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

Connec Type: connec_type - connec_type
  • Datatype: String.
  • Mandatory: No.
  • Editable: No.
  • 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.
Conneccat Id: conneccat_id - conneccat_id
  • Datatype: String.
  • Mandatory: Sí.
  • Editable: Sí.
  • 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
  • Filterc: The previous query is filtered by: AND connec_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_connec
      • activated: True
      • keyColumn: id
      • nullValue: False
      • valueColumn: id
      • filterExpression: None
Arc Id: arc_id - Arc identifier
  • Datatype: String.
  • Mandatory: No.
  • Editable: No.
  • Dvquerytext: The values of this dropdown are determined by the query: SELECT arc_id as id, arc_id as idval FROM arc WHERE arc_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.
Epa Type: epa_type - Epa type
  • Datatype: String.
  • Mandatory: Sí.
  • Editable: Sí.
  • Dvquerytext: The values of this dropdown are determined by the query: SELECT id, id as idval FROM sys_feature_epa_type WHERE active IS TRUE AND feature_type = 'CONNEC'
  • 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: Text.
  • Mandatory: No.
  • Editable: Sí.
  • Widgetcontrols: Field controls
    • setMultiline (False): Sets the possibility of multiline fields for writing with enter
Top Elevation: top_elev - Elevation of the connec in ft or m.
  • Datatype: Double.
  • Mandatory: No.
  • Editable: Sí.
  • Widgetcontrols: Field controls
    • setMultiline (False): Sets the possibility of multiline fields for writing with enter
Datasource: datasource - datasource
  • Datatype: Integer.
  • Mandatory: No.
  • Editable: Sí.
  • Dvquerytext: The values of this dropdown are determined by the query: SELECT id, idval FROM edit_typevalue WHERE typevalue = 'value_datasource'
  • Widgetcontrols: Field controls
    • setMultiline (False): Sets the possibility of multiline fields for writing with enter
Cat Matcat Id: cat_matcat_id - cat_matcat_id
  • Datatype: String.
  • Mandatory: No.
  • Editable: No.
  • Widgetcontrols: Field controls
    • setMultiline (False): Sets the possibility of multiline fields for writing with enter
Cat Pnom: cat_pnom - cat_pnom
  • Datatype: String.
  • Mandatory: No.
  • Editable: No.
  • Widgetcontrols: Field controls
    • setMultiline (False): Sets the possibility of multiline fields for writing with enter
Cat Dnom: cat_dnom - cat_dnom
  • Datatype: String.
  • Mandatory: No.
  • Editable: No.
  • 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
Builtdate: builtdate - builtdate
  • Datatype: Date.
  • Mandatory: No.
  • Editable: Sí.
  • Widgetcontrols: Field controls
    • setMultiline (False): Sets the possibility of multiline fields for writing with enter
Owner: ownercat_id - Id of the owner related to connect.
  • 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
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
Enddate: enddate - Enddate
  • Datatype: Date.
  • Mandatory: No.
  • Editable: Sí.
  • Widgetcontrols: Field controls
    • setMultiline (False): Sets the possibility of multiline fields for writing with enter
Minsector Id: minsector_id - minsector_id
  • Datatype: Integer.
  • Mandatory: No.
  • Editable: No.
  • Widgetcontrols: Field controls
    • setMultiline (False): Sets the possibility of multiline fields for writing with enter
Dqa: dqa_id - dqa_id
  • Datatype: Integer.
  • Mandatory: No.
  • Editable: No.
  • Dvquerytext: The values of this dropdown are determined by the query: SELECT dqa_id as id, name as idval FROM dqa WHERE dqa_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: ve_dqa
      • activated: True
      • keyColumn: dqa_id
      • valueColumn: name
      • filterExpression: None
Staticpressure: staticpressure - staticpressure
  • Datatype: Integer.
  • Mandatory: No.
  • Editable: No.
  • Widgetcontrols: Field controls
    • setMultiline (False): Sets the possibility of multiline fields for writing with enter
Link: link - link
  • Datatype: String.
  • Mandatory: No.
  • Editable: No.
  • Widgetcontrols: Field controls
    • setMultiline (False): Sets the possibility of multiline fields for writing with enter
N Hydrometer: n_hydrometer - n_hydrometer
  • Datatype: Integer.
  • Mandatory: No.
  • Editable: No.
  • Widgetcontrols: Field controls
    • setMultiline (False): Sets the possibility of multiline fields for writing with enter
Om State: om_state - om_state
  • Datatype: String.
  • Mandatory: No.
  • Editable: Sí.
Conserv State: conserv_state - conserv_state
  • Datatype: String.
  • Mandatory: No.
  • Editable: Sí.
Access Type: access_type - access_type
  • Datatype: String.
  • Mandatory: No.
  • Editable: Sí.
Placement Type: placement_type - Placement Type
  • Datatype: String.
  • Mandatory: No.
  • Editable: Sí.
Priority: priority - priority
  • Datatype: String.
  • Mandatory: No.
  • Editable: Sí.
Valve Location: valve_location - valve_location
  • Datatype: String.
  • Mandatory: No.
  • Editable: Sí.
Valve Type: valve_type - valve_type
  • Datatype: String.
  • Mandatory: No.
  • Editable: Sí.
Shutoff Valve: shutoff_valve - shutoff_valve
  • Datatype: String.
  • Mandatory: No.
  • Editable: Sí.
Plot Code: plot_code - plot_code
  • Datatype: Text.
  • Mandatory: No.
  • Editable: Sí.
Serial Number: serial_number - serial_number
  • Datatype: Text.
  • Mandatory: No.
  • Editable: Sí.
Label Quadrant: label_quadrant - label_quadrant
  • Datatype: Text.
  • Mandatory: No.
  • Editable: Sí.
  • Dvquerytext: The values of this dropdown are determined by the query: select id, idval from edit_typevalue where typevalue = 'label_quadrant'
Cat Valve: cat_valve - cat_valve
  • Datatype: String.
  • Mandatory: No.
  • Editable: Sí.
Macrominsector Id: macrominsector_id - macrominsector_id
  • Datatype: Integer.
  • Mandatory: No.
  • Editable: No.
Cat Dint: cat_dint - cat_dint
  • Datatype: String.
  • Mandatory: No.
  • Editable: No.
Supplyzone Id: supplyzone_id - supplyzone_id
  • Datatype: Text.
  • Mandatory: No.
  • Editable: Sí.
Brand: brand - brand
  • Datatype: String.
  • Mandatory: No.
  • Editable: Sí.
Model: model - model
  • Datatype: String.
  • Mandatory: No.
  • Editable: Sí.
Top Floor: top_floor - Top floor
  • Datatype: Integer.
  • Mandatory: No.
  • Editable: Sí.
Wjoin Type: wjoin_type - wjoin_type
  • Datatype: String.
  • Mandatory: No.
  • Editable: Sí.
N Inhabitants: n_inhabitants - n_inhabitants
  • Datatype: Integer.
  • Mandatory: No.
  • Editable: Sí.
Lock Level: lock_level - lock_level
  • Datatype: Integer.
  • Mandatory: No.
  • Editable: Sí.
  • Dvquerytext: The values of this dropdown are determined by the query: SELECT id, idval FROM edit_typevalue WHERE typevalue = 'value_lock_level'
Block Code: block_code - block_code
  • Datatype: Text.
  • Mandatory: No.
  • Editable: Sí.

The fields in the layout lyt_data_2 are:

Customer Code: customer_code - Account code
  • Datatype: String.
  • Mandatory: No.
  • Editable: Sí.
  • Widgetcontrols: Field controls
    • setMultiline (False): Sets the possibility of multiline fields for writing with enter
Soilcat Id: soilcat_id - Id of the soil related to the connect.
  • Datatype: String.
  • Mandatory: No.
  • Editable: Sí.
  • Dvquerytext: The values of this dropdown are determined by the query: SELECT id, id as idval FROM cat_soil WHERE id IS NOT NULL AND active IS TRUE
  • 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 ((featurecat_id is null AND 'CONNEC'=ANY(feature_type))) AND active IS TRUE OR 'VCONNEC' = ANY(featurecat_id::text[])
  • Widgetcontrols: Field controls
    • setMultiline (False): Sets the possibility of multiline fields for writing with enter
Fluid Type: fluid_type - Tipo de fluido a escoger en el desplegable personalizado por el usuario en la tabla man_type_fluid
  • Datatype: String.
  • Mandatory: No.
  • Editable: No.
  • Dvquerytext: The values of this dropdown are determined by the query: SELECT fluid_type as id, fluid_type as idval FROM man_type_fluid WHERE ((featurecat_id is null AND 'CONNEC'=ANY(feature_type)) ) AND active IS TRUE OR 'VCONNEC' = 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 ((featurecat_id is null AND 'CONNEC'=ANY(feature_type)) ) AND active IS TRUE OR 'VCONNEC' = ANY(featurecat_id::text[])
  • Widgetcontrols: Field controls
    • setMultiline (False): Sets the possibility of multiline fields for writing with enter
Catalog Label: label - Label from the catalog of connecs, therefore it will not be editable in the form
  • Datatype: String.
  • Mandatory: No.
  • Editable: No.
  • Widgetcontrols: Field controls
    • setMultiline (False): Sets the possibility of multiline fields for writing with enter
Label X: label_x - label_x
  • Datatype: String.
  • Mandatory: No.
  • Editable: Sí.
  • Widgetcontrols: Field controls
    • setMultiline (False): Sets the possibility of multiline fields for writing with enter
Label Y: label_y - label_y
  • Datatype: String.
  • Mandatory: No.
  • Editable: Sí.
  • Widgetcontrols: Field controls
    • setMultiline (False): Sets the possibility of multiline fields for writing with enter
Label Rotation: label_rotation - Angle of rotation of the label
  • Datatype: Double.
  • Mandatory: No.
  • Editable: Sí.
  • Widgetcontrols: Field controls
    • setMultiline (False): Sets the possibility of multiline fields for writing with enter
Rotation: rotation - rotation
  • Datatype: Double.
  • Mandatory: No.
  • Editable: Sí.
  • Widgetcontrols: Field controls
    • setMultiline (False): Sets the possibility of multiline fields for writing with enter
Verified: verified - verified
  • Datatype: Integer.
  • Mandatory: No.
  • Editable: Sí.
  • Dvquerytext: The values of this dropdown are determined by the query: SELECT id, idval FROM edit_typevalue WHERE typevalue = 'value_verified'
  • Widgetcontrols: Field controls
    • setMultiline (False): Sets the possibility of multiline fields for writing with enter
Presszone: presszone_id - Related to the pressure zone catalog
  • Datatype: Integer.
  • Mandatory: No.
  • Editable: Sí.
  • Dvquerytext: The values of this dropdown are determined by the query: SELECT presszone.presszone_id as id, name as idval FROM presszone WHERE presszone_id='0' UNION SELECT presszone.presszone_id AS id, presszone.name AS idval FROM presszone WHERE presszone_id IS NOT NULL AND active IS TRUE
  • Filterc: The previous query is filtered by: AND presszone.expl_id
  • Widgetcontrols: Field controls
    • setMultiline (False): Sets the possibility of multiline fields for writing with enter
    • valueRelation:
      • layer: ve_presszone
      • activated: True
      • keyColumn: presszone_id
      • nullValue: False
      • valueColumn: name
      • filterExpression: None
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: 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
    • valueRelation:
      • layer: ve_exploitation
      • activated: True
      • keyColumn: expl_id
      • nullValue: False
      • valueColumn: name
      • filterExpression: None
Workcat Id Plan: workcat_id_plan - workcat_id_plan
  • 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
  • Widgetcontrols: Field controls
    • setMultiline (False): Sets the possibility of multiline fields for writing with enter
Asset Id: asset_id - asset_id
  • Datatype: String.
  • Mandatory: No.
  • Editable: Sí.
Press Max: press_max - press_max
  • Datatype: Numeric.
  • Mandatory: No.
  • Editable: No.
Press Min: press_min - press_min
  • Datatype: Numeric.
  • Mandatory: No.
  • Editable: No.
Press Avg: press_avg - press_avg
  • Datatype: Numeric.
  • Mandatory: No.
  • Editable: No.
Crmzone Id: crmzone_id - crmzone_id
  • Datatype: String.
  • Mandatory: No.
  • Editable: Sí.
  • Dvquerytext: The values of this dropdown are determined by the query: SELECT id, name as idval FROM crmzone WHERE id IS NOT NULL AND active IS TRUE
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 'VCONNEC' = ANY(featurecat_id::text[]) OR featurecat_id IS NULL
  • Widgetcontrols: Field controls
    • setMultiline (False): Sets the possibility of multiline fields for writing with enter
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 'VCONNEC' = ANY(featurecat_id::text[]) OR featurecat_id IS NULL
  • Widgetcontrols: Field controls
    • setMultiline (False): Sets the possibility of multiline fields for writing with enter

The fields in the layout lyt_data_3 are:

Muni Id: muni_id - muni_id
  • Datatype: Integer.
  • 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
  • Widgetcontrols: Field controls
    • setMultiline (False): Sets the possibility of multiline fields for writing with enter
Postcode: postcode - Postal code of the municipality
  • Datatype: String.
  • Mandatory: No.
  • Editable: Sí.
  • Widgetcontrols: Field controls
    • setMultiline (False): Sets the possibility of multiline fields for writing with enter
District: district_id - Identifier of the neighborhood with which the element is linked. To choose from those available in the drop-down (it is filtered according to the selected municipality)
  • Datatype: Integer.
  • Mandatory: No.
  • Editable: Sí.
  • Dvquerytext: The values of this dropdown are determined by the query: SELECT a.district_id AS id, a.name AS idval FROM ext_district a JOIN ext_municipality m USING (muni_id) WHERE district_id IS NOT NULL
  • Filterc: The previous query is filtered by: AND m.muni_id
  • Widgetcontrols: Field controls
    • setMultiline (False): Sets the possibility of multiline fields for writing with enter
Streetname: streetaxis_id - streetname
  • Datatype: String.
  • Mandatory: No.
  • Editable: Sí.
  • Dvquerytext: The values of this dropdown are determined by the query: SELECT id AS id, a.descript AS idval FROM v_ext_streetaxis a JOIN ext_municipality m USING (muni_id) WHERE id IS NOT NULL
  • Filterc: The previous query is filtered by: AND m.name
  • Widgetcontrols: Field controls
    • setMultiline (False): Sets the possibility of multiline fields for writing with enter
Street Number: postnumber - Street number
  • Datatype: Integer.
  • Mandatory: No.
  • Editable: Sí.
  • Dvquerytext: The values of this dropdown are determined by the query: SELECT a.postnumber AS id, a.postnumber AS idval FROM ext_address a JOIN ext_streetaxis m ON streetaxis_id=m.id WHERE a.id IS NOT NULL
  • Filterc: The previous query is filtered by: AND m.name
  • Widgetcontrols: Field controls
    • setMultiline (False): Sets the possibility of multiline fields for writing with enter
Optional Complement Of The Street Number: postcomplement - Optional complement of the street number
  • Datatype: String.
  • Mandatory: No.
  • Editable: Sí.
  • Widgetcontrols: Field controls
    • setMultiline (False): Sets the possibility of multiline fields for writing with enter
Streetname2: streetaxis2_id - streetname2
  • Datatype: String.
  • Mandatory: No.
  • Editable: Sí.
  • Dvquerytext: The values of this dropdown are determined by the query: SELECT id AS id, a.descript AS idval FROM v_ext_streetaxis a JOIN ext_municipality m USING (muni_id) WHERE id IS NOT NULL
  • Filterc: The previous query is filtered by: AND m.name
  • Widgetcontrols: Field controls
    • setMultiline (False): Sets the possibility of multiline fields for writing with enter
Second Street Number: postnumber2 - Second street number
  • Datatype: Integer.
  • Mandatory: No.
  • Editable: Sí.
  • Dvquerytext: The values of this dropdown are determined by the query: SELECT a.postnumber AS id, a.postnumber AS idval FROM ext_address a JOIN ext_streetaxis m ON streetaxis_id=m.id WHERE a.id IS NOT NULL
  • Filterc: The previous query is filtered by: AND m.name
  • Widgetcontrols: Field controls
    • setMultiline (False): Sets the possibility of multiline fields for writing with enter
Postcomplement2: postcomplement2 - postcomplement2
  • Datatype: String.
  • Mandatory: No.
  • Editable: Sí.
  • Widgetcontrols: Field controls
    • setMultiline (False): Sets the possibility of multiline fields for writing with enter
Junction Point Id: pjoint_id - Identifier of the connection point with the network
  • Datatype: String.
  • Mandatory: No.
  • Editable: No.
  • Widgetcontrols: Field controls
    • setMultiline (False): Sets the possibility of multiline fields for writing with enter
Pjoint Type: pjoint_type - pjoint_type
  • Datatype: String.
  • Mandatory: No.
  • Editable: No.
  • Widgetcontrols: Field controls
    • setMultiline (False): Sets the possibility of multiline fields for writing with enter
Observation: observ - Observations related to connect. Additional information
  • Datatype: String.
  • 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_bot_1 are:

Sector Id: sector_id - Hydraulic sector identifier related to the primary key of sector table
  • 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.
    • valueRelation:
      • layer: ve_sector
      • activated: True
      • keyColumn: sector_id
      • nullValue: False
      • valueColumn: name
      • filterExpression: None
Dma: dma_id - dma_id
  • Datatype: Integer.
  • Mandatory: No.
  • Editable: Sí.
  • Dvquerytext: The values of this dropdown are determined by the query: SELECT dma_id as id, name as idval FROM dma WHERE dma_id = 0 UNION SELECT dma_id as id, name as idval FROM dma WHERE dma_id IS NOT NULL AND active IS TRUE
  • Filterc: The previous query is filtered by: AND dma.expl_id
  • 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_dma
      • activated: True
      • keyColumn: dma_id
      • nullValue: False
      • valueColumn: name
      • filterExpression: None
State: state - Domain value of connect's 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.