Hi,
I looked through the forum and couldn't figure out a way to do it:
I have 2 collections: Apartments, ApartmentsManagment.
The Apartments collection holds data generated by members. other members are allowed to read it.
The ApartmentsManagment holds information whether the data in the Apartments is valid: s.t. for each record in Apartments, there is a correspondence record in ApartmentsManagment, with a boolean flag called "valid". The "valid" flag is set by the site admin (e.g. users does not allowed to change this entry). It being used for moderation.
Now, I want to other users of the site to see only Apartments that are valid. I also want the users to be able to filter the Apartments based on other conditions e.g. "rent".
I saw the article https://support.wix.com/en/article/displaying-content-from-multiple-database-collections-using-reference-fields-4034931
I think that it possible to use that solution, with a caveat: the approach describe there allows only one Artist.
Another approach I thought is to use a "Hook" to add a filter to the query of Apartments, but still I couldn't find a way to filter based on the other collection.
Maybe my design is flawed, if so, feel free to suggest a better design.
Any help will be very appreciated!