I have a parent database, that has 3/4 child DB's sitting underneath it. What I need is the page to pull in the 5 most recent entries and display them in a list.
I'm using the following code, but it doesn't appear to be working.
The code is meant to create an array, pulling in all entries across the child DBs, sort by date created, and then loop through 5 times and spit out the 5 latest entries.
What am I missing?
{% set childCombineArr = [] %}
{% for row in hubdb_table_rows(dynamic_page_hubdb_table_id, queryparam) %}
{% if row.hs_child_table_id %}
{% set child_table = hubdb_table_rows(row.hs_child_table_id) %}
{% for row in child_table %}
{% set timeAdded = row.createdAt %}
{% do childCombineArr.append({'timeAdded': timeAdded, 'row': row}) %}
{% endfor %}
{% endif %}
{% endfor %}
{% for item in childCombineArr|sort(True, False, 'timeAdded') %}
{% if loop.index <= 5 %}
{% set row = item.row %}
{{row.name}}
{% endif %}
{% endfor %}