自定义Sql

“method”: “custom”,

"typeId": {
      "isData": false,
      "tableId": 1,
      "field": "typeId",
      "dataType": "varchar",
      "title": "类别编号",
      "name": "type_id",
      "alias": "type_id",
      "editPropertie": { "showMethod": "text" },
      "pagePropertie": { "showMethod": "text" },
      "isSearch": true,
      "filter": {
        "method": "custom",
        "sql": " and product_id in (select product_id  from cpc_product_refs_type where type_id=@typeId)"
      },
      "maxLength": 200
    }