Repository navigation
Support for simple IN operator #5
Description
Do you have any plan to support simple IN operator ?
I see that this library is still a work in progress.
Have you considered adding IN operator support ?
A simple IN operator dealing with string,long,double values would be a great addition.
example,
IN('US','UK','IN','NZ')
IN(1,2,3)
Metadata
Metadata
Assignees
Labels
No labels
Activity
eaxdev commentedon Aug 23, 2020
Yes, this is a good idea. I'll do it soon
#5 added IN operator in criteria
#5 added IN operator in criteria
eaxdev commentedon Aug 29, 2020
Implemented in the version 0.0.3. You can use json like this:
{ "fields": [ { "column": "field1" }, { "column": "field2", "alias": "test" } ], "from": [ { "table": "table1", "schema": "schema" } ], "where": { "or": [ { "in": { "fieldName": "field3", "values": [ "US", "UK", "IN", "NZ" ] } }, { "eq": { "fieldName": "field4", "value": "3" } } ] } }