Filtering by a sub-field of a reference field

Ask the community
,
1

Hello all,

Does anyone know whether it is possible to run a query on a collection which includes .eq() (for example) on an underlying field of a reference field? Using .include() will bring the entire reference field + underlying fields as an array into the query which will allow access to the data post query, but it doesn’t seem possible to actually filter on the underlying fields. Or am I missing something?

2 Likes
2

Wix team? This seems pretty standard for a relational DB.

3

I need this too, otherwise what the point of reference field if you can’s filter/search by underlying fields?

4

Hi there

It sounds like you need to build a series of queries that use wix-data.query and wix-data.queryReference to get the underlying field matches in a promise chain. I don’t think it is possible, at the moment , to perform a single nested (chained) query in the find call.

Probably worth looking at the current set of feature requests. If there isn’t one for this feature then add one?

Steve