gw_fct_getcolumnsfromid - Giswater/giswater_dbmodel GitHub Wiki


Description

Function to manage automatically updated columns

Input example

SELECT gw_fct_getcolumnsfromid($${
"client":{"device":4, "infoType":1, "lang":"ES"},
"form":{},
"feature":{"tableName":"ve_arc_pipe", "id":"113936", 
"fieldsReload":"['cat_matcat_id', 'cat_pnom', 'cat_dnom']", "parentField":"arccat_id"},
"data":{}}$$)

Output example

[
  {
    "widgetname": "data_cat_matcat_id",
    "value": "PE-LD",
    "iseditable": false
  },
  {
    "widgetname": "data_cat_pnom",
    "value": "10",
    "iseditable": false
  },
  {
    "widgetname": "data_cat_dnom",
    "value": "110",
    "iseditable": false
  }
]