gw_fct_getcatalog - Giswater/giswater_dbmodel GitHub Wiki

---

Description

Get attribute table dialog, filters and values from database relation

Input example

SELECT gw_fct_getcatalog($${
"client":{"device":4, "infoType":1, "lang":"ES"},
"form":{"formName":"upsert_catalog_arc", "tabName":"data", "editable":"TRUE"},
"feature":{"tableName":"ve_arc_pipe", "idName":"arc_id", "id":"2001", "feature_type":"PIPE"},
"data":{"fields":{"matcat_id":"PVC", "pnom":"16", "dnom":"160"}}}$$)

Output example

{
  "status": "Accepted",
  "version": {
    "value": "3.4.019"
  },
  "body": {
    "message": {
      "level": 1,
      "text": "Process done successfully"
    },
    "form": {
      "formName": "upsert_catalog_arc",
      "tabName": "data",
      "editable": "TRUE"
    },
    "feature": {
      "tableName": "ve_arc_pipe",
      "idName": "arc_id",
      "id": "2001",
      "feature_type": "PIPE"
    },
    "data": {
      "fields": [
        {
          "label": "material",
          "columnname": "matcat_id",
          "widgetname": "data_matcat_id",
          "widgettype": "combo",
          "widgetfunction": null,
          "hidden": false,
          "widgetdim": null,
          "datatype": "string",
          "tooltip": null,
          "placeholder": "Ex.:material",
          "iseditable": true,
          "orderby": 1,
          "layoutname": "lyt_data_1",
          "layoutorder": 1,
          "isparent": true,
          "ismandatory": false,
          "linkedaction": null,
          "isautoupdate": false,
          "stylesheet": null,
          "widgetcontrols": null,
          "comboIds": [
            "FC"
          ],
          "comboNames": [
            "FC"
          ],
          "selectedId": ""
        },
        {
          "label": "pn",
          "columnname": "pnom",
          "widgetname": "data_pnom",
          "widgettype": "combo",
          "widgetfunction": null,
          "hidden": false,
          "widgetdim": null,
          "datatype": "string",
          "tooltip": null,
          "placeholder": "Ex.:pn",
          "iseditable": true,
          "orderby": 2,
          "layoutname": "lyt_data_1",
          "layoutorder": 2,
          "isparent": false,
          "ismandatory": false,
          "linkedaction": null,
          "isautoupdate": false,
          "stylesheet": null,
          "widgetcontrols": null,
          "comboIds": [
            "10",
            "16",
            null
          ],
          "comboNames": [
            "10",
            "16",
            null
          ],
          "selectedId": ""
        },
        {
          "label": "dn",
          "columnname": "dnom",
          "widgetname": "data_dnom",
          "widgettype": "combo",
          "widgetfunction": null,
          "hidden": false,
          "widgetdim": null,
          "datatype": "string",
          "tooltip": null,
          "placeholder": "Ex.:dn",
          "iseditable": true,
          "orderby": 3,
          "layoutname": "lyt_data_1",
          "layoutorder": 3,
          "isparent": false,
          "ismandatory": false,
          "linkedaction": null,
          "isautoupdate": false,
          "stylesheet": null,
          "widgetcontrols": null,
          "comboIds": [
            "110",
            "150",
            "160",
            "200",
            "300",
            "63",
            "90",
            null
          ],
          "comboNames": [
            "110",
            "150",
            "160",
            "200",
            "300",
            "63",
            "90",
            null
          ],
          "selectedId": ""
        },
        {
          "label": "id",
          "columnname": "id",
          "widgetname": "data_id",
          "widgettype": "combo",
          "widgetfunction": null,
          "hidden": false,
          "widgetdim": null,
          "datatype": "string",
          "tooltip": null,
          "placeholder": "Ex.:id",
          "iseditable": true,
          "orderby": 4,
          "layoutname": "lyt_data_1",
          "layoutorder": 4,
          "isparent": false,
          "ismandatory": false,
          "linkedaction": null,
          "isautoupdate": false,
          "stylesheet": null,
          "widgetcontrols": null,
          "queryText": "SELECT DISTINCT (id) AS id, id AS idval FROM cat_arc WHERE id IS NOT NULL AND matcat_id::text = 'PVC'::text AND pnom::text = '16'::text AND dnom::text = '160'::text AND arctype_id = 'PIPE'",
          "comboIds": [
            "PVC160-PN16"
          ],
          "comboNames": [
            "PVC160-PN16"
          ],
          "selectedId": "PVC160-PN16"
        }
      ]
    }
  }
}