How to Filter HubDB based on select list

SOLVE
Highlighted
Top Contributor

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

Reply
0 Upvotes
1 Accepted solution

Accepted Solutions
HubSpot Moderator

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
Reply
0 Upvotes
2 Replies 2
HubSpot Moderator

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
Reply
0 Upvotes
Top Contributor

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

Reply
0 Upvotes