You can translate the question and the replies:

odata filter on array type

Hi, I am trying to use filter for array type column like below http://localhost:9090/server/tutorial/denodo-odata4-service/denodo-odata.svc/?$filter=srvlcdin_list={ ROW('') } Its giving error message as { "error": { "code": null, "message": "A collection expression is not allowed." } } Can you please let me know how to use odata and filter on compound types or it is not supported. Thank You
user
07-01-2021 02:47:11 -0500

2 Answers

Hi, The OData 4.0 service is used for accessing elements of the Denodo Platform. As of now, you can perform the filter condition on top of the normal fields but is not possible to apply the filter condition over elements of an array. For more information, you may take look at the [Known Limation](https://community.denodo.com/docs/html/document/denodoconnects/8.0/Denodo%20OData4%20Custom%20Wrapper%20-%20User%20Manual) section of the Denodo OData4 Custom Wrapper - User Manual. Hope this helps!
Denodo Team
07-01-2021 06:21:48 -0500
Thank you for the feeback. Thank You
user
07-01-2021 11:42:08 -0500
You must sign in to add an answer. If you do not have an account, you can register here