Using contact property as filter query in the hubdb_table_rows() function

[faizwaris]

Hi,

I have a table (id = 5461277), two columns in the table are - 'trip_code' and 'trip_name'

I have a contact property named 'drdestination1' which is equal to 'trip_code' value in the table above.

I want to dynamically display 'trip_name' column value for every user with unique 'drdestination1' contact property. I'm not getting any value for 'trip_name' as the filter query passed is not correct. What's the right way to achieve this?

This is the code I'm using - 

{% set abc = contact.drdestination1%}
Contact Property is: {{abc}}
{% for row in hubdb_table_rows(5461277, "trip_code=contact.drdestination1") %}
{{row.trip_name}}
{% endfor %}

[MBERARD]

Hi @faizwaris ,

I think that the contact property value is not rendered when you quering your hubdb.

Can you try the following code:

{% for row in hubdb_table_rows(5461277, "trip_code={{ contact.drdestination1|render }}") %}
    {{row.trip_name}}
{% endfor %}

Kind regards,

Matthieu

matthieu.berard@markentive.com

[faizwaris]

it's showing syntax error for this