smartFilter过滤不了中文

qwertyu

查询时输入‘XX’能找到，输入“四川成都招标XX公司”就找不到

qwertyu

--> sql:SELECT  View_ztfzb_claim.pay_number AS View_ztfzb_claim, View_ztfzb_claim.ACCEPTANCE_TIME AS acceptance_time, View_ztfzb_claim.BANK_ACCOUNT_NAME AS bank_account_name, View_ztfzb_claim.CLAIM_MONEY AS claim_money, View_ztfzb_claim.COMPANY_BANK_ACCOUNT AS company_bank_account, View_ztfzb_claim.COST_TYPE AS cost_type, View_ztfzb_claim.HAD_CLAIM_MONEY AS had_claim_money, View_ztfzb_claim.ING_CLAIM_MONEY AS ing_claim_money, View_ztfzb_claim.NO_CLAIM_MONEY AS no_claim_money, View_ztfzb_claim.ORDER_CREATE_TIME AS order_create_time, View_ztfzb_claim.PAY_ABSTRACT AS pay_abstract, View_ztfzb_claim.PAY_DESCRIPTION AS pay_description, View_ztfzb_claim.PAY_MENTOD AS pay_mentod, View_ztfzb_claim.PAY_MONEY AS pay_money, View_ztfzb_claim.PAY_NUMBER AS pay_number, View_ztfzb_claim.PAY_UNIT AS pay_unit, View_ztfzb_claim.PAYTIME AS paytime, View_ztfzb_claim.PROJECT_NAME AS project_name, View_ztfzb_claim.PROJECT_NO AS project_no, View_ztfzb_claim.TENDERER_UNIT AS tenderer_unit, View_ztfzb_claim.TENDERER_UNIT__ACCOUNT AS tenderer_unit__account, View_ztfzb_claim.VOUCHER_NO AS voucher_no, View_ztfzb_claim.VOUCHER_TIME AS voucher_time FROM view_ztfzb_claim View_ztfzb_claim  WHERE  (UPPER(View_ztfzb_claim.pay_number) LIKE ?) OR (UPPER(View_ztfzb_claim.PAY_NUMBER) LIKE ?) OR (UPPER(DATE_FORMAT(View_ztfzb_claim.PAYTIME, '%Y-%m-%d')) LIKE ?) OR (UPPER(View_ztfzb_claim.ORDER_CREATE_TIME) LIKE ?) OR (UPPER(View_ztfzb_claim.PAY_UNIT) LIKE ?) OR (UPPER(View_ztfzb_claim.TENDERER_UNIT) LIKE ?) OR (UPPER(View_ztfzb_claim.PAY_ABSTRACT) LIKE ?) OR (UPPER(View_ztfzb_claim.HAD_CLAIM_MONEY) LIKE ?) OR (UPPER(View_ztfzb_claim.ING_CLAIM_MONEY) LIKE ?) OR (UPPER(View_ztfzb_claim.NO_CLAIM_MONEY) LIKE ?) OR (UPPER(View_ztfzb_claim.PAY_MONEY) LIKE ?) OR (UPPER(View_ztfzb_claim.CLAIM_MONEY) LIKE ?) OR (UPPER(View_ztfzb_claim.PROJECT_NAME) LIKE ?) OR (UPPER(View_ztfzb_claim.PROJECT_NO) LIKE ?) OR (UPPER(View_ztfzb_claim.COST_TYPE) LIKE ?) OR (UPPER(View_ztfzb_claim.PAY_MENTOD) LIKE ?) OR (UPPER(View_ztfzb_claim.COMPANY_BANK_ACCOUNT) LIKE ?) OR (UPPER(View_ztfzb_claim.TENDERER_UNIT__ACCOUNT) LIKE ?) OR (UPPER(View_ztfzb_claim.BANK_ACCOUNT_NAME) LIKE ?) OR (UPPER(View_ztfzb_claim.VOUCHER_NO) LIKE ?) OR (UPPER(DATE_FORMAT(View_ztfzb_claim.VOUCHER_TIME, '%Y-%m-%d')) LIKE ?) OR (UPPER(DATE_FORMAT(View_ztfzb_claim.ACCEPTANCE_TIME, '%Y-%m-%d')) LIKE ?) OR (UPPER(View_ztfzb_claim.PAY_DESCRIPTION) LIKE ?)
--> binds:[%XX%, %XX%, %XX%, %XX%, %XX%, %XX%, %XX%, %XX%, %XX%, %XX%, %XX%, %XX%, %XX%, %XX%, %XX%, %XX%, %XX%, %XX%, %XX%, %XX%, %XX%, %XX%, %XX%]
2019-03-07 09:57:13 [SQL Time]sql 执行时间：4ms, exec KSQL:
  --> sql:SELECT count(*) FROM view_ztfzb_claim View_ztfzb_claim  WHERE  (UPPER(View_ztfzb_claim.pay_number) LIKE ?) OR (UPPER(View_ztfzb_claim.PAY_NUMBER) LIKE ?) OR (UPPER(DATE_FORMAT(View_ztfzb_claim.PAYTIME, '%Y-%m-%d')) LIKE ?) OR (UPPER(View_ztfzb_claim.ORDER_CREATE_TIME) LIKE ?) OR (UPPER(View_ztfzb_claim.PAY_UNIT) LIKE ?) OR (UPPER(View_ztfzb_claim.TENDERER_UNIT) LIKE ?) OR (UPPER(View_ztfzb_claim.PAY_ABSTRACT) LIKE ?) OR (UPPER(View_ztfzb_claim.HAD_CLAIM_MONEY) LIKE ?) OR (UPPER(View_ztfzb_claim.ING_CLAIM_MONEY) LIKE ?) OR (UPPER(View_ztfzb_claim.NO_CLAIM_MONEY) LIKE ?) OR (UPPER(View_ztfzb_claim.PAY_MONEY) LIKE ?) OR (UPPER(View_ztfzb_claim.CLAIM_MONEY) LIKE ?) OR (UPPER(View_ztfzb_claim.PROJECT_NAME) LIKE ?) OR (UPPER(View_ztfzb_claim.PROJECT_NO) LIKE ?) OR (UPPER(View_ztfzb_claim.COST_TYPE) LIKE ?) OR (UPPER(View_ztfzb_claim.PAY_MENTOD) LIKE ?) OR (UPPER(View_ztfzb_claim.COMPANY_BANK_ACCOUNT) LIKE ?) OR (UPPER(View_ztfzb_claim.TENDERER_UNIT__ACCOUNT) LIKE ?) OR (UPPER(View_ztfzb_claim.BANK_ACCOUNT_NAME) LIKE ?) OR (UPPER(View_ztfzb_claim.VOUCHER_NO) LIKE ?) OR (UPPER(DATE_FORMAT(View_ztfzb_claim.VOUCHER_TIME, '%Y-%m-%d')) LIKE ?) OR (UPPER(DATE_FORMAT(View_ztfzb_claim.ACCEPTANCE_TIME, '%Y-%m-%d')) LIKE ?) OR (UPPER(View_ztfzb_claim.PAY_DESCRIPTION) LIKE ?)
