
I'm thinking about using OTRS for a client's site. One of the features I absolutely need is the ability to sort all of my tickets into the exact order I want. I know a lot of systems only allow you to specify a few priority levels and then sort tickets by those levels. Is the kind of custom sorting I'm looking for possible with OTRS? -- sarah adams web developer & programmer portfolio: http://sarah.designshift.com blog: http://hardedge.ca

This is an interesting question to me (sorry, no complete answer) because, as far as I can tell, you can sort up/down by any column/field in search results, but not in Queue View. I find that limitation inconvenient, and would be happy to know of a way to sort in Queue View. -tom
On Fri, 10 Feb 2006 17:37:43 -0400, otrs.sarahwbs@xoxy.net said:
> I'm thinking about using OTRS for a client's site. One of the features I > absolutely need is the ability to sort all of my tickets into the exact > order I want. I know a lot of systems only allow you to specify a few > priority levels and then sort tickets by those levels. Is the kind of > custom sorting I'm looking for possible with OTRS? > -- > sarah adams > web developer & programmer > portfolio: http://sarah.designshift.com > blog: http://hardedge.ca -- Thomas L. Baca thomas.baca@nau.edu Manager, Information Technology (928) 523-2088 College of Engineering and Natural Sciences Northern Arizona University

Hello, We wanted to order tickets initially by priority, then by 'New' tickets, then by 'In Progress' with most recently worked 'In Progress' ticket last (i.e. sort based on the timestamp of the latest article on a given ticket) etc. To achieve this we amended the Kernel/Config.pm by adding: $Self->{DefaultQueueSortOrder} = 'st.ticket_priority_id DESC, ts.name = "New" DESC, ts.name like "In%" DESC, ts.name like "Awaiting%" DESC, ts.name like "Pend%" DESC, st.until_time ASC, st.change_time ASC'; If you want to sort by status, you MUST ensure that the values you define for 'ts.name' are valid statuses for your installation (we created a number of new ones), otherwise sorting by priority, timestamp, etc. is straightforward. You may also need to experiment will the ASC/DESC to get the required order, but I'm sure this will provide the resolution you are looking for. Regards, Graeme otrs.sarahwbs@xoxy.net wrote:
I'm thinking about using OTRS for a client's site. One of the features I absolutely need is the ability to sort all of my tickets into the exact order I want. I know a lot of systems only allow you to specify a few priority levels and then sort tickets by those levels. Is the kind of custom sorting I'm looking for possible with OTRS?
-- ============================================================== Graeme Brough rsc-uc@sun.com Customer Account Management Support Team Internal: x(70) 73488 Worldwide: +44 (0)1506 673488 Sun Remote Support Centre Linlithgow, UK ============================================================== ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ NOTICE: This email message is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
participants (3)
-
Graeme Brough
-
otrs.sarahwbs@xoxy.net
-
Thomas L. Baca