Question

如何代表中贡银行以下条件的想法

WHERE
     a = 1
AND  b = 2
AND  (c >= 3 OR c IS NULL)
AND  d = 4

搁置这一点,但似乎不可行:

{ a:1, b:2, c:{ $in:[ { $gte:3 }, { $exists: false } ] } , d:4 }

由于关键因素压倒了以下工作:

{ a:1, b:3, $or:[ { c:{ $gte:3 } }, { c:{ $exists:false } } ] , d:4 }

Any help is greatly appreciated

Answer 1

I think this is what you re looking for:

{ "a": 1, "b": 2, "$or": [ { "c": { "$gte": 3 } }, { "c": { "$exists": false } } ], "d": 4 }