/build/static/layout/Breadcrumb_cap_w.png

Ticket sorting seems to be random

Hi all

Another Question:
In the Ticket overview over all Tickets (All Queues -> All Tickets)-

I want to sort for Status and it just makes an completely random List with nearly nothing sorted together.
For example: 

[Status (arrow down)]
Closed
Closed
New
Open
Closed
Closed
Open
Open
Open

(imagine this as the Status collum)

Why doesn't it just order alphabetically? Is there a way to fix it? 

There's no use in sorting like that. Same happens to custom fields (User) and Category (which is 100, 101, etc. in our company)

Thanks

az 


0 Comments   [ + ] Show comments

Answers (2)

Answer Summary:
Posted by: chucksteel 10 years ago
Red Belt
2

I think that it might be sorting by Status ID instead of Status name, but I'm not positive. I would consider submitting this to support as a possible bug.

 


Comments:
  • I thought of that too. But wouldn't it work like that as well? I mean New and New have the same ID.. Well maybe someone magically shows up with a solution. Otherwise I'll submitting it to support as you suggested. Thanks for the fast answer! - aazimm 10 years ago
    • Actually, New and New won't have the same ID. If you look in the HD_STATUS table you can see that each status is unique to its queue. This allows you to change the name of a status in one queue without affecting others. - chucksteel 10 years ago
  • well, sorry seems like I got the wrong Info.. sorry and thanks for your help - aazimm 10 years ago
Posted by: jdornan 10 years ago
Red Belt
1

Please provide a screenshot and version number of your Kace unit. I hav etested on my systems and it works as Chuck described Sorts by status ordinal (different for each queue).

 

The sort shows in the status bar when clicking Status as

BY_STATE_TICKETS=all
ORDER[]=STATUS_ORDINAL <----
ORDER[]=PRIORITY_NUMBER
ORDER[]=SORT_OWNER_NAME
ORDER[]=TITLE


Comments:
  • I didn't think to look in the URL. FYI, changing STATUS_ORDINAL to STATUS_NAME does work and tickets are grouped by status first (so tickets from different queues with the same status are together). If you're using the adminui you can then bookmark that URL. - chucksteel 10 years ago
    • How do I change the Status_Ordinal to Status_Name? Thanks - mrepetti 9 years ago

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

Share

 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