# Dropdown Window Order, Ignition Platform 7.9.10

**URL:** <https://forum.inductiveautomation.com/t/dropdown-window-order-ignition-platform-7-9-10/41267>\
**Category:** General Discussion\
**Created:** [December 7, 2020, 4:58pm UTC](https://forum.inductiveautomation.com/t/dropdown-window-order-ignition-platform-7-9-10/41267 "2020-12-07T16:58:31Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![bob.cappelletti](https://avatars.discourse-cdn.com/v4/letter/b/7c8e57/32.png) [@bob.cappelletti](https://forum.inductiveautomation.com/u/bob.cappelletti)\
**Post date:** [December 7, 2020, 4:58pm UTC](https://forum.inductiveautomation.com/t/dropdown-window-order-ignition-platform-7-9-10/41267/1 "2020-12-07T16:58:31Z")

</div>

I have a dropdown window that is accessing a data base and displaying batch ID numbers. Is there a way to sort the way the dropdown displays the ID, such as sorting the list starting with the current date then alpha numeric?  
 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/5/3/53aa723d0803f7b666508a39067dfcc3eab0c614.png)

---

<div class="post-metadata">

**Author:** ![Matrix\_Engineering](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/matrix_engineering/32/19781_2.png) [@Matrix\_Engineering](https://forum.inductiveautomation.com/u/Matrix_Engineering)\
**Post date:** [December 7, 2020, 5:32pm UTC](https://forum.inductiveautomation.com/t/dropdown-window-order-ignition-platform-7-9-10/41267/2 "2020-12-07T17:32:14Z")

</div>

Have you tried at the end of your SQL query that generates the list items:

```auto
Order by current_date desc, listItems desc

```

change your order by items per your column names  
?

---

<div class="post-metadata">

**Author:** ![bob.cappelletti](https://avatars.discourse-cdn.com/v4/letter/b/7c8e57/32.png) [@bob.cappelletti](https://forum.inductiveautomation.com/u/bob.cappelletti)\
**Post date:** [December 7, 2020, 8:11pm UTC](https://forum.inductiveautomation.com/t/dropdown-window-order-ignition-platform-7-9-10/41267/3 "2020-12-07T20:11:38Z")

</div>

I ended up doing this and it worked, thank you!

SELECT DISTINCT Fiber\_Press\_Batch\_ID  
FROM B9\_Fiber\_Press  
ORDER BY Fiber\_Press\_Batch\_ID DESC;