IN查询

参数传递

源码规则

关联表，自定义方式（如果不是数据库变量，isData=false）

 "columns": {
    //#region 配置in查询
    "commTypeId": {
      "title": "商品类别参数",
      "alias": "comm_type_id",
      "field": "commTypeId",
      "filter": {
        "method": "custom",
        "sql": " and comm_id in (select comm_id from mall_commodity_refs where type_id in @commTypeId)"
      },
      "isSearch": true,
      "isData": false,
      "editPropertie": {
        "showMethodOut": "kv",
        "showMethod": "text",
        "type": null,
        "format": null,
        "defaultValue": 0
      },
      "pagePropertie": {
        "showMethodOut": "kv",
        "showMethod": "text",
        "type": null,
        "format": null,
        "defaultValue": null
      }
    }
    //#endregion 配置in查询
  },

直接in查询(isData=true)

 "columns": {
    //#region 配置in查询
    "commTypeId": {
      "title": "商品类别参数",
      "alias": "comm_type_id",
      "field": "commTypeId",
      "filter": {
        "method": "in"
      },
      "isSearch": true,
      "isData": true,
      "editPropertie": {
        "showMethodOut": "kv",
        "showMethod": "text",
        "type": null,
        "format": null,
        "defaultValue": 0
      },
      "pagePropertie": {
        "showMethodOut": "kv",
        "showMethod": "text",
        "type": null,
        "format": null,
        "defaultValue": null
      }
    }
    //#endregion 配置in查询
  },