• columnName用于关联其它字段,如果单字段查询,不用配置columnName
    注意:”extendAlias”: “search_like”,
"pushName": {
      "extendAlias": "search_like",
      "isData": false,
      "tableId": 1,
      "field": "pushName",
      "dataType": "varchar",
      "title": "发布名称",
      "name": "real_name",
      "alias": "push_name",
      "editPropertie": { "showMethod": "text" },
      "pagePropertie": { "showMethod": "text" },
      "isSearch": true,
      "filter": {
        "method": "like",
        //扩展列 模糊查询  如  (telephone like  '%'+@realName+'%' or real_name like  '%'+@realName+'%')
        "columnName": [ "telephone_suffix", "email", "user_name", "nike_name", "pin_yin", "id_card_suffix" ]
      },
      "maxLength": 200
    },
  • Sql语句参考,注意pushName
    select null rownum,pin_yin,user_id,null user_name,null sys_id,null role_id,null dep_id
    ,sex,real_name,telephone,id_card,user_status,is_hide_phone,create_time,head_icon
    ,’00000000000000000’ push_name from bo_user where ( real_name like CONCAT(‘%’, @pushName, ‘%’) or telephone_suffix like CONCAT(‘%’, @pushName, ‘%’) or email like CONCAT(‘%’, @pushName, ‘%’) or user_name like CONCAT(‘%’, @pushName, ‘%’) or nike_name like CONCAT(‘%’, @pushName, ‘%’) or pin_yin like CONCAT(‘%’, @pushName, ‘%’) or id_card_suffix like CONCAT(‘%’, @pushName, ‘%’) ) and user_id not in @filterUser order by (case when TIMESTAMPDIFF(MINUTE,createtime,@currentDate)<30 then 0 else 1 end),sortid limit @limtStartIndex,@pageSize
文档更新时间: 2021-06-26 08:00   作者:admin