# How to use a drop-down list to filter data in a table?

**URL:** <https://forum.inductiveautomation.com/t/how-to-use-a-drop-down-list-to-filter-data-in-a-table/75305>\
**Category:** Ignition\
**Tags:** perspective\
**Created:** [June 20, 2023, 8:32pm UTC](https://forum.inductiveautomation.com/t/how-to-use-a-drop-down-list-to-filter-data-in-a-table/75305 "2023-06-20T20:32:39Z")\
**Posts on this page:** 1\
**Showing post:** 13

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [July 7, 2023, 10:13pm UTC](https://forum.inductiveautomation.com/t/how-to-use-a-drop-down-list-to-filter-data-in-a-table/75305/13 "2023-07-07T22:13:39Z")

</div>

Your problem is very similar to this:

> [@Controling bindings evaluation order](https://forum.inductiveautomation.com/t/controling-bindings-evaluation-order/75842/23):
>
> Try this: 
> 
> > **View JSON**
> >
> > { "custom": { "isFresh": true }, "params": { "category\_id": "", "family\_id": "", "item\_id": "" }, "propConfig": { "custom.isFresh": { "access": "PRIVATE", "binding": { "config": { "expression": "coalesce({view.params.family\_id}, {view.params.category\_id},…

Just differs on what to do with the dropdown values at the end. Note how little scripting is actually needed. Certainly not needed to run the named query (and probably shouldn't be, to keep the flow of data smoothly asynchronous).

---

_[View the full topic](https://forum.inductiveautomation.com/t/how-to-use-a-drop-down-list-to-filter-data-in-a-table/75305)._