# HubDB Filters **URL:** \ **Category:** CMS Development\ **Tags:** hubdb\ **Created:** [December 17, 2021, 8:55pm UTC](https://community.hubspot.com/t/hubdb-filters/48768 "2021-12-17T20:55:27Z")\ **Posts on this page:** 3\ **Page:** 1
**Author:** ![JLamb14](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/jlamb14/32/29777_2.png) [@JLamb14](https://community.hubspot.com/u/JLamb14)\ **Post date:** [December 17, 2021, 8:55pm UTC](https://community.hubspot.com/t/hubdb-filters/48768/1 "2021-12-17T20:55:27Z")
Hello, I am working on a page listing remote notaries, and I need assistance with a filter and search bar. I am attempting to filter by state (state\_commissioned) and to add a search bar that will allow searching by name (hs\_name). I’m able to get the state options to show up in the filter, but nothing is happening when the option is selected. I have attached where I’m at below: ```lia-code-sample

Filter By State:

{% set queryparam = "" %} {% if request.query_dict.type in ["1", "2", "3", "4"] and request.query_dict.state_filter == "" %} {% set queryparam = queryparam ~ "&type="~request.query_dict.type|urlencode %} {% endif %} {% if request.query_dict.type in ["1", "2", "3", "4"] and request.query_dict.state_filter != "" %} {% set queryparam = queryparam~"&type="~request.query_dict.type|urlencode~"&state_filter__icontains="~request.query_dict.state_filter|urlencode %} {% endif %} {% if request.query_dict.type == "show-all" and request.query_dict.state_filter != "" %} {% set queryparam = queryparam~"&hs_name__icontains="~request.query_dict.state_filter|urlencode %} {% endif %}
{# Get eNotary Network Members from HubDB #} {% set queryParam = 'orderBy=random()' %} {% set table = hubdb_table_rows(5312178, queryParam)%} {% if table == [] %}

Sorry, no one found for that Search. Try changing your filter and search again.

{% else %} {% for row in table %}

{{ row.enotary_name }}

{{ row.enotary_company }} 
Time zone: {{ row.time_zone }}
State: {{ row.state_commissioned }}
 {{ row.enotary_email }}  
 {{ row.enotary_phone}}
{% endfor %} {% endif %} ``` ---
**Author:** ![dennisedson](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/dennisedson/32/28044_2.png) [@dennisedson](https://community.hubspot.com/u/dennisedson)\ **Post date:** [December 20, 2021, 6:32pm UTC](https://community.hubspot.com/t/hubdb-filters/48768/2 "2021-12-20T18:32:17Z")
@Anton , have any thoughts on this? ---
**Author:** ![Anton](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/anton/32/103167_2.png) [@Anton](https://community.hubspot.com/u/Anton)\ **Post date:** [December 29, 2021, 9:20am UTC](https://community.hubspot.com/t/hubdb-filters/48768/3 "2021-12-29T09:20:23Z")
Hi @JLamb14, try changing the code as follows: ```lia-code-sample {% require_js %} {% end_require_js %}

Filter By State:

{% set queryparam = "" %} {% if request.query_dict.type in ["1", "2", "3", "4"] and request.query_dict.state_filter == "" %} {% set queryparam = queryparam ~ "&type="~request.query_dict.type|urlencode %} {% endif %} {% if request.query_dict.type in ["1", "2", "3", "4"] and request.query_dict.state_filter != "" %} {% set queryparam = queryparam~"&type="~request.query_dict.type|urlencode~"&state_filter__icontains="~request.query_dict.state_filter|urlencode %} {% endif %} {% if request.query_dict.type == "show-all" and request.query_dict.state_filter != "" %} {% set queryparam = queryparam~"&hs_name__icontains="~request.query_dict.state_filter|urlencode %} {% endif %} {# Get eNotary Network Members from HubDB #} {% set queryParam = queryparam ~ 'orderBy=random()' %} {% set table = hubdb_table_rows(5312178, queryParam)%} {% if table == [] %}

Sorry, no one found for that Search. Try changing your filter and search again.

{% else %} {% for row in table %}

{{ row.enotary_name }}

{{ row.enotary_company }}
Time zone: {{ row.time_zone }}
State: {{ row.state_commissioned }}
{{ row.enotary_email }}
{{ row.enotary_phone}}
{% endfor %} {% endif %} ``` best, Anton