Filter based on field in a referenced CMS

[Seej]

Wix Studio

I would like to filter a dataset (both within the CMS and the dataset settings) by the tag of a referenced CMS.

CMS 1
Field 1 (Primary): Name
Field 2 (Tag): A,B,C

CMS 2:
Field 1 (Primary): Name
Field 2: Rich text
Field 3: Reference CMS 1

I would like to filter CMS 2 by the tag field of CMS 1.
Eg. Filter the data to only show the rows that have A or B.

How would I achieve this?

[amandam]

If you search teh forum there are some other posts similar to what you are trying to achieve. Here is one, for example, that may give you an idea of how to get started

How to filter a dataset with a multi reference

Hi, I have a dataset (dataset1) with a reference record. In this record you can select multiple values from an other dataset (dataset2). dataset1 [image] dataset2 [image] Question : How can I filter this dataset with code? I tried: $w('#dataset1').setFilter(wixData.filter().hasSome("eventTyp","2")); Result have to be : Event 1 and Event 2