Anglookup

Anglookup

controlType lookup olarak ayarlandığında database 'de belirtilen veriler açılır kutuda listelenir.

Grid İçinde Kullanımı:

   {
      "hide": false,
      "field": "STOCKID_NAME",
      "headerName": "Stock",
      "width": 274,
      "pinned": null,
      "type": "dblookup",
      "cellEditorParams": {
        "gridID": "stock-definition",
        "recordID": "stock-definition",
        "recordField": "NAME",
        "keyField": "ID",
        "displayField": "NAME",
        "additionalFields": {
          "UNITNAME": "STOCKID_UNITNAME",
          "RECIPIEAVGBUYINGPRICE": "UNITPRICE",
          "RECIPIEUNIT": "STOCKID_RECIPIEUNIT",
          "RECIPIELASTBUYINGPRICE": "LASTBUYINGPRICE"
        },
        "fuzzySearch": {
          "clearCacheButton": true,
          "threshold": -1000,
          "strict": true,
          "fields": [
            "NAME"
          ],
          "object": [
            "QA_STOCK"
          ],
          "selectFields": [
            "NAME"
          ]
        },
        "request": {
          "Object": "QA_STOCK",
          "Where": [
            {
              "Column": "ISDISABLED",
              "Operator": "=",
              "IsNull": 0,
              "Value": 0
            }
          ]
        },
        "additionalFieldsOverwrite": true
      },
      "rowGroupIndex": null,
      "pivotIndex": null,
      "aggFunc": null,
      "cellClassRules": {
        "cell-changed": "node.cellEditData && node.cellEditData[\"changedFields\"][colDef.field]"
      }
    }         

Record İçinde Kullanımı:

    {
              "controlType": "anglookup",
              "lookupConfig": {
                "gridID": "stock-groups",
                "recordID": "stock-groups",
                "keyField": "ID",
                "displayField": "NAME",
                "fuzzySearch": {
                  "clearCacheButton": true,
                  "fields": [
                    "NAME"
                  ],
                  "object": [
                    "STOCK_STOCKGROUP"
                  ],
                  "selectFields": [
                    "NAME"
                  ]
                },
                "request": {
                  "Object": "STOCK_STOCKGROUP"
                }
              },
              "field": "STOCKGROUPID_NAME",
              "label": "Stock Group",
              "disabled": false,
              "required": false
            }