Nested Hubdb

[rohansdeeson]

So I have two HubDB Tables

One called experts one called expert_reviews

expert reviews has a foreign table link to experts

I have my Hubl set up to get all the details for three random experts like so

{% for row in hubdb_table_rows("experts","&orderBy=random()&limit=3") %}

{{ row.name }}


{% endfor %}

etc but now I want to return 1 review from each returned expert but I'm not sure how to reference them I have tried something like this

{% for review in hubdb_table_rows("expert_reviews","expert={{row.sb_id}}&orderBy=random()&limit=1") %}
          {% endfor %}

but that doesn't work can anyone give me any tips

[Kevin-C · Accepted solution]

Hey @rohansdeeson 

Might this article help?

Im sure you've seen it before, but if not I hope it helps!