AND Queries With Multiple Expressions Specifying the Same Field do not work

[hogpilot]

The following does not return as expected:

getMongoQuery('field > 1 AND field < 5')
> { field: { "$lt": 5 } }

Expected result:

{ "$and": [ { field: { "$gt": 1 }}, { field: { "$lt": 5 } } ] }
// OR
{ field: { "$gt": 1, "$lt": 5 } }

[orgoldfus]

@hogpilot - In such cases, I find it clearer to use the BETWEEN operator, which is already supported.
However, it should work with this syntax as well.

[hogpilot]

That's true, and what I had been doing for that specific numeric example. However, it doesn't work with strings or mixed types, which is why I found this issue.

For example:
getMongoQuery('field IS NOT NULL AND field != "deleted"')