gw_fct_getsearch - Giswater/giswater_dbmodel GitHub Wiki

---

Description

Get search dialog and combo values

Input example

SELECT gw_fct_getsearch($${"client":{"device":4, "infoType":1, "lang":"ES"}}$$)

Output example

{"status":"Accepted", 
"version":{
  "value":"3.4.019"}, 
  "enabled":true,
  "form":[{
    "tabName":"network",
    "tabLabel":"Network",
    "tooltip":"Network",
    "active":true,
    "fields":[{
      "label":"Type","columnname":"net_type","widgetname":"network_net_type","widgettype":"combo","datatype":"string","placeholder":"","disabled":false,"comboIds":["","v_edit_arc","v_edit_node","v_edit_connec","v_edit_element"],"selectedId":0,"comboNames":["","Arcs","Nodes","Connecs","Elements"],"comboFeature":[null,"arc","node","connec","element"]},{
        "label" : "Code", "columnname" : "net_code", "widgetname" : "network_net_code", "widgettype" : "typeahead", "datatype" : "string", "placeholder" : "", "disabled" : false, "noresultsMsg" : "No results", "loadingMsg" : "Searching..."}]},{
    "tabName":"address",
    "tabLabel":"Address",
    "tooltip":"Address",
    "active":false,
    "fields":[{
      "label":"Municipality","columnname":"add_muni","widgetname":"address_add_muni","widgettype":"combo","datatype":"string","placeholder":"","disabled":false,"comboIds":[1,2],"comboNames":["Sant Boi del Llobregat","Sant Esteve de les Roures"],"comboGeometry":["POLYGON((418829.214569958 4576171.19463729,418829.214569958 4576965.15511336,419590.435114455 4576965.15511336,419590.435114455 4576171.19463729,418829.214569958 4576171.19463729))","POLYGON((418280.982913391 4577536.32632416,418280.982913391 4578106.68520886,418734.402156798 4578106.68520886,418734.402156798 4577536.32632416,418280.982913391 4577536.32632416))"]},{
      "label" : "Street", "columnname" : "add_street", "widgetname" : "address_add_street", "widgettype" : "typeahead", "datatype" : "string", "placeholder" : "", "disabled" : false, "noresultsMsg" : "No results", "loadingMsg" : "Searching..."},{
      "label" : "Number", "columnname" : "add_postnumber", "widgetname" : "address_add_postnumber", "widgettype" : "typeahead", "threshold" : 1, "datatype" : "integer", "placeholder" : "", "disabled" : true, "noresultsMsg" : "No results", "loadingMsg" : "Searching..."}]},{
    "tabName":"hydro",
    "tabLabel":"Hydrometer",
    "tooltip":"Hydro",
    "active":false,
    "fields":[{
      "label":"Exploitation","columnname":"hydro_expl","widgetname":"hydro_hydro_expl","widgettype":"combo","datatype":"string","placeholder":"","disabled":false,"comboIds":[1,2],"selectedId":"1","comboNames":["expl_01","expl_02"]},{
      "label" : "Customer", "columnname" : "hydro_search", "widgetname" : "hydro_hydro_search", "widgettype" : "typeahead", "datatype" : "string", "placeholder" : "", "disabled" : false, "noresultsMsg" : "No results", "loadingMsg" : "Searching..."}]},{
    "tabName":"workcat",
    "tabLabel":"Workcat",
    "tooltip":"Workcat",
    "active":false,
    "fields":[{
      "label" : "Work", "columnname" : "workcat_search", "widgetname" : "workcat_workcat_search", "widgettype" : "typeahead", "datatype" : "string", "placeholder" : "", "disabled" : false, "noresultsMsg" : "No results", "loadingMsg" : "Searching..."}]},{
    "tabName":"psector",
    "tabLabel":"Psector",
    "tooltip":"Psector",
    "active":false,
    "fields":[{
      "label":"Exploitation","columnname":"psector_expl","widgetname":"psector_psector_expl","widgettype":"combo","datatype":"string","placeholder":"","disabled":false,"comboIds":[1,2],"selectedId":"1","comboNames":["expl_01","expl_02"]},{
      "label" : "Psector", "columnname" : "psector_search", "widgetname" : "psector_psector_search", "widgettype" : "typeahead", "datatype" : "string", "placeholder" : "", "disabled" : false, "noresultsMsg" : "No results", "loadingMsg" : "Searching..."}]},{"tabName":"visit","tabLabel":"Visit","tooltip":"Visit","active":false,"fields":[{
      "label" : "Visit", "columnname" : "visit_search", "widgetname" : "visit_visit_search", "widgettype" : "typeahead", "datatype" : "string", "placeholder" : "", "disabled" : false, "noresultsMsg" : "No results", "loadingMsg" : "Searching..."}]}]}