# Dropdown matching/sorting not working

**URL:** <https://forum.inductiveautomation.com/t/dropdown-matching-sorting-not-working/105635>\
**Category:** Ignition\
**Tags:** perspective\
**Created:** [April 28, 2025, 3:48pm UTC](https://forum.inductiveautomation.com/t/dropdown-matching-sorting-not-working/105635 "2025-04-28T15:48:48Z")\
**Posts on this page:** 1\
**Showing post:** 2

<div class="post-metadata">

**Author:** ![Transistor](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/transistor/32/3380_2.png) [@Transistor](https://forum.inductiveautomation.com/u/Transistor)\
**Post date:** [April 28, 2025, 4:30pm UTC](https://forum.inductiveautomation.com/t/dropdown-matching-sorting-not-working/105635/2 "2025-04-28T16:30:26Z")

</div>

Q1. What flavour of SQL?  
Q2. It looks like you are using a Named Query. Correct?  
You could try,

```sql
SELECT columnName
FROM tableName
WHERE columnName LIKE CONCAT('%', :name, '%')

```

I suspect, however, that you are misusing the dropdown's search feature. The idea is that you generate the `options` list with a Query Binding which uses your Named Query. The dropdown's search feature just filters which dropdown options are displayed without the need to re-query the database. This should work for your requirements.

Please see [Wiki - how to post code on this forum](https://forum.inductiveautomation.com/t/wiki-how-to-post-code-on-this-forum/77831). Welcome to the forum!

---

_[View the full topic](https://forum.inductiveautomation.com/t/dropdown-matching-sorting-not-working/105635)._