If you try to use parenthesis in the $filter, it will just return syntax error.
For example, the following query works:
http://localhost:3000/aircraft?$filter=role eq 'transport' and manufacturer eq 'xxx'
while this one doesn't:
http://localhost:3000/aircraft?$filter=(role eq 'transport' and manufacturer eq 'xxx')
and it just returns: "Syntax error at ''xxx')'.
This problem makes it impossible to define complex filters and, more importantly, it limits the usage of client-side libraries that consume OData services (like Kendo UI for Angular), since they often generate filters with parenthesis.
If you try to use parenthesis in the $filter, it will just return syntax error.
For example, the following query works:
http://localhost:3000/aircraft?$filter=role eq 'transport' and manufacturer eq 'xxx'while this one doesn't:
http://localhost:3000/aircraft?$filter=(role eq 'transport' and manufacturer eq 'xxx')and it just returns: "Syntax error at ''xxx')'.
This problem makes it impossible to define complex filters and, more importantly, it limits the usage of client-side libraries that consume OData services (like Kendo UI for Angular), since they often generate filters with parenthesis.