gw_fct_setfields - Giswater/giswater_dbmodel GitHub Wiki

---

Description

Function to set field values for given feature id

Input example

SELECT  gw_fct_setfields($${
"client":{"device":4, "infoType":1, "lang":"ES"},
"form":{},
"feature":{"featureType":"node", "tableName":"ve_node_t", "id":"1029"},
"data":{"fields":{"undelete": "False", "inventory": "False", "epa_type": "PUMP", 
"state": "1", "arc_id": "113854", "publish": "False", 
"verified": "TO REVIEW","builtdate": "2018/11/29", "workcat_id": "work2", 
"buildercat_id": "builder1", "enddate": "2018/11/29", 
"soilcat_id": "soil1", "ownercat_id": "owner1"}}}$$);

Output example

{
  "status": "Accepted",
  "message": {
    "level": 3,
    "text": "Feature have been succesfully updated."
  },
  "version": {
    "value": "3.5.002"
  },
  "body": {
    "data": {
      "fields": {}
    }
  }
}