以文本方式查看主题 - Foxtable(狐表) (http://www.foxtable.com/bbs/index.asp) -- 专家坐堂 (http://www.foxtable.com/bbs/list.asp?boardid=2) ---- 加载条件 (http://www.foxtable.com/bbs/dispbbs.asp?boardid=2&id=135332) |
-- 作者:有点甜 -- 发布时间:2019/5/23 18:52:00 -- .LoadFilter = "([判定结果] Like \'%料废%\' Or [判定结果] like \'%工废%\'Or [判定结果] Is Null) And [返修结果] Is Null or ([判定结果] Like \'%正常返修%\' Or [判定结果] like \'%长期待处理%\' Or [判定结果] Is Null) And [返修结果] Is Null" |
-- 作者:有点蓝 -- 发布时间:2019/5/24 9:29:00 -- 3个条件是“并且”还是“或者”的关系? 条件1 and 条件2 and 条件3 条件1 or 条件2 or 条件3
|
-- 作者:有点甜 -- 发布时间:2019/5/24 10:37:00 -- .LoadFilter =([判定结果] Like \'%料废%\' Or [判定结果] like \'%工废%\'and [报废人员] Is Null) or ([判定结果] Like \'%长期待处理%\' Or [判定结果] like \'%正常返修%\'and [返修结果] = \'返修报废\' and [报废人员] Is Null ) or [判定结果] Is Null" |
-- 作者:有点甜 -- 发布时间:2019/5/24 11:48:00 -- .LoadFilter = "[返修结果] = \'返修报废\' And [报废人员] Is Null And ([毛坯产地] <> \'48厂\' or [毛坯产地] is null)"\'" |