topic Re: How to Filter HubDB based on select list in CMS Development

How to Filter HubDB based on select list

ben-duchy — Tue, 05 Nov 2019 09:20:16 GMT

I currently have a select list with 4 options:

Available
Unavailable
Reserved
Sold

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' ?

Re: How to Filter HubDB based on select list

lscanlan — Wed, 13 Nov 2019 21:52:56 GMT

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.

Re: How to Filter HubDB based on select list

ben-duchy — Thu, 14 Nov 2019 10:50:12 GMT

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!

Re: How to Filter HubDB based on select list

Graham_USMC — Fri, 22 Jan 2021 22:36:51 GMT

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)