--> binds:[%XX%, %XX%, %XX%, %XX%, %XX%, %XX%, %XX%, %XX%, %XX%, %XX%, %XX%, %XX%, %XX%, %XX%, %XX%, %XX%, %XX%, %XX%, %XX%, %XX%, %XX%, %XX%, %XX%]

qwertyu

--> sql:SELECT  View_ztfzb_claim.pay_number AS View_ztfzb_claim, View_ztfzb_claim.ACCEPTANCE_TIME AS acceptance_time, View_ztfzb_claim.BANK_ACCOUNT_NAME AS bank_account_name, View_ztfzb_claim.CLAIM_MONEY AS claim_money, View_ztfzb_claim.COMPANY_BANK_ACCOUNT AS company_bank_account, View_ztfzb_claim.COST_TYPE AS cost_type, View_ztfzb_claim.HAD_CLAIM_MONEY AS had_claim_money, View_ztfzb_claim.ING_CLAIM_MONEY AS ing_claim_money, View_ztfzb_claim.NO_CLAIM_MONEY AS no_claim_money, View_ztfzb_claim.ORDER_CREATE_TIME AS order_create_time, View_ztfzb_claim.PAY_ABSTRACT AS pay_abstract, View_ztfzb_claim.PAY_DESCRIPTION AS pay_description, View_ztfzb_claim.PAY_MENTOD AS pay_mentod, View_ztfzb_claim.PAY_MONEY AS pay_money, View_ztfzb_claim.PAY_NUMBER AS pay_number, View_ztfzb_claim.PAY_UNIT AS pay_unit, View_ztfzb_claim.PAYTIME AS paytime, View_ztfzb_claim.PROJECT_NAME AS project_name, View_ztfzb_claim.PROJECT_NO AS project_no, View_ztfzb_claim.TENDERER_UNIT AS tenderer_unit, View_ztfzb_claim.TENDERER_UNIT__ACCOUNT AS tenderer_unit__account, View_ztfzb_claim.VOUCHER_NO AS voucher_no, View_ztfzb_claim.VOUCHER_TIME AS voucher_time FROM view_ztfzb_claim View_ztfzb_claim  WHERE  (UPPER(View_ztfzb_claim.pay_number) LIKE ?) OR (UPPER(View_ztfzb_claim.PAY_NUMBER) LIKE ?) OR (UPPER(DATE_FORMAT(View_ztfzb_claim.PAYTIME, '%Y-%m-%d')) LIKE ?) OR (UPPER(View_ztfzb_claim.ORDER_CREATE_TIME) LIKE ?) OR (UPPER(View_ztfzb_claim.PAY_UNIT) LIKE ?) OR (UPPER(View_ztfzb_claim.TENDERER_UNIT) LIKE ?) OR (UPPER(View_ztfzb_claim.PAY_ABSTRACT) LIKE ?) OR (UPPER(View_ztfzb_claim.HAD_CLAIM_MONEY) LIKE ?) OR (UPPER(View_ztfzb_claim.ING_CLAIM_MONEY) LIKE ?) OR (UPPER(View_ztfzb_claim.NO_CLAIM_MONEY) LIKE ?) OR (UPPER(View_ztfzb_claim.PAY_MONEY) LIKE ?) OR (UPPER(View_ztfzb_claim.CLAIM_MONEY) LIKE ?) OR (UPPER(View_ztfzb_claim.PROJECT_NAME) LIKE ?) OR (UPPER(View_ztfzb_claim.PROJECT_NO) LIKE ?) OR (UPPER(View_ztfzb_claim.COST_TYPE) LIKE ?) OR (UPPER(View_ztfzb_claim.PAY_MENTOD) LIKE ?) OR (UPPER(View_ztfzb_claim.COMPANY_BANK_ACCOUNT) LIKE ?) OR (UPPER(View_ztfzb_claim.TENDERER_UNIT__ACCOUNT) LIKE ?) OR (UPPER(View_ztfzb_claim.BANK_ACCOUNT_NAME) LIKE ?) OR (UPPER(View_ztfzb_claim.VOUCHER_NO) LIKE ?) OR (UPPER(DATE_FORMAT(View_ztfzb_claim.VOUCHER_TIME, '%Y-%m-%d')) LIKE ?) OR (UPPER(DATE_FORMAT(View_ztfzb_claim.ACCEPTANCE_TIME, '%Y-%m-%d')) LIKE ?) OR (UPPER(View_ztfzb_claim.PAY_DESCRIPTION) LIKE ?)
--> binds:[%四川成都招标XX公司%, %四川成都招标XX公司%, %四川成都招标XX公司%, %四川成都招标XX公司%, %四川成都招标XX公司%, %四川成都招标XX公司%, %四川成都招标XX公司%, %四川成都招标XX公司%, %四川成都招标XX公司%, %四川成都招标XX公司%, %四川成都招标XX公司%, %四川成都招标XX公司%, %四川成都招标XX公司%, %四川成都招标XX公司%, %四川成都招标XX公司%, %四川成都招标XX公司%, %四川成都招标XX公司%, %四川成都招标XX公司%, %四川成都招标XX公司%, %四川成都招标XX公司%, %四川成都招标XX公司%, %四川成都招标XX公司%, %四川成都招标XX公司%]
2019-03-07 09:57:33 [SQL Time]sql 执行时间：8ms, exec KSQL:
  --> sql:SELECT count(*) FROM view_ztfzb_claim View_ztfzb_claim  WHERE  (UPPER(View_ztfzb_claim.pay_number) LIKE ?) OR (UPPER(View_ztfzb_claim.PAY_NUMBER) LIKE ?) OR (UPPER(DATE_FORMAT(View_ztfzb_claim.PAYTIME, '%Y-%m-%d')) LIKE ?) OR (UPPER(View_ztfzb_claim.ORDER_CREATE_TIME) LIKE ?) OR (UPPER(View_ztfzb_claim.PAY_UNIT) LIKE ?) OR (UPPER(View_ztfzb_claim.TENDERER_UNIT) LIKE ?) OR (UPPER(View_ztfzb_claim.PAY_ABSTRACT) LIKE ?) OR (UPPER(View_ztfzb_claim.HAD_CLAIM_MONEY) LIKE ?) OR (UPPER(View_ztfzb_claim.ING_CLAIM_MONEY) LIKE ?) OR (UPPER(View_ztfzb_claim.NO_CLAIM_MONEY) LIKE ?) OR (UPPER(View_ztfzb_claim.PAY_MONEY) LIKE ?) OR (UPPER(View_ztfzb_claim.CLAIM_MONEY) LIKE ?) OR (UPPER(View_ztfzb_claim.PROJECT_NAME) LIKE ?) OR (UPPER(View_ztfzb_claim.PROJECT_NO) LIKE ?) OR (UPPER(View_ztfzb_claim.COST_TYPE) LIKE ?) OR (UPPER(View_ztfzb_claim.PAY_MENTOD) LIKE ?) OR (UPPER(View_ztfzb_claim.COMPANY_BANK_ACCOUNT) LIKE ?) OR (UPPER(View_ztfzb_claim.TENDERER_UNIT__ACCOUNT) LIKE ?) OR (UPPER(View_ztfzb_claim.BANK_ACCOUNT_NAME) LIKE ?) OR (UPPER(View_ztfzb_claim.VOUCHER_NO) LIKE ?) OR (UPPER(DATE_FORMAT(View_ztfzb_claim.VOUCHER_TIME, '%Y-%m-%d')) LIKE ?) OR (UPPER(DATE_FORMAT(View_ztfzb_claim.ACCEPTANCE_TIME, '%Y-%m-%d')) LIKE ?) OR (UPPER(View_ztfzb_claim.PAY_DESCRIPTION) LIKE ?)
--> binds:[%四川成都招标XX公司%, %四川成都招标XX公司%, %四川成都招标XX公司%, %四川成都招标XX公司%, %四川成都招标XX公司%, %四川成都招标XX公司%, %四川成都招标XX公司%, %四川成都招标XX公司%, %四川成都招标XX公司%, %四川成都招标XX公司%, %四川成都招标XX公司%, %四川成都招标XX公司%, %四川成都招标XX公司%, %四川成都招标XX公司%, %四川成都招标XX公司%, %四川成都招标XX公司%, %四川成都招标XX公司%, %四川成都招标XX公司%, %四川成都招标XX公司%, %四川成都招标XX公司%, %四川成都招标XX公司%, %四川成都招标XX公司%, %四川成都招标XX公司%]

jishuang

sql语句到数据库中查询看看有数据吗？

qwertyu

用这个sql直接去数据库查有的

jishuang

SELECT  View_ztfzb_claim.pay_number AS View_ztfzb_claim, View_ztfzb_claim.ACCEPTANCE_TIME AS acceptance_time, View_ztfzb_claim.BANK_ACCOUNT_NAME AS bank_account_name, View_ztfzb_claim.CLAIM_MONEY AS claim_money, View_ztfzb_claim.COMPANY_BANK_ACCOUNT AS company_bank_account, View_ztfzb_claim.COST_TYPE AS cost_type, View_ztfzb_claim.HAD_CLAIM_MONEY AS had_claim_money, View_ztfzb_claim.ING_CLAIM_MONEY AS ing_claim_money, View_ztfzb_claim.NO_CLAIM_MONEY AS no_claim_money, View_ztfzb_claim.ORDER_CREATE_TIME AS order_create_time, View_ztfzb_claim.PAY_ABSTRACT AS pay_abstract, View_ztfzb_claim.PAY_DESCRIPTION AS pay_description, View_ztfzb_claim.PAY_MENTOD AS pay_mentod, View_ztfzb_claim.PAY_MONEY AS pay_money, View_ztfzb_claim.PAY_NUMBER AS pay_number, View_ztfzb_claim.PAY_UNIT AS pay_unit, View_ztfzb_claim.PAYTIME AS paytime, View_ztfzb_claim.PROJECT_NAME AS project_name, View_ztfzb_claim.PROJECT_NO AS project_no, View_ztfzb_claim.TENDERER_UNIT AS tenderer_unit, View_ztfzb_claim.TENDERER_UNIT__ACCOUNT AS tenderer_unit__account, View_ztfzb_claim.VOUCHER_NO AS voucher_no, View_ztfzb_claim.VOUCHER_TIME AS voucher_time FROM view_ztfzb_claim View_ztfzb_claim  WHERE  (UPPER(View_ztfzb_claim.pay_number) LIKE ?) OR (UPPER(View_ztfzb_claim.PAY_NUMBER) LIKE ?) OR (UPPER(DATE_FORMAT(View_ztfzb_claim.PAYTIME, '%Y-%m-%d')) LIKE ?) OR (UPPER(View_ztfzb_claim.ORDER_CREATE_TIME) LIKE ?) OR (UPPER(View_ztfzb_claim.PAY_UNIT) LIKE ?) OR (UPPER(View_ztfzb_claim.TENDERER_UNIT) LIKE ?) OR (UPPER(View_ztfzb_claim.PAY_ABSTRACT) LIKE ?) OR (UPPER(View_ztfzb_claim.HAD_CLAIM_MONEY) LIKE ?) OR (UPPER(View_ztfzb_claim.ING_CLAIM_MONEY) LIKE ?) OR (UPPER(View_ztfzb_claim.NO_CLAIM_MONEY) LIKE ?) OR (UPPER(View_ztfzb_claim.PAY_MONEY) LIKE ?) OR (UPPER(View_ztfzb_claim.CLAIM_MONEY) LIKE ?) OR (UPPER(View_ztfzb_claim.PROJECT_NAME) LIKE ?) OR (UPPER(View_ztfzb_claim.PROJECT_NO) LIKE ?) OR (UPPER(View_ztfzb_claim.COST_TYPE) LIKE ?) OR (UPPER(View_ztfzb_claim.PAY_MENTOD) LIKE ?) OR (UPPER(View_ztfzb_claim.COMPANY_BANK_ACCOUNT) LIKE ?) OR (UPPER(View_ztfzb_claim.TENDERER_UNIT__ACCOUNT) LIKE ?) OR (UPPER(View_ztfzb_claim.BANK_ACCOUNT_NAME) LIKE ?) OR (UPPER(View_ztfzb_claim.VOUCHER_NO) LIKE ?) OR (UPPER(DATE_FORMAT(View_ztfzb_claim.VOUCHER_TIME, '%Y-%m-%d')) LIKE ?) OR (UPPER(DATE_FORMAT(View_ztfzb_claim.ACCEPTANCE_TIME, '%Y-%m-%d')) LIKE ?) OR (UPPER(View_ztfzb_claim.PAY_DESCRIPTION) LIKE ?)

这个所有字段的查询到数据库能查出来？

qwertyu

jishuang 发表于 2019-3-7 11:05
SELECT  View_ztfzb_claim.pay_number AS View_ztfzb_claim, View_ztfzb_claim.ACCEPTANCE_TIME AS accepta ...

能查到

jishuang

确认数据是数据库中本来就有的？不是通过查询添加的？

qwertyu

jishuang 发表于 2019-3-7 11:40
确认数据是数据库中本来就有的？不是通过查询添加的？

我查的是个视图，只建了queryAction，视图中用的表概念都没有映射，后台也没有写其他代码

jishuang

视图中只有select吗？