Hi! I’m trying to write a query which outputs following result: [image] This result is a combination of columns from 2 collections: Collection_1 Collection_2 [image] [image] Can this be done in Wix without first having to query Collection_1 and Collection_2 to then manually create …

Hi @vervoortyves , as Wix Data is a Document Store. As is typical to this type of databases, we don’t really provide ability to do arbitrary joins. As @yoav-wix has explained, join operation as such is only possible on properly defined relationships (references). But in your case it can be done…

How to work with multiple-item references?

Ask the community

CODE-NINJA April 28, 2021, 5:43pm 9

@giedrius-grazevicius
Thumbs up! Good one!

Topic		Replies	Views
Join with wixData.query() function Ask the community code , question	1	763	October 18, 2019
Two collection in same data query on basis of reference key Ask the community code , question	4	1696	August 18, 2021
You can now add multiple items to Reference Field Type Be in the know code , wix-forms , question , news	59	4660	March 16, 2020
[wix-data] Multiple References - another post :) Ask the community code , question	3	497	September 7, 2020
Showing tables with several multi-reference fields Ask the community code , question	1	227	February 18, 2021

How to work with multiple-item references?

Related topics