Filtering in Reference Field

Ask the community
,
1

Hello !
Before asking I searching discussion and don’t find answer, but all discussions situatd year ago, may be something changing in Corvide since that…

I do without problem filtering by some “text” FieldKey, For exampe named “tag”

$w(“#dataset13”).setFilter(wixData.filter()
.contains(“tag”, clickedItemData.title));

It is working…

But If I use Field which have text inside but really it REFERRING Field - Filtering not working.
I guess that such filtering is may be Impossible may be have some tricky.

If somebody new exact answer - I be appreciate

Thank You in advance
Sincerely, Mikhail

2

Previous forum post.
https://www.wix.com/corvid/forum/community-discussion/filtering-by-reference-fields
https://www.wix.com/corvid/forum/community-discussion/table-with-multiple-dataset-filtering

https://support.wix.com/en/article/working-with-multiple-item-reference-fields
https://support.wix.com/en/article/displaying-content-from-multiple-database-collections-using-reference-fields-4034931

https://www.wix.com/corvid/reference/wix-dataset.Dataset.html#setFilter
https://www.wix.com/corvid/reference/wix-data.html#query

3

Thank You - I solved it…
Yes, I use first advice reading Hidden ID -

I guess myself before read - that i HAVE TO DO read ID
(MY LITTLE EXPEREANCE in databases - ADVICE ME THAT IT IS only ONE WAY -
DO REFERANCE - BUT i DIDN’T GUESS - MAKE id VISIBLE…

`Immidiatelly after it all start to working

Thank You !!!

Now I can moving far in my project…

4

Hey I went through the links you posted but it’s still not clear to me how to filter by a reference field. I’m trying to use include() and filter() but can’t seem to combine them

 let query = wixData.query('posts')
        .include('categories')
        .eq('_id', category)
        .find();
    $w("#postsDataset").setFilter(wixData.filter(query));
5

I also faced with it problem and this post helped me to solve it:

https://www.wix.com/velo/forum/coding-with-velo/filtering-by-reference-fields/p-1/dl-5cd47d42ba77950016c62889-5a2d4e7aa7c61d001319ea1c-1