Filtering data in Hubdb tables

Developer Support CMS Development
1

Hello,
I am currently fetching data from my hubdb into my emails. however i would like to filter the displayed data based on a column in the Hubdb.

I just went through this documentation on filtering displayed data from HubDB with repect to a certain column : Accounts Dashboard | HubSpot

However i am not able to filter data, as i believe i am misusing this line of code in my current template.
Noting: my code is successfully fetching everything from hudb and displaying it in the email, i just want to filter with respect to a column “email” in my hubdb table.
My Code:
{% set rows = hubdb_table_rows(5294924) %}
{% if rows|length %}
{% for row in rows %}
{% set query = “email__contains=”~contact.email %}

I would really appreciate some help on how to use the filter line of code in my existing coded template to display rows that meet this criteria as this is top priority for me.

2

Hi @ChrisChiha , you need to reference your query when you set your hubdb table row, like this:

{% set query = "email__contains="~contact.email %}{% set rows = hubdb_table_rows(5294924, query) %}{% if rows|length %}{% for row in rows %}{% endfor %}{% endif %}

Hope that helps.