I am developing a custom module that pulls data from HubDB and displays it as a table on the site.
The goal is to make so the content editor can drop the table module onto the page and select the table. Which is working fine in terms of selecting different HubDB tables are being selected and rows are being pulled in.
I can see that all row IDs from a HubDB table are being pulled in, and the HTML is rendering all the rows. However, the data from columns stops at 10. This makes me think I may be hitting some kind of call limit of 10, although I don’t believe I am.
Quick video explanation
Any or ideas would be greatly appreciated.
{# Table Macros #}
{% set hubdb_table = hubdb_table(module.hubdb_tables.choose_table) %} {# Selects the table #}
{% set column_count = hubdb_table.columns|length %} {# Number of columns in the table #}
{% set skipped_column_count = column_count - 1 %} {# Skip first column (Name) #}
{% set row_ids = [] %}
{% for row_id in hubdb_table_rows(hubdb_table.id) %}
{% set _ = row_ids.append(row_id.hs_id) %}
{% endfor %}
{# Sorting based on user selection #}
{% if module.hubdb_tables.sort_rows == 'most_recent' %}
{% set sorted_row_ids = row_ids %}
{% elif module.hubdb_tables.sort_rows == 'oldest' %}
{% set sorted_row_ids = row_ids|reverse %}
{% else %}
{% set sorted_row_ids = row_ids %} {# Default to no sorting #}
{% endif %}
{# HTML Starts #}
<div class="tabledb-wrapper_{{ name }}">
<div class="tabledb-container_{{ name }}" role="table" aria-label="">
<div class="tabledb_{{ name }} headertb firstrow" role="rowgroup">
{% for i in range(1, column_count) %} {# Loop through columns, skipping the first column #}
{% set column_info = hubdb_table.columns[i] %}
<div class="rowdb_{{ name }}{% if loop.first %} sticky {% endif %}" role="columnheader">{{ column_info.label }}</div>
{% endfor %}
</div>
{% for row_id in sorted_row_ids[:20] %} {# Tried to manually set number of rows to come in #}
{% set hubdb_row = hubdb_table_row(hubdb_table.id, row_id) %}
<div class="tabledb_{{ name }} rowdb_{{ name }}" role="rowgroup">
{% for i in range(1, column_count) %} {# Loop through columns, skipping the first column #}
{% set column_info = hubdb_table.columns[i] %}
{% set value = hubdb_row[column_info.name] %}
{# Check if processing the first column #}
<div class="rowdb_{{ name }}{% if loop.first %} sticky {% endif %}" role="cell">{{ value }}</div>
{% endfor %}
</div>
{% endfor %}
</div>
</div>