如图,表格中有为空的数据,使用文本控件有办法实现筛选出空的数据吗?并且输入对应字段时,显示出符合条件的值。
SELECT * FROM TABLE WHERE 1=1 ${IF(LEN(控件名称)==0," AND (字段名 is null or 字段名=''"," and xxxxxx")}
---------------
SELECT * FROM TABLE WHERE 1=1 ${IF(LEN(控件名称)==0,"",IF(控件名称==" "," AND (字段名 is null or 字段名=''"," and xxxxxx"))}
参考这个https://help.fanruan.com/finereport10.0/doc-view-158.html