U8C服务小锦囊--采购管理--物资需求执行情况查询增加申请日期大于等于小于等于条件---U8C实施与服务支持部张鑫此报表是用查询引擎做的，只改查询模板无效，还要在查询引擎处进行修改。1、执行下面的SQL在查询模板上增加查询条件insertintopub_query_condition(addisnull4power,consult_code,data_type,disp_sequence,disp_type,disp_value,dr,field_code,field_name,guideline,id,if_autocheck,if_datapower,if_default,if_desc,if_group,if_immobility,if_must,if_order,if_sum,if_used,instrumentsql,iscondition,max_length,opera_code,opera_name,order_sequence,pk_corp,pk_templet,prerestrict,resid,return_type,table_code,table_name,ts,userdefflag,value)values('Y','日历',3,62,0,null,0,'applydatefrom','申请日期从',null,'1002ZZ1000000000BVXH','N','N','Y',null,'N','N','N','N','N','Y',null,'Y',null,'=@','等于@',0,'@@@@','0001ZZ10000000009UXW',null,null,0,null,null,'2021-03-0217:38:36',null,null);insertintopub_query_condition(addisnull4power,consult_code,data_type,disp_sequence,disp_type,disp_value,dr,field_code,field_name,guideline,id,if_autocheck,if_datapower,if_default,if_desc,if_group,if_immobility,if_must,if_order,if_sum,if_used,instrumentsql,iscondition,max_length,opera_code,opera_name,order_sequence,pk_corp,pk_templet,prerestrict,resid,return_type,table_code,table_name,ts,userdefflag,value)values('Y','日历',3,63,0,null,0,'applydateto','申请日期到',null,'1002ZZ1000000000BVXI','N','N','Y',null,'N','N','N','N','N','Y',null,'Y',null,'=@','等于@',0,'@@@@','0001ZZ10000000009UXW',null,null,0,null,null,'2021-03-0217:39:20',null,null);执行后前台效果如下2、在查询引擎处增加参数点击参数后，点击增行新增两行按下图填写数据并保存3、在查询引擎处进行SQL设计点击SQL向导设计后，在弹出的界面上点击筛选条件，点击右侧的固定会新增一行，按照下图填写数据，注意需要新增两行，最后保存。
