[Not possible] Repeater with references (nested)

I hope the title covers the question. I have a table 1 which has a reference to a different table 2. When you add a repeater which links to the dataset of table 2, you can link all columns to elements of an item, so table 1 objects and table 2 objects. Sometimes going to table 3 from table 2.

However:

  1. You can’t seem to link items from table 1 to the filters of the dataset properties
  2. If you program a ‘query’ you can connect it to a repeater too. You can also assign data to elements in the code. But how do you then assign a referenced item? If I print the result of a query it looks like this:
 {"_id":"039e6401-f8c0-494d-a8a9-50eea52f9c29","_owner":"422dc1f8-da72-4e6b-99cd-5f26220a1fee","_createdDate":"2017-12-30T09:32:58.862Z","_updatedDate":"2017-12-30T09:33:25.645Z","translation_id":"en_dc2c","trail_code":{"ref":"9513f603-1693-4bba-8bd6-7ada1897c977"},"language_code":{"ref":"5c35153a-b3ef-4ee8-996c-5c287e06a7db"},"trail_description":"<p><span style=\"font-family:futura-lt-w01-light,sans-serif;\">Starting in Wembury, in the beautiful South Hams, you will follow the 17 mile Erme-Plym Trail to Ivybridge where you will meet the Two Moors Way, a 100 mile waymarked trail from the South of Dartmoor to North of Exmoor where it meets the sea in Lynmouth.</span></p>","trail_title":"Devon Coast to Coast"} 

As you can see, it doesn’t include the referenced data only the column.

To be clear, each item of the repeater has attributes in both tables which I want to display.

In addition, if the referenced table has a reference to a third table, you can’t choose data links to that table in the repeater.

I looking in several methods but can’t seem to find this is possible. Looking in some vid’s it is also usually done with more then on repeater. Marking this as not possible for now.

Hi Edgar -

I have a general question that I am hoping you may be able to answer. I want to connect multiple datasets to one dynamic page in Wix, therefore allowing me to access information from both collections within the page. I am having trouble completing this task, I was wondering if you have any advice?? Thank you.

Hi Edgar,
I think you can use data hooks to help you solve some of your use cases. Hooks let you do manipulations on your query results. This way you can, for example, populate a result with additional data you need.
Have a look here: https://www.wix.com/code/reference/wix-data.Hooks.html

Yotam -

Do you know how to use a query and an equality statement when trying to make the equality in regards to a field that is a reference field? That is, can I have a .eq() statement with the field being a reference field?