Combine HubDB results and filter.

vperoza — Mon, 05 Nov 2018 18:39:10 GMT

I'm pulling data from 3 separate HubDB tables and combining them into one data set, like so:

{% set tbl1 = hubdb_table_rows(123) %}
{% set tbl2 = hubdb_table_rows(456) %}
{% set tbl3 = hubdb_table_rows(789) %}

{% set all_tbls = (tbl1 + tbl2 + tbl3) %}

I'd like to sort all_tbls by the NAME field that exists in all of the tables.

I have tried using the |sort filter when combining the results:

{% set all_tbls = (basic_rows + video_rows + webinar_rows)|sort('hs_name') %}

And I tried different references to the field (hs_name, name, NAME, Name)

I have tried using the |sort filter within the "for" statement:

{% for row in all_tbls|sort('name') %}
{{ row.name }}
{% endfor %}

Neither seems to work and I cannot find documentation on this.

Does anyone know how to sort the combined results?

Re: Combine HubDB results and filter.

vperoza — Mon, 05 Nov 2018 18:46:38 GMT

I just solved my own problem, so I'm sharing it here. This is the solution:

{% for row inall_tbls|sort(false, false, 'name') %}

{% endor %}