OR statement in URL query string

[sudhish-ps]

Need to support OR statement in REST API, and to build right query string for that.
In some business case we have to filter the document with OR condition like below for e.g.;

From employee
Filter position == 'Manager' OR age >= 50

How to generate such queries with the parser and how to define such condition in query string ?.
Currently multiple query parameters specified in the query string is generating with AND condition only, but definitely there is need of OR also. However we can specify this condition as filter like this
{ $or: [ { quantity: { $lt: 20 } }, { price: 10 } ] } but need is to simplify this in standard query format.
Some thing like ?position=Manager&!age>=50 (where ! internally converts to OR).

Any option available?.

[leodinas-hao]

Hi @sudhish-ps , thanks for your comments. I had the similar thought as you mentioned the current logic doesn't handle OR condition and actually it doesn't handle AND as well. The real issue is it doesn't handle grouping. What you proposed using !& still won't resolve the issue of no grouping. Also, it conflicts with not exists "!" filter operator.

If you have another idea on this one, please don't hesitate to share and I'm more than happy to implement a proper change to improve this tool.

[sudhish-ps]

@leodinas-hao , Can we go with the operator | instead of ! which satisfies the technical meaning and purpose of its usage.

[sudhish-ps]

@leodinas-hao, could you go through our proposal provided above.

[leodinas-hao]

Hi @sudhish-ps, operator | won't solve the problem as the OR condition needs to in a group. Could you please have a look below example of how to do $or filter by passing json in query?

mongoose-query-parser/src/test.spec.ts

Line 131 in e29d68d

@test('should parse json filter')

Or please feel free to provide a PR for your solution?

Thanks.

[hatemragab]

Any updates?