自定义搜索组合

注意push_name、 “name”: “product_id”,

{
  "columns": {
     //{s-if:pushName} and product_id in (select product_id cpc_product_task where product_name like CONCAT('%',@pushName,'%') or mnemonic_code like CONCAT('%',@pushName,'%') or product_model like CONCAT('%',@pushName,'%')) {e-if:pushName}
    "pushName": {
      "extendAlias": "search_like",
      "isData": false,
      "tableId": 1,
      "field": "pushName",
      "dataType": "varchar",
      "title": "发布名称",
      "name": "product_id",
      "alias": "push_name",
      "editPropertie": { "showMethod": "text" },
      "pagePropertie": { "showMethod": "text" },
      "isSearch": true,
      "filter": {
        // 自定义组合语句
        "whereSql": "and product_id in (select product_id cpc_product_task where {column_sql})",
        "method": "like",
        //扩展列 模糊查询  如  (telephone like  '%'+@realName+'%' or real_name like  '%'+@realName+'%')
        "columnName": [ "product_name", "mnemonic_code", "product_model" ]
      },
      "maxLength": 200
    }
  }
}

{
  "responseField": {
    "global": {
      "dataFromType": "Database",
      "show": "product_task_id",
      "auth": true
    },
    "manager": {
      //"showExtand": "",
      "bridgeColumnExtand": "task_user,push_name"
    }
  }
}

{
  "columns": {
    "pushName": {
      "extendAlias": "search_like",
      "isData": false,
      "tableId": 1,
      "field": "pushName",
      "dataType": "varchar",
      "title": "发布名称",
      "name": "product_name",
      "alias": "push_name",
      "editPropertie": { "showMethod": "text" },
      "pagePropertie": { "showMethod": "text" },
      "isSearch": true,
      "filter": {
        // 自定义组合语句
        "whereSql": "product_id in (select product_id  from cpc_product_refs_type where type_id in (select type_id from cpc_product_type where type_name like CONCAT('%',@pushName,'%'))) or {column_sql}",
        "method": "like",
        //扩展列 模糊查询  如  (telephone like  '%'+@realName+'%' or real_name like  '%'+@realName+'%')
        "columnName": [ "product_id", "product_model", "mnemonic_code", "model", "standard" ]
      },
      "maxLength": 200
    }
  }
}

bridge

{
  "search": {
    "columns": {
      //#region 关键字搜索
      "pushName": {
        "attrsForm": {},
        "attrsFormInt": {},
        "query": {},
        "queryLeft": {},
        "queryRight": {},
        "queryMenu": {},
        "params": {},
        "sortId": 20,
        "alias": "push_name",
        "field": "pushName",
        "events": {},
        "attrs": {
          "label": "产品名称",
          "placeholder": "产品名称、产品型号、产品助记码",
          "maxlength": 255,
          "clearable": true
        },
        "attrsInt": {},
        "styles": {},
        "meta": {
          "edit": true,
          "html": true,
          "component": "bo-search",
          "rowId": "1",
          "tabId": "1",
          "type": "basis",
          "span": 24
        }
      },
      //#endregion 关键字搜索
      "status": {
        "sortId": 9999,
        "alias": "status",
        "field": "status",
        "events": {},
        "attrs": {
          "label": "任务状态",
          "maxlength": 10,
          "clearable": true,
          //自定义组件
          "component-type": "custom",
          "lazy-renger": true,
          "multiple": false
        },
        "attrsInt": {},
        "meta": {
          //显示应用  mobile  pc   ipad   不设置表示全部显示
          //"showApp": "",
          "fromValue": true,
          "dimSessionKey": "dim-cpc-product-task",
          "dimLocalKey": "dim-cpc-product-task",
          "dimMkey": "cpc-product-task",
          "dimResField": "basis",
          "dimColumnField": "status",
          //数据类型不一致导致问题设置  int 或 string
          "dimDataType": "int",
          "dimRemote": true,
          "dimUrl": null,
          "prop": "status",
          "rowId": 1,
          "type": "basis",
          "span": 12,
          "auth": true,
          "component": "bs-select"
        }
      }
    }
  }
}