HubDB Listing Page By Month

[cives]

Hi all — I'm working on a listing page that separates all HubDB rows by month (picture below):

I'm currently looping through the table several times to achieve this structure, though the way I'm doing it isn't the cleanest, especially for querying:

<h2 class="pt-10">January 2016</h2>
{% for row in hubdb_table_rows(2638818, queryparam) %}
{% if (row['publish_date']|datetimeformat('%m/%d/%Y')) == '01/01/2016' %}
<p><a href="{{ request.path }}/{{ row.hs_path }}">{{ row.hs_name }}</a> - <span><i>By: {{ row.author.name }}</i></span></p>
{% endif %}
{% endfor %}

<h2 class="pt-10">February 2016</h2>
{% for row in hubdb_table_rows(2638818, queryparam) %}
{% if (row['publish_date']|datetimeformat('%m/%d/%Y')) == '02/01/2016' %}
<p><a href="{{ request.path }}/{{ row.hs_path }}">{{ row.hs_name }}</a> - <span><i>By: {{ row.author.name }}</i></span></p>
{% endif %}
{% endfor %}
            
<h2 class="pt-10">March 2016</h2>
{% for row in hubdb_table_rows(2638818, queryparam) %}
{% if (row['publish_date']|datetimeformat('%m/%d/%Y')) == '03/01/2016' %}
<p><a href="{{ request.path }}/{{ row.hs_path }}">{{ row.hs_name }}</a> - <span><i>By: {{ row.author.name }}</i></span></p>
 {% endif %}
{% endfor %}

What would the markup look like using just one loop? 

[sharonlicari]

Hey @cives 

Thank you for the information provided.I'll tag a few experts that can share their experience with you.    

Hey @Jsum @Reg @Adesignl  any thoughts you would like to share with @cives?   

Thanks & Happy Friday

Sharon

[Jsum · Accepted solution]

This post will help: https://community.hubspot.com/t5/CMS-Development/Can-i-add-date-title-to-my-blog-quot-all-blog-post-...