Nov 24, 2022 5:46 PM
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 %}
Nov 25, 2022 5:36 AM
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
Nov 25, 2022 7:07 AM
it's showing syntax error for this