Add more OData expression support to $filter

[yorek]

Right now, the $filter REST option supports the native OData operations:

http://docs.oasis-open.org/odata/odata/v4.01/cs01/part1-protocol/odata-v4.01-cs01-part1-protocol.html#sec_BuiltinFilterOperations

feedback from some early adopters is emerging in the sense that we should support also some of the native OData query functions:

http://docs.oasis-open.org/odata/odata/v4.01/cs01/part1-protocol/odata-v4.01-cs01-part1-protocol.html#sec_BuiltinQueryFunctions

we should see how many of those can be pushed to the database engine to make sure we can push as much as possible the computation effort to the database

[Licantrop0]

Data API builder should output standard OData. It would conform also to Microsoft Graph (supporting expands, navigation properties, grouping, etc...) and there are already standard libraries to interact with it: https://github.com/OData/odata.net

[Andy65]

At the very least it should support: contains and ideally should also support startsWith and endsWith

[nickmartin1ee7]

@Andy65, agreed. A partial match would increase the utility of the $filter; otherwise, this would result in overfetching and client-side filtering.

[Vipersoft-01]

So is this feature being developed? Does anyone know? :)

[robxgd]

Hi, any update on this? This feature would bring a lot of value to the DAB