# Dropdown Autocomplete

**URL:** <https://forum.inductiveautomation.com/t/dropdown-autocomplete/29292>\
**Category:** Ignition\
**Created:** [October 22, 2019, 4:49pm UTC](https://forum.inductiveautomation.com/t/dropdown-autocomplete/29292 "2019-10-22T16:49:38Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![karolld](https://avatars.discourse-cdn.com/v4/letter/k/e99b99/32.png) [@karolld](https://forum.inductiveautomation.com/u/karolld)\
**Post date:** [October 22, 2019, 4:49pm UTC](https://forum.inductiveautomation.com/t/dropdown-autocomplete/29292/1 "2019-10-22T16:49:38Z")

</div>

Is there a way to implement dropdown autocomplete or search functionality within the vision module? I see this feature has been added to perspective modules (Example 2) [https://docs.inductiveautomation.com/display/DOC80/Perspective+-+Dropdown](https://docs.inductiveautomation.com/display/DOC80/Perspective+-+Dropdown)

---

<div class="post-metadata">

**Author:** ![botto.gabriele](https://avatars.discourse-cdn.com/v4/letter/b/9dc877/32.png) [@botto.gabriele](https://forum.inductiveautomation.com/u/botto.gabriele)\
**Post date:** [March 11, 2020, 8:22am UTC](https://forum.inductiveautomation.com/t/dropdown-autocomplete/29292/2 "2020-03-11T08:22:53Z")

</div>

In my application I’m looking to solve the same problem. Have you find some solutions? Thanks

---

<div class="post-metadata">

**Author:** ![bkarabinchak.psi](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/bkarabinchak.psi/32/83567_2.png) [@bkarabinchak.psi](https://forum.inductiveautomation.com/u/bkarabinchak.psi)\
**Post date:** [March 11, 2020, 12:37pm UTC](https://forum.inductiveautomation.com/t/dropdown-autocomplete/29292/3 "2020-03-11T12:37:29Z")

</div>

I would make a template for this. My first thought would be to have a text field, a button with a down arrow to mimic the drop down button, and a list/table component that’s hidden normally and filled with a SQL query. This SQL query will necessarily need something like `WHERE label LIKE '%{textInput}%'` where {textInput} will be what is typed into the text field.

If the length of the text in the text field is greater than 1, the table/list is visible. Or, if the button is clicked, then the full list is visible. I think a set up like this could work.

But out of the box, no I don’t believe there is a way to do this. You will have to engineer a solution.

---

<div class="post-metadata">

**Author:** ![botto.gabriele](https://avatars.discourse-cdn.com/v4/letter/b/9dc877/32.png) [@botto.gabriele](https://forum.inductiveautomation.com/u/botto.gabriele)\
**Post date:** [March 11, 2020, 3:23pm UTC](https://forum.inductiveautomation.com/t/dropdown-autocomplete/29292/4 "2020-03-11T15:23:00Z")

</div>

Thanks for the advice, now I have solved the problem. I have created a database and entered in a column the strings that must be visualized in the drop down list. Then I have created a texfield component and a dropdown component with a SQL query binding property (in my case SELECT \* FROM {table} WHERE {Column\_name} LIKE ‘%{Root Container.Text Field 1.text}%’ ORDER BY Date DESC;). Now I can read from database, filter the result with the Text Field string (inserted from user) and put it in the dropdown to visualize only the filtered results