How to filter HubDB data with foreign table

Develop, Build & Integrate CMS Development
1

I’ve 3 tables in HubDB. One is main table and other tables are foregin table. I want to filter the data based on the column of foregin table.

There is not anything related to foregin table in HubDB Filter API documentation.

2

Hi @Hubmonks, I haven’t tested this myself, but I think this would work:

{% set child_table_columns = hubdb_table_column(dynamic_page_hubdb_row.hs_child_table_id) %}{% for column in child_table_columns %} // do stuff with the data e.g. {% if column.title == 'xyz' %} {% endif %}{% endfor %}