top of page

Community X.

Connect with other creators, share ideas, give feedback and get the latest product updates.

Editor X

The rest is up to you.

Start Creating

Start Now

To see this working, head to your live site.

מילגאון אתר

Jan 02

Connect a repeater to a multipule collections

in General discussions

Hello,

I've 3 different collection :

Collcetion A

Collection B

Collection C

in collection A for each row I've a uniqID field

in collecion B + C I also have the same uniqID but as a refernce field to collection A uniqID field

now I have a repeater on my homepage that is taking the data from Collection A which is my master collection

in this repeater i want to show all the data from my 3 collections A+B+C

but when i connect the fields to dataSet B/C it still won't give me the correct value from the collection, they all only show the first row in the collection without considiration of the uninqID

what am I doing wrong?

Thank you

3 answers0 replies

3 Comments

WixProIsrael

Jan 02

Best Answer

There are several approaches to the subject

You can run a query with include to the referencing cell but this is only possible on one cell.

What I suggest is to pull the data from the referencing cells when you interacted with the item (for example when touching the item run a query and pull the related data)

There is an option to do this when loading the list as well, but it will burden the loading time because it will have to perform all the queries in a row (I tried it once, it worked well, but it depends on the volume of data)

You did not specify whether the connection is multiple references or a single reference of one item (this affects the search queries and the data pull)

If you need help you can contact me

https://www.wix.com/velo/reference/wix-data/wixdataquery/include

Unknown member

Jan 02

Replying to

Hi,

thanks for you quick reply.

I've only single reference. so if I understand what you are saying

i need to add an interaction/event to pull the data

for example:

onReady of the repeater I can add a query to pull the data from the dataSet filltered by the uniqId reference

do you have an example of how to do so?

can't seem to figure out how to connect the feilds in the repetear based on the pull data with the uniqID

WixProIsrael

Jan 03

Replying to

In a normal connection through the editor, the referring cell can be linked directly to the list(To the best of my knowledge, this can only be done on one referring cell)

This shows you an example where touching an item queries the database to find an identical item by the referring cell

$w("#myrepeater").onItemReady(($item, itemData, index) => { $item('#myitem').onMouseIn((event) => { wixData.query("Collection B") .eq("_id", itemData.referenceB) .limit(1) .find() .then((results) => { if (results.items.length != 0) { let myitem = results.items[0] ///your item to use } }); }); });

Hope I helped

bottom of page