Dropdown Window Order, Ignition Platform 7.9.10

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?

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

Order by current_date desc, listItems desc

change your order by items per your column names

1 Like

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

FROM B9_Fiber_Press
ORDER BY Fiber_Press_Batch_ID DESC;