在5.0列表过滤方案中，进行过滤的话就会报错。设置如图所示：
显示报错如下图所示：
分析发现是在拼接过滤语句处出错，拿到的语句是： select * from (
select t0.FBILLNO As FBILLNO,t0.FDOCUMENTSTATUS As FDOCUMENTSTATUS,t0.FSTOCKORGID As FStockOrgId_Id,t0.FPRDORGID As FPrdOrgId_Id,
t1.FMATERIALID As FMaterialId_Id,t1.FPRODUCTTYPE As FPRODUCTTYPE,t1.FUNITID As FUnitID_Id,t1.FMUSTQTY As FMUSTQTY,t1.FREALQTY As FREALQTY,t1.FSTOCKID As FStockId_Id,
t124.FF101504 As FAuxpropId_FF101504_Id,t124.FF101502 As FAuxpropId_FF101502_Id,t124.FF102002 As FAuxpropId_FF102002_Id,t124.FF101501 As FAuxpropId_FF101501_Id,
t124.FF101503 As FAuxpropId_FF101503_Id,t1.FSHIRTORDNO_LT As FSHIRTORDNO_LT,t1.FPONO_LT As FPONO_LT,t1.FCUSTSTYLENO_LT As FCUSTSTYLENO_LT,t1.FSELFSTYLENO_LT As FSELFSTYLENO_LT,
t0.FPRINTNUM As FPRINTNUM,t1.FIDENTITY_LT As FIDENTITY_LT,t0.FCANCELSTATUS As FCANCELSTATUS,t0.FBILLTYPE As FBILLTYPE,t0.FSTOCKORGID As FSTOCKORGID,t0.FFORMID As FFORMID,
t0.FID As FID,t1.FENTRYID As t1_FENTRYID,t1.FSeq As t1_FSeq,ROW_NUMBER() OVER(ORDER BY t0.FCREATEDATE DESC,t0.FBILLNO DESC , t1.FSeq ASC ) fidentityid
FROM T_PRD_INSTOCK t0 LEFT JOIN T_PRD_INSTOCKENTRY t1
ON (t0.FID = t1.FID )
WHERE ((((t0.FCREATEDATE >= {TS '2014-12-16 00:00:00'}) AND (t0.FCREATEDATE < {TS '2014-12-17 00:00:00'})) AND t0.FENTRUSTINSTOCKID = 0))
AND (t0.FSTOCKORGID IN (1, 100001, 100002, 100003, 100004, 2231159))
AND
t0.FSTOCKORGID IN (1, 0) AND
t0.FFORMID = 'PRD_INSTOCK' ) TLIST where fidentityid >= 1 and fidentityid <= 200
所关联表并无 T_BAS_FLEXVALUESDETAIL t124这个表。
