Really need the ability to add a filter to a dataset based on a Reference Field. Reference fields do not currently show up/are not available in the Add Filter dialog box.
Reference Field functionality is severely limited without this functionality.
Hey!
You can currently have 1 dataset with Reference field and apply a filter on it using “Same as” + another Dataset which points to the same Collection as mentioned Reference field.
Let’s say you have Products and Reviews collections. Review collection has Reference field which points to Products collection. Then, you can add dynamic item page for Products, then add dataset that points to Reviews and add filter on this dataset using Reference field + “Same as” condition + Products dataset.
This will filter out Reviews based on the items returned in Products dataset.
Is there some other filtering capability you’re missing?
Thanks for the advice. I will give it a go …
How do you accomplish the same as in code?
Well I have a repeater, and two databases first database is for shops and the second database is for products. The repeater is linked to the product database with a search bar to search the products, and in the search option I have an option to search by category–> which is in the shop database, I referenced it in product database as the owner field to get all the information from the shop database, but the search is unavailable in the code, and when i try the “same as” + shop dataset all the products disappear, and i can’t figure out what i need to do, please help!!!