Sorting job entry search by job doesn't search in

Sorting job entry search by job doesn't search in numerical order.

We recently went from job number 99999 to 100000 and now when we search by job number in job entry it puts the 100000 job numbers ahead of the numbers that start with 9, rather than putting them in numerical order. We can search by order date, but then the jobs with component jobs are all jumbled and not in any order.

DAWN BACK
Aug 25 2020
Future Consideration

Attach files

Enter a subject

Christine Dills commented

October 06, 2022 16:07

We are finding this to be a problem in quotes.

×
Attachments Open full size
Amanda Bergstedt commented

April 27, 2022 21:19

We just came across the same issue. Just hit 100,000 and all of our new jobs are at the bottom!

×
Attachments Open full size
Jason Thomas commented

March 09, 2022 16:35

Jobs can have letters in them so this is an alpha-numeric field. They sort they implemented is a basic alpha-numeric search. They would have to improve their sort function to handle this correctly. It is also the case in many other fields in jobboss.

×
Attachments Open full size