# Hubdb selectattr filtering.

**URL:** <https://community.hubspot.com/t/hubdb-selectattr-filtering/113770>\
**Category:** CMS Development\
**Created:** [August 5, 2024, 9:57am UTC](https://community.hubspot.com/t/hubdb-selectattr-filtering/113770 "2024-08-05T09:57:29Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![BBecker1](https://avatars.discourse-cdn.com/v4/letter/b/e480ec/32.png) [@BBecker1](https://community.hubspot.com/u/BBecker1)\
**Post date:** [August 5, 2024, 9:57am UTC](https://community.hubspot.com/t/hubdb-selectattr-filtering/113770/1 "2024-08-05T09:57:29Z")

</div>

Hello,  
I have in my hubspot code a filter. this works great but now I dont want to have empty filters in my code.  
In my hubdb I have a column called “system” with the value rearing  
all\_items gives back 22 items  
I dont want to show the values that have no rows.

```lia-code-sample
 {% set solutionVal2 = module.default_solution %}
 {% set queryparam2 = '&solutions__contains=' + solutionVal2 %} 
 {% set all_items = hubdb_table_rows(module.hubdbtable_field, queryparam2) %}

 {% for choice in types %}
 {% set choice_name = choice.name | regex_replace("[&\\s\\-]", "") %}
 {% set filtered_items = all_items | selectattr('system', 'equalto', 'rearing') %}

 {% set type_list = type_list~choice.id|list %}
 <div class="cat action" results="{{ filtered_items | length }}">
 <label>
 <input type="checkbox" id="{{choice.id}}" name="{{choice.name}}" value="{{choice_name}}"><span>
 <div>
 <svg width="12" height="10" viewBox="0 0 12 10" fill="none" xmlns="http://www.w3.org/2000/svg">
 <path d="M4.81753 6.49487L9.993 0.873976C10.4519 0.375576 11.1924 0.375307 11.6516 0.873374C12.116 1.37708 12.1162 2.19829 11.652 2.70226L5.79809 9.05814C5.25539 9.64738 4.37978 9.64727 3.8372 9.0579L0.347771 5.26749C-0.116169 4.76354 -0.115887 3.94258 0.348399 3.439C0.8077 2.94083 1.54836 2.94127 2.00716 3.43999L4.81753 6.49487Z" fill="white"/>
 </svg>

 </div>{{choice.name}}</span>
 </label>
 </div>

 {% endfor %}

```

---

<div class="post-metadata">

**Author:** ![BBecker1](https://avatars.discourse-cdn.com/v4/letter/b/e480ec/32.png) [@BBecker1](https://community.hubspot.com/u/BBecker1)\
**Post date:** [August 5, 2024, 2:21pm UTC](https://community.hubspot.com/t/hubdb-selectattr-filtering/113770/2 "2024-08-05T14:21:06Z")

</div>

The column “solutions” and “systems” are multiselects

---

<div class="post-metadata">

**Author:** ![BBecker1](https://avatars.discourse-cdn.com/v4/letter/b/e480ec/32.png) [@BBecker1](https://community.hubspot.com/u/BBecker1)\
**Post date:** [August 5, 2024, 2:37pm UTC](https://community.hubspot.com/t/hubdb-selectattr-filtering/113770/3 "2024-08-05T14:37:30Z")

</div>

Solution i found:

```lia-code-sample
{% set table_id = module.hubdbtable_field %}
{% set queryparam2 = '&solutions__contains=' + solutionVal2 %}
{% set multiselect_column_name = item.column_name %}
{% set table = hubdb_table_rows(table_id, queryparam2) %}

{% set table_filtered_multiselect = table|selectattr(multiselect_column_name)|map(multiselect_column_name) %}

 {% set used_multiselect_options = [] %}
 {% for item_fil in table_filtered_multiselect %}
 {% for subitem in item_fil %}
 {% do used_multiselect_options.append(subitem) %}
 {% endfor %}
 {% endfor %}

 {# remove duplicates and sort the options #}
 {% set used_multiselect_options = used_multiselect_options|unique|sort(False, False, "order") %}

 {% for tsa in used_multiselect_options %}
 {% set choice_na = tsa.name | regex_replace("[&\\s\\-]", "") %}
 <div class="cat action" results="{{ used_multiselect_options | length}}">
 <label>
 <input type="checkbox" id="{{tsa.id}}" name="{{tsa.name}}" value="{{choice_na}}"><span>
 <div>
 <svg width="12" height="10" viewBox="0 0 12 10" fill="none" xmlns="http://www.w3.org/2000/svg">
 <path d="M4.81753 6.49487L9.993 0.873976C10.4519 0.375576 11.1924 0.375307 11.6516 0.873374C12.116 1.37708 12.1162 2.19829 11.652 2.70226L5.79809 9.05814C5.25539 9.64738 4.37978 9.64727 3.8372 9.0579L0.347771 5.26749C-0.116169 4.76354 -0.115887 3.94258 0.348399 3.439C0.8077 2.94083 1.54836 2.94127 2.00716 3.43999L4.81753 6.49487Z" fill="white"/>
 </svg>

 </div>{{tsa.name}}</span>
 </label>
 </div>
 {% endfor %}

```