Filter HubDB by row using Hubl

Develop, Build & Integrate CMS Development
3

I did not have the correct logic. I fixed the problem by adding ‘state=CA’ where state is the name/ID of the row and CA is the value i am sorting for.

{% set table = hubdb_table_rows(679969, 'state=CA') %}

{% if table == [] %}
<p class='align-center'>Sorry, no listings found for that Search. Try changing your fiter and search again.</p>
{% else %}

{% for row in table %}

<div class="container row-fluid">
 <div class="state-post-listing">
 <ul>	
 <li><a href="{{ row['embed'] }}">{{ row['date'] }} | {{ row['name'] }} | {{ row['state'] }}<a/></li>
 </ul>
 </div>
</div>

{% endfor %}
{% endif %}