cancel
Showing results for 
Search instead for 
Did you mean: 

CAP: filtering with $expand property does not work on SQLite DB

Hi,

I am trying to filter a table by a navigation property, in OData V4, where the expanded property is an object (not a list).

The filtering is working on HANA DB, but not locally with SQLite.

Is there a way to filter with expand properties on SQLite?

Thank you.

Accepted Solutions (1)

Accepted Solutions (1)

johannesvogel
Advisor
Advisor

Hi Madalina,

unfortunately, this is a known gap on our sqlite implementation, that filtering on expanded navigation properties is not possible.

However, we have it on our radar 🙂

Best regards,

Johannes

hi johannesvogel is there any indication when this will be picked up and fixed? It does seem to work in the JAVA implementation so maybe they learn from that?

johannesvogel
Advisor
Advisor
0 Kudos

Hi ramondb,

it's still on the roadmap. Unfortunately, we don't have a date until it'll be fixed. We'll publish it in our release notes once it's done.

Best regards,

Johannes

Fjaoos
Participant
0 Kudos

Hi johannesvogel is this still the case?

johannesvogel
Advisor
Advisor

Yes, my comment is still valid but we are working on it at the moment.

Answers (0)