27234

Hi all, 

When configure a column in Matter, I can set the column condition settings as below

Configure Column Condition

 

Using Api to get Columns of an iSheet return the columnconditions information

{
      "columnid": 388,
      "name": "Office",
      "type": 3,
      "status": null,
      "section": 44,
      "description": "<![CDATA[

      "addtodefaultview": null,
      "columnconditionstate": "Display field",
      "columnconditions": {
        "row": [
          {
            "sourcecolumnid": 388,
            "rowid": 31,
            "columnid": 387,
            "operatorid": 1,
            "oprand": "<![CDATA[England & Wales]]>",
            "logicaltype": "1",
            "sheetfiltervaluetypeid": null,
            "displaytype": null,
            "scoreconditiontypeid": 0,
            "userlookupfilters": null
          },
          {
            "sourcecolumnid": 388,
            "rowid": 32,
            "columnid": 387,
            "operatorid": 1,
            "oprand": "<![CDATA[Scotland]]>",
            "logicaltype": "2",
            "sheetfiltervaluetypeid": null,
            "displaytype": null,
            "scoreconditiontypeid": 0,
            "userlookupfilters": null
          }
        ]
      },

There are some information that cannot be interpret when missing master data such as below:

            "operatorid": 1,
            "oprand": "<![CDATA[England & Wales]]>",
            "logicaltype": "1",
            "sheetfiltervaluetypeid": null,
            "displaytype": null,
            "scoreconditiontypeid": 0,
            "userlookupfilters": null

How can I get the master data for the columns condition? For example what does logicaltype =1  mean? What does operatorid=1 mean?

]]>