We use cookies to make HubSpot's community a better place. Cookies help to provide a more personalized experience and relevant advertising for you, and web analytics for us. To learn more, and to see a full list of cookies we use, check out our Cookie Policy (baked goods not included).
Nov 5, 2019 4:20 AM
I currently have a select list with 4 options:
I have managed to filter the table so each row will only display if Available is selected.
{% set table = hubdb_table_rows(module.table_id, "&status=Available") %}
Is it possible have an 'or' option on the filter for example 'only show if the status is Available or Reserved' ?
Solved! Go to Solution.
Nov 13, 2019 4:52 PM
Hi @ben-duchy,
You could include multiple options from a "Select" column using the "in" filter. Just for reference we have documentation on the HubL syntax here: https://designers.hubspot.com/docs/tools/hubdb. And the supported filters are documented here: https://developers.hubspot.com/docs/methods/hubdb/v2/get_table_rows.
So for example if your column's name is "availability", you could run your filter like this:
{% for row in hubdb_table_rows(<tableId>, "availability__in=Reserved,Sold") %} <p>The availability for {{ row.name }} is {{ row.availability.name }}.</p> {% endfor %}
That will print out the rows that have the options you've selected in your "Select" column. Hope that helps! Let me know if you have questions.
Leland ScanlanHubSpot Developer Support |
Nov 14, 2019 5:50 AM
Hi @lscanlan,
Yes you're right, I figured this out a couple of days ago...
{% set table = hubdb_table_rows(module.table_id, "&status__in=Available,Reserved&orderBy=status&orderBy=class") %}
Works perfectly!
Nov 13, 2019 4:52 PM
Hi @ben-duchy,
You could include multiple options from a "Select" column using the "in" filter. Just for reference we have documentation on the HubL syntax here: https://designers.hubspot.com/docs/tools/hubdb. And the supported filters are documented here: https://developers.hubspot.com/docs/methods/hubdb/v2/get_table_rows.
So for example if your column's name is "availability", you could run your filter like this:
{% for row in hubdb_table_rows(<tableId>, "availability__in=Reserved,Sold") %} <p>The availability for {{ row.name }} is {{ row.availability.name }}.</p> {% endfor %}
That will print out the rows that have the options you've selected in your "Select" column. Hope that helps! Let me know if you have questions.
Leland ScanlanHubSpot Developer Support |
Jan 22, 2021 5:36 PM
Thank you @lscanlan - This helped tremendously! It would be fantastical if there were more examples/explination (for us non-hard core coders) on filters page (https://legacydocs.hubspot.com/docs/methods/hubdb/v2/get_table_rows)
Nov 14, 2019 5:50 AM
Hi @lscanlan,
Yes you're right, I figured this out a couple of days ago...
{% set table = hubdb_table_rows(module.table_id, "&status__in=Available,Reserved&orderBy=status&orderBy=class") %}
Works perfectly!