Nested Hubdb

SOLVE
rohansdeeson
Top Contributor

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

0 Upvotes
1 Accepted solution

Accepted Solutions
Kevin-C
Solution
Recognized Expert | Partner

Hey @rohansdeeson 

 

Might this article help?

 

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

View solution in original post

0 Upvotes
1 Reply 1
Kevin-C
Solution
Recognized Expert | Partner

Hey @rohansdeeson 

 

Might this article help?

 

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

View solution in original post

0 Upvotes