Order HubDB Rows my multiple values (orderBy multiple columns)

Developer Support CMS Development
1

Hello

I need a HubDB output by lastname and then by firstname. So when two persons have the same lastname then it starts sorting by the firstname:

{% set queryparam = "&orderBy=lastname" %}
{% set table = hubdb_table_rows('team', queryparam) %}

{% for row in table %}
<div class="team-member">
Name: {{ row.lastname }} {{ row.firstname }}
<span><a href="{{ request.path }}/{{ row.hs_path }}">Link to Profile</a></span>
</div>
 {% endfor %}
2

Hi @peesen, you can include the orderBy parameter multiple times to sort by multiple columns so this should work:

{% set queryparam = "&orderBy=lastname&orderBy=firstname" %}