Filtering 1 Dataset by another Dataset

Ask the community
,
1

I am having some problem with Dataset Filtering, bit difficult to explain.

I have a Master Database named ‘ArrivalsDatabase’
& I have another Database named ‘ArrivalsDB’

Now, inside both databases there is a column named ‘fileNumber’
In the Master Database the list is very long and contains dozens of ‘fileNumber’ along with other information such as ‘email’

However in my small Database ‘ArrivalsDB’ the number of ‘fileNumber’ is very small but it does not contain the associated emails, that is only available in the Master Database

I have a Table on my page and I have connected it to the Master Database ‘ArrivalsDatabase’ but I want to display only those rows whose ‘fileNumber’ is present in both ‘ArrivalsDatabase’ and ‘ArrivalsDB’

I tried this CMS: Displaying Content from Multiple Database Collections Using Datasets | Help Center | Wix.com

957×537 116 KB

There are a total of 3 ‘fileNumber’ matches between my 2 databases so by applying the above Dataset Filter I should be seeing all the 3 rows associated with the fileNumbers but instead I am seeing only 1

1153×173 27.9 KB

Anybody ?

4 Likes
2

Same problem! Did anyone help you? Did you solve it?

3

same problem here too. looks like this is another broken wix feature.

4

I think my familiarity with relational databases skewed my thinking. Here’s how I did it:

You need to create field in a database and assign it to ‘reference’. The reference must referenced to the primary key in another database.

If I wanted the ID to be my primary key, even though it already is, I used hooks to update my primary key field with the ID.

5

@brett82 thanks, interesting solution, I wil try. but did you figure it out yourself or you find something in the documentation?

6

A little bit from column A and little bit from column B. Excuse the pun. :wink:

Here the article I found: CMS: About Displaying Content from Multiple Database Collections Using Reference Fields | Help Center | Wix.com

Once you figure this out, it will open a lot of doors and even modify your approach. I have some pretty cool relational data working together.

7

thanks for the info!