[ODATA-1241] Support common expressions as values in URL-JSON - OASIS Technical Committees Issue Tracker

XML

Word

Printable

Proposal:
Hide

Allow using common expressions as "values" in URL-JSON. This will allow to construct an array from properties as the left operand of the in operator:

$filter=[FirstName,LastName] in (["John","Doe"],["Jane","Smith"])

Note: a list of arrays is already allowed as the right operand.
Show
Allow using common expressions as "values" in URL-JSON. This will allow to construct an array from properties as the left operand of the in operator: $filter=[FirstName,LastName] in ([ "John" , "Doe" ],[ "Jane" , "Smith" ]) Note: a list of arrays is already allowed as the right operand.
Resolution:

Hide

https://github.com/oasis-tcs/odata-abnf/pull/5

https://www.oasis-open.org/committees/download.php/64118/odata-v4.01-wd06-part2-url-conventions-2018-10-19.docx

Show
https://github.com/oasis-tcs/odata-abnf/pull/5 https://www.oasis-open.org/committees/download.php/64118/odata-v4.01-wd06-part2-url-conventions-2018-10-19.docx

The in operator allows comparing a property to a list of values, e.g.

$filter=Name in ('Milk', 'Cheese')

For multi-part keys it would be helpful to allow comparison of a tuple of properties to a list of value tuples:

$filter=(Firstname,Lastname) in (('John', 'Doe'),('Jane','Smith'))

Note that this is natively supported by some databases: