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

giedrius-grazevicius May 17, 2021, 4:02pm 12

Currently, there is no way to enforce the order.

API will always apply some sort, of no sort is supplied, it will sort by _createdDate.

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