# Custom filter with numeric values in SQL Source

**URL:** <https://community.glideapps.com/t/custom-filter-with-numeric-values-in-sql-source/71905>\
**Category:** Ask for Help\
**Tags:** data-sync, sql\
**Created:** [March 21, 2024, 10:54pm UTC](https://community.glideapps.com/t/custom-filter-with-numeric-values-in-sql-source/71905 "2024-03-21T22:54:28Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Eden](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eden/32/18651_2.png) [@Eden](https://community.glideapps.com/u/Eden)\
**Post date:** [March 21, 2024, 10:54pm UTC](https://community.glideapps.com/t/custom-filter-with-numeric-values-in-sql-source/71905/1 "2024-03-21T22:54:28Z")

</div>

Hi!

I’m trying to filter my Data based on custom filters.  
The problem: The filter primary ID’s are numbers. Which means that I can’t do “if value `contains`,” only `equals`- which would mean results are empty if one of the filters are not selected.

Due to the limitations of SQL Data sources, you can’t filter collections based on computed columns. So I can’t convert the columns in the table to text, to filter based on them.

A workaround of using Database views with columns formatted as text doesn’t work either because when pushing data to the real table, we need to reload the View, resulting in the entire screen reloading- which is not an option.

Any suggestions?

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [March 22, 2024, 12:40am UTC](https://community.glideapps.com/t/custom-filter-with-numeric-values-in-sql-source/71905/2 "2024-03-22T00:40:19Z")

</div>

So you’re trying to filter your data based on a number column? Or a computed column?

---

<div class="post-metadata">

**Author:** ![Eden](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eden/32/18651_2.png) [@Eden](https://community.glideapps.com/u/Eden)\
**Post date:** [March 22, 2024, 1:24am UTC](https://community.glideapps.com/t/custom-filter-with-numeric-values-in-sql-source/71905/3 "2024-03-22T01:24:55Z")

</div>

based on a number column.  
a computed column is impossible at the moment in SQL