Hide expired rows

Develop, Build & Integrate CMS Development
1

I’m sure this is basic but I can’t figure it out.

I need to hide any rows in this db that are past the expired date in a column named expiration_date.

Thanks!

<!-- variable contains all unfiltered table data -->
{% set data = hubdb_table_rows(6825372, ‘&published=true’) %}

<!-- Loop through each row -->
{% for row in data %}

<!-- carrier -->
{# Loop through each carrier in our Foreign ID column #}
{% for carriers in row.filter_a %}
<span class=“aep-carrier”>{{ carriers.name }}</span>
{% endfor %}
<!-- resource title -->
<span class=“aep-title”>{{row.name}}:</span>
<!-- description with url -->
<span class=“aep-description”>
{% if row.page_url %}
<a href=“{{ row.page_url }}” target=“_blank”>{{row.description}}</a>
{% endif %}
</span>

<!-- description with download link -->
<span class=“aep-description”>
{% if row.link %}
<a class=“aep-description” href=“{{ row.link }}” target=“_blank”>Download</a>
{% endif %}
</span>
<hr>
{% endfor %}

2

@DPueppke - I’d suggest one approach to this is filtering the table rows when you retrieve them using something like:

{% set table = hubdb_table_rows(module.hubdbtable, queryparam) %}

where (for instance with a timestamp value in the expiration column):

{% set queryparam = 'expiration_date__gte=0s%}

The explanation of these query strings, including the ‘0s’ shorthand for current time is at: Accounts Dashboard | HubSpot

You can also add a sort order etc. into this query.

I hope this is helpful

Steve