CMS Development

ben-duchy
Contributeur de premier rang

How to Filter HubDB based on select list

SOLVE

I currently have a select list with 4 options:

  1. Available
  2. Unavailable
  3. Reserved
  4. 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' ?

0 Upvotes
2 Accepted solutions
lscanlan
Solution
HubSpot Alumni
HubSpot Alumni

How to Filter HubDB based on select list

SOLVE

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 Scanlan

HubSpot Developer Support

View solution in original post

ben-duchy
Solution
Contributeur de premier rang

How to Filter HubDB based on select list

SOLVE

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! Smiley Happy

View solution in original post

0 Upvotes
lscanlan
Solution
HubSpot Alumni
HubSpot Alumni

How to Filter HubDB based on select list

SOLVE

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 Scanlan

HubSpot Developer Support
Graham_USMC
Contributor | Partner
Contributor | Partner

How to Filter HubDB based on select list

SOLVE

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)

ben-duchy
Solution
Contributeur de premier rang

How to Filter HubDB based on select list

SOLVE

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! Smiley Happy

0 Upvotes