# Dropdown Filter

**URL:** <https://forum.inductiveautomation.com/t/dropdown-filter/36308>\
**Category:** Ignition\
**Created:** [July 2, 2020, 4:41pm UTC](https://forum.inductiveautomation.com/t/dropdown-filter/36308 "2020-07-02T16:41:02Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![malejandroreyes](https://avatars.discourse-cdn.com/v4/letter/m/a8b319/32.png) [@malejandroreyes](https://forum.inductiveautomation.com/u/malejandroreyes)\
**Post date:** [July 2, 2020, 4:41pm UTC](https://forum.inductiveautomation.com/t/dropdown-filter/36308/1 "2020-07-02T16:41:02Z")

</div>

Hello all,

I have a question for Dropdown filter in Perspective, how can I filter data from a table created in Ignition using a Dropdown filter? Actually, I´m filtering data directly from database and it works, but I have trouble with null values from column to filter. I think that solution is filtering my table created in Ignition and not from SQL, because in my table I can assing a name for null values from SQL

---

<div class="post-metadata">

**Author:** ![BN14](https://avatars.discourse-cdn.com/v4/letter/b/9de053/32.png) [@BN14](https://forum.inductiveautomation.com/u/BN14)\
**Post date:** [April 16, 2021, 7:49pm UTC](https://forum.inductiveautomation.com/t/dropdown-filter/36308/2 "2021-04-16T19:49:08Z")

</div>

Did you ever figure this out? I’m looking to do something similar with a table and a pie chart.