gw_fct_setsearch - Giswater/giswater_dbmodel GitHub Wiki

---

Description

Set generic values on search dialog for current user

Input example

SELECT gw_fct_setsearch($${
"client":{"device":4, "infoType":1, "lang":"ES"}, 
"form":{"tabName":"network"}, "feature":{}, 
"data":{"filterFields":{}, "pageInfo":{}, "searchType":"None", 
"net_type":{"id":"", "name":""}, "net_code":{"text":"e"}, "addSchema":"None"}}$$);

Output example

{
  "status": "Accepted",
  "version": {
    "value": "3.4.019"
  },
  "data": [
    {
      "sys_id": "1007",
      "sys_table_id": "v_edit_node",
      "display_name": "1007 : AIR VALVE DN50",
      "sys_idname": "node_id"
    },
    {
      "sys_id": "1033",
      "sys_table_id": "v_edit_node",
      "display_name": "1033 : ENDLINE DN63",
      "sys_idname": "node_id"
    },
    {
      "sys_id": "1045",
      "sys_table_id": "v_edit_node",
      "display_name": "1045 : ENDLINE DN63",
      "sys_idname": "node_id"
    },
    {
      "sys_id": "1048",
      "sys_table_id": "v_edit_node",
      "display_name": "1048 : ENDLINE DN63",
      "sys_idname": "node_id"
    },
    {
      "sys_id": "1066",
      "sys_table_id": "v_edit_node",
      "display_name": "1066 : ENDLINE DN150",
      "sys_idname": "node_id"
    },
    {
      "sys_id": "1072",
      "sys_table_id": "v_edit_node",
      "display_name": "1072 : ENDLINE DN63",
      "sys_idname": "node_id"
    },
    {
      "sys_id": "1073",
      "sys_table_id": "v_edit_node",
      "display_name": "1073 : OUTFALL VALVE-DN150",
      "sys_idname": "node_id"
    },
    {
      "sys_id": "1079",
      "sys_table_id": "v_edit_node",
      "display_name": "1079 : GREENVALVEDN110 PN16",
      "sys_idname": "node_id"
    },
    {
      "sys_id": "1080",
      "sys_table_id": "v_edit_node",
      "display_name": "1080 : FLOWMETER-01-DN200",
      "sys_idname": "node_id"
    },
    {
      "sys_id": "1081",
      "sys_table_id": "v_edit_node",
      "display_name": "1081 : FILTER-01-DN200",
      "sys_idname": "node_id"
    }
  ],
  "body": {
    "returnManager": {
      "style": {
        "ruberband": {
          "width": 3,
          "color": [
            255,
            0,
            0
          ],
          "transparency": 0.5
        }
      },
      "functionId": 2618
    }
  }
}