Dropdown Window Order, Ignition Platform 7.9.10

General Discussion
1

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

2

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
3

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;