gw_fct_admin_manage_addfields - Giswater/giswater_dbmodel GitHub Wiki

---

Description

Function to admin addfields definition and related custom view

Input example

SELECT gw_fct_admin_manage_addfields($${"client":{"device":4, "infoType":1, "lang":"ES"},
"form":{}, "feature":{"catFeature":"PUMP"}, 
"data":{"filterFields":{}, "pageInfo":{}, "action":"UPDATE", "multi_create":false, 
"parameters":{"label": "pump111", "field_length": null, "addfield_active": true, "iseditable": true, 
"ismandatory": false, "formtype": "feature", "datatype": "integer", "num_decimals": null, 
"columnname": "pump1", "isenabled": true, "widgettype": "text", "dv_isnullvalue": false, 
"isautoupdate": false, "dv_parent_id": null, "tooltip": null, "dv_querytext": null, 
"widgetfunction": null, "placeholder": null, "reload_field": null, "isparent": false, 
"listfilterparam": null, "editability": null, "dv_querytext_filterc": null, "linkedaction": null,
"stylesheet": null, "widgetdim": null}}}$$)

Output example

{
  "status": "Accepted",
  "message": {
    "level": 3,
    "text": "Process done successfully"
  },
  "version": "3.4.019",
  "body": {
    "form": {},
    "data": {
      "info": {
        "geometryType": "",
        "values": [
          {
            "id": 2959,
            "message": "CREATE ADDFIELDS"
          },
          {
            "id": 2960,
            "message": "-------------------------------------------------------------"
          },
          {
            "id": 2961,
            "message": "Create addfield pump1."
          },
          {
            "id": 2962,
            "message": "Update parameter definition in sys_addfields."
          },
          {
            "id": 2963,
            "message": "Update parameter definition in config_form_fields."
          },
          {
            "id": 2964,
            "message": "Update definition of vdefault: edit_addfield_p_vdefault."
          },
          {
            "id": 2965,
            "message": "Recreate child view for PUMP."
          },
          {
            "id": 2966,
            "message": "Recreate edition trigger for view ve_node_pump."
          },
          {
            "id": 2967,
            "message": "Set role permissions."
          }
        ]
      },
      "setVisibleLayers": [],
      "point": {
        "geometryType": "",
        "features": []
      },
      "line": {
        "geometryType": "",
        "features": []
      },
      "polygon": {
        "geometryType": "",
        "features": []
      }
    },
    "actions": {
      "hideForm": false
    }
  }
}