gw_fct_getchilds - Giswater/giswater_dbmodel GitHub Wiki

---

Description

Get combochilds from parent combo for given feature

Input example

SELECT gw_fct_getchilds($${
"client":{"device":4, "infoType":1, "lang":"ES"},
"form":{},
"feature":{"featureType":"arc", "tableName":"ve_arc_pipe", "idName":"arc_id"},
"data":{"comboParent":"state", "comboId":"1"}}$$)

Output example

{
  "status": "Accepted",
  "message": {
    "level": "0",
    "text": "Childs update successfully"
  },
  "apiVersion": {
    "value": "3.4.019"
  },
  "body": {
    "form": {},
    "feature": {},
    "data": [
      {
        "columnname": "state_type",
        "widgettype": "combo",
        "datatype": "integer",
        "widgetname": "data_state_type",
        "dv_querytext": "SELECT id, name as idval FROM value_state_type WHERE id IS NOT NULL",
        "isparent": false,
        "dv_parent_id": "state",
        "orderby": 1,
        "dv_querytext_filterc": " AND value_state_type.state",
        "isautoupdate": false,
        "placeholder": "Ex.:state_type",
        "dv_orderby_id": true,
        "tooltip": "state_type - Tipo de estado del elemento. Permite obtener más detalle del estado. A seleccionar de los disponibles en función del estado escogido",
        "isNullValue": false,
        "widgetcontrols": null,
        "comboIds": [
          2,
          5
        ],
        "comboNames": [
          "ON_SERVICE",
          "PROVISIONAL"
        ],
        "selectedId": "1"
      }
    ]
  }
}