|
楼主 |
发表于 2014-2-22 11:19:59
|
显示全部楼层
本帖最后由 lz_net 于 2014-2-22 11:21 编辑
jishuang 发表于 2014-2-22 09:23
可以在filter中自己设置查询条件
2014-02-22 11:18:27 [SQL Time]sql 执行时间:31ms, exec KSQL: SELECT HX_MRSCAP.* FROM HX_MRSCAP HX_MRSCAP WHERE ((fSCBM like'%冲压线%') AND (HX_MRSCAP.fXGJLZBID='F864B6FD253645E9AA3E7D9605B31502')) LIMIT 0, -1
--> sqlSELECT HX_MRSCAP.VERSION AS version, HX_MRSCAP.FPCH AS fPCH, HX_MRSCAP.FGYKH AS fGYKH, HX_MRSCAP.FSCBMID AS fSCBMID, HX_MRSCAP.FSCBM AS fSCBM, HX_MRSCAP.FCZYID AS fCZYID, HX_MRSCAP.FCZY AS fCZY, HX_MRSCAP.FXHHJZ AS fXHHJZ, HX_MRSCAP.FGXBH AS fGXBH, HX_MRSCAP.FGG AS fGG, HX_MRSCAP.FDW AS fDW, HX_MRSCAP.FRQ AS fRQ, HX_MRSCAP.FJHSCSL AS fJHSCSL, HX_MRSCAP.FSCSL AS fSCSL, HX_MRSCAP.FHGPSL AS fHGPSL, HX_MRSCAP.FFPSL AS fFPSL, HX_MRSCAP.FFXPSL AS fFXPSL, HX_MRSCAP.FBFSFZQ AS fBFSFZQ, HX_MRSCAP.FBZ AS fBZ, HX_MRSCAP.FXDR AS fXDR, HX_MRSCAP.FDJR AS fDJR, HX_MRSCAP.FXCQR AS fXCQR, HX_MRSCAP.FZJQR AS fZJQR, HX_MRSCAP.FJJDJ AS fJJDJ, HX_MRSCAP.FFPFY AS fFPFY, HX_MRSCAP.FJJGZ AS fJJGZ, HX_MRSCAP.fLZZBID AS fLZZBID, HX_MRSCAP.FXJBJ AS fXJBJ, HX_MRSCAP.FCZYLY AS fCZYLY, HX_MRSCAP.FXCQRLY AS fXCQRLY, HX_MRSCAP.FZJQRLY AS fZJQRLY, HX_MRSCAP.FSPR AS fSPR, HX_MRSCAP.FSPRLY AS fSPRLY, HX_MRSCAP.fXGJLZBID AS fXGJLZBID, HX_MRSCAP.fID AS HX_MRSCAP FROM HX_MRSCAP HX_MRSCAP WHERE (fSCBM LIKE ?) AND (HX_MRSCAP.fXGJLZBID = ?) )
--> binds:[%冲压线%, F864B6FD253645E9AA3E7D9605B31502]
请问“F864B6FD253645E9AA3E7D9605B31502”这个值是在哪里取呢?
这个应该是主表的fID,不过用getValue取fID是空的。 |
|