RE: [otrs] sort order of the QueueView

I don't understand what you're saying. The ticket age corresponds with the ticket arrival (created) time.
How would you define the arrival time if not the ticket created time?
-----
Jack Doyle, Network+
Systems Operations Specialist
Lewis-Gale Clinic Information Systems
Public key: http://keys.thajack.com/jd_lgc_public.asc
-----Original Message-----
From: amg-1 [mailto:amg-1@reqwireless.com]
Sent: Tuesday, March 29, 2005 9:34 AM
To: User questions and discussions about OTRS.
Subject: Re: [otrs] sort order of the QueueView
No, I actually want the order to be by message arrival time. By ordering by Age, you risk starving new tickets if you're always handling old ones first.
So, the arrival time of the messages in the queue makes sure that those messages get handled first come first served, instead of giving preference to those who opened a ticket a long time ago.
Can this be done?
----- Original Message -----
From: "Jack Doyle"

Hi, The way it sounds to me, 'amg-1' wants to reverse the sort order so that newer tickets are at the top, rather than tickets that have not been worked for a longer period. At this point however I am not able to offer a solution. Graeme Jack Doyle wrote:
I don't understand what you're saying. The ticket age corresponds with the ticket arrival (created) time.
How would you define the arrival time if not the ticket created time?
----- Jack Doyle, Network+ Systems Operations Specialist Lewis-Gale Clinic Information Systems
Public key: http://keys.thajack.com/jd_lgc_public.asc
-----Original Message----- From: amg-1 [mailto:amg-1@reqwireless.com] Sent: Tuesday, March 29, 2005 9:34 AM To: User questions and discussions about OTRS. Subject: Re: [otrs] sort order of the QueueView
No, I actually want the order to be by message arrival time. By ordering by Age, you risk starving new tickets if you're always handling old ones first.
So, the arrival time of the messages in the queue makes sure that those messages get handled first come first served, instead of giving preference to those who opened a ticket a long time ago.
Can this be done?
----- Original Message ----- From: "Jack Doyle"
To: "User questions and discussions about OTRS." Sent: Monday, March 28, 2005 10:52 AM Subject: RE: [otrs] sort order of the QueueView The age is the amount of time since the ticket was created. Is that not what you want? Also, it sorts based on priority, then age. There may be more to it that I'm not aware of.
However, the age seems to me to be the amount of time since the created date/time.
----- Jack Doyle, Network+ Systems Operations Specialist Lewis-Gale Clinic Information Systems
Public key: http://keys.thajack.com/jd_lgc_public.asc
-----Original Message----- From: amg-1 [mailto:amg-1@reqwireless.com] Sent: Monday, March 28, 2005 10:47 AM To: otrs@otrs.org Subject: [otrs] sort order of the QueueView
When I view My Queues, the order of the messages shown is the "Age" of the ticket. I'd like to change the sort order to be the message arrival time, not the time of the creation of the ticket's very first message (which is what I understand to be the "Age" of the ticket).
I've looked through the mailing list archive, and searched the Defaults.pm file, but no success. Is the sort order I'm suggesting possible w/ OTRS?
thanks.
-- Alain M. Gaudrault, Reqwireless Inc. Web: http://www.reqwireless.com/
_______________________________________________ OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs Support oder Consulting für Ihr OTRS System? => http://www.otrs.de/
_______________________________________________ OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs Support oder Consulting für Ihr OTRS System? => http://www.otrs.de/ _______________________________________________ OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs Support oder Consulting für Ihr OTRS System?
-- ============================================================== Graeme Brough graeme.brough@sun.com Internal: x(70) 73428 Worldwide: +44 (0)1506 673428 Sun Remote Support Centre Application Development 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. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

I don't think I was making myself clear. It's not the reverse sort order
that I want. In fact, I don't want the messages in my queue to be sorted by
ticket age at all. I want the messages to be sorted by timestamp on the
messages themselves, not by the time/date the original ticket for each
message was created. Essentially, I want the messages sorted just like they
would be in a regular email client that knows nothing about mail threads.
As I said, if you always deal with the messages at the top of the queue
using the current sort order, you risk only dealing with open tickets and
never addressing new tickets which always appear at the end. Imagine a
scenario where a customer with a longstanding open ticket sends a reply,
which appears at the top of the queue because the ticket is older than any
other one. You reply to the message, and a couple minutes later, the
customer sends another reply, which again shows up at the top of the queue
because it belongs to such a longstanding ticket. Multiply this scenario,
and it soon becomes difficult to tell whether you're simply replying to the
same people all day, or whether everyone gets an even share of your time.
That's why I want the messages sorted by the time they arrived into the
queue, not by the time the tickets they belong to were created.
Does this make more sense?
I'm a programmer, I know PERL, perhaps this is something I can do given some
guidance? Of course, I'd much prefer hearing that there's an easy way to
change the sort order to be like a standard email client.
thanks.
----- Original Message -----
From: "Graeme Brough"
I don't understand what you're saying. The ticket age corresponds with the ticket arrival (created) time.
How would you define the arrival time if not the ticket created time?
----- Jack Doyle, Network+ Systems Operations Specialist Lewis-Gale Clinic Information Systems
Public key: http://keys.thajack.com/jd_lgc_public.asc
-----Original Message----- From: amg-1 [mailto:amg-1@reqwireless.com] Sent: Tuesday, March 29, 2005 9:34 AM To: User questions and discussions about OTRS. Subject: Re: [otrs] sort order of the QueueView
No, I actually want the order to be by message arrival time. By ordering by Age, you risk starving new tickets if you're always handling old ones first.
So, the arrival time of the messages in the queue makes sure that those messages get handled first come first served, instead of giving preference to those who opened a ticket a long time ago.
Can this be done?
----- Original Message ----- From: "Jack Doyle"
To: "User questions and discussions about OTRS." Sent: Monday, March 28, 2005 10:52 AM Subject: RE: [otrs] sort order of the QueueView The age is the amount of time since the ticket was created. Is that not what you want? Also, it sorts based on priority, then age. There may be more to it that I'm not aware of.
However, the age seems to me to be the amount of time since the created date/time.
----- Jack Doyle, Network+ Systems Operations Specialist Lewis-Gale Clinic Information Systems
Public key: http://keys.thajack.com/jd_lgc_public.asc
-----Original Message----- From: amg-1 [mailto:amg-1@reqwireless.com] Sent: Monday, March 28, 2005 10:47 AM To: otrs@otrs.org Subject: [otrs] sort order of the QueueView
When I view My Queues, the order of the messages shown is the "Age" of the ticket. I'd like to change the sort order to be the message arrival time, not the time of the creation of the ticket's very first message (which is what I understand to be the "Age" of the ticket).
I've looked through the mailing list archive, and searched the Defaults.pm file, but no success. Is the sort order I'm suggesting possible w/ OTRS?
thanks.
-- Alain M. Gaudrault, Reqwireless Inc. Web: http://www.reqwireless.com/
_______________________________________________ OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs Support oder Consulting für Ihr OTRS System? => http://www.otrs.de/
_______________________________________________ OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs Support oder Consulting für Ihr OTRS System? => http://www.otrs.de/ _______________________________________________ OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs Support oder Consulting für Ihr OTRS System?
-- ============================================================== Graeme Brough graeme.brough@sun.com Internal: x(70) 73428 Worldwide: +44 (0)1506 673428 Sun Remote Support Centre Application Development 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. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Ummm... that's a bit complicated, but sounds absolutely logical. Two workarounds come to my mind: 1- Don't allow follow-up's: every new mail received will create a new ticket, even if it has a TicketID in it's subject, etc. I don't like this one because you'll loose the relationship between mails (exactly as with a generic mail client). If the new mail received doesn't include the complete text of the thread you'll have to search each TickedID you could find and stablish the relationship between them manually... seems way too much work to me, but if you seldom receive follow-up's could be an option. This can be setup in the admin interface in a per queue basis. 2- Play with Priorities. As OTRS puts Tickets with higher priority first, if you reduce the priority of a ticket with follow-up's, it will appear below in the QueueView. If a client keeps replying to a longstanding ticket, won't be attended until all new tickets are replied. Read "new tickets" as "not a follow-up, not related to a longstanding ticket". For example, if your default priority is "normal (3)" and you change the priority of all tickets with follow-ups to "low (2)", when you receive new mail, all those new tickets will show above all your longstanding tickets, even if they are older. Obviously, for a given priority, Age will be used to order tickets. But you have 5 priorities ;-) The ideal way to manage this would be having some kind of cron job that changes priorities automatically if priority == "Normal" and "has follow-up's" = true. Even you could create a new ticket state (like "replied"), that is asigned automatically when you reply to a mail ticket, and then have the cron job to change the priority if piority == "Normal" and state == "replied". Maybe GenericAgent can do something like this, but I don't know as I haven't messed with it yet (http://doc.otrs.org/1.3/en/html/generic-agent.html). If you manage to do this using option 2 and that "cron job" I would be glad to hear how you did it :) Good luck! On 29 Mar 2005 at 10:53, amg-1 wrote:
I don't think I was making myself clear. It's not the reverse sort order that I want. In fact, I don't want the messages in my queue to be sorted by ticket age at all. I want the messages to be sorted by timestamp on the messages themselves, not by the time/date the original ticket for each message was created. Essentially, I want the messages sorted just like they would be in a regular email client that knows nothing about mail threads.
As I said, if you always deal with the messages at the top of the queue using the current sort order, you risk only dealing with open tickets and never addressing new tickets which always appear at the end. Imagine a scenario where a customer with a longstanding open ticket sends a reply, which appears at the top of the queue because the ticket is older than any other one. You reply to the message, and a couple minutes later, the customer sends another reply, which again shows up at the top of the queue because it belongs to such a longstanding ticket. Multiply this scenario, and it soon becomes difficult to tell whether you're simply replying to the same people all day, or whether everyone gets an even share of your time. That's why I want the messages sorted by the time they arrived into the queue, not by the time the tickets they belong to were created.
Does this make more sense?
I'm a programmer, I know PERL, perhaps this is something I can do given some guidance? Of course, I'd much prefer hearing that there's an easy way to change the sort order to be like a standard email client.
thanks.
--- Victor R. Rodriguez Departamento de Sistemas Valoraciones del Mediterraneo, S.A. ---

Hello!! There's an option you can use in Config.pm: # AgentQueueSortDefault # (default sort order of the queue view / after priority sort) # ASC: oldest on top, default # DESC: youngest on top $Self->{AgentQueueSortDefault} = 'DESC'; This way the last received ticket will show first, but if the ticket volume received is greater than the amount of ticket answered, some tickets wont be seen, as there will probably be newer ones that to be shown first. If you must keep an SLA based on answer time, the order must be 'ASC' (default). Reading the thread again, I understand that you're accepting follow-up's and you want to have the first ticket received OR the one that has received a follow-up first in your QueueView. Why do you need this ordering option? Maybe there's another way of doing what you need to do ;) I think that you'll face the problem exposed before sooner or later. Regards, On 29 Mar 2005 at 9:36, Jack Doyle wrote:
I don't understand what you're saying. The ticket age corresponds with the ticket arrival (created) time.
How would you define the arrival time if not the ticket created time?
----- Jack Doyle, Network+ Systems Operations Specialist Lewis-Gale Clinic Information Systems
Public key: http://keys.thajack.com/jd_lgc_public.asc
-----Original Message----- From: amg-1 [mailto:amg-1@reqwireless.com] Sent: Tuesday, March 29, 2005 9:34 AM To: User questions and discussions about OTRS. Subject: Re: [otrs] sort order of the QueueView
No, I actually want the order to be by message arrival time. By ordering by Age, you risk starving new tickets if you're always handling old ones first.
So, the arrival time of the messages in the queue makes sure that those messages get handled first come first served, instead of giving preference to those who opened a ticket a long time ago.
Can this be done?
----- Original Message ----- From: "Jack Doyle"
To: "User questions and discussions about OTRS." Sent: Monday, March 28, 2005 10:52 AM Subject: RE: [otrs] sort order of the QueueView The age is the amount of time since the ticket was created. Is that not what you want? Also, it sorts based on priority, then age. There may be more to it that I'm not aware of.
However, the age seems to me to be the amount of time since the created date/time.
----- Jack Doyle, Network+ Systems Operations Specialist Lewis-Gale Clinic Information Systems
Public key: http://keys.thajack.com/jd_lgc_public.asc
-----Original Message----- From: amg-1 [mailto:amg-1@reqwireless.com] Sent: Monday, March 28, 2005 10:47 AM To: otrs@otrs.org Subject: [otrs] sort order of the QueueView
When I view My Queues, the order of the messages shown is the "Age" of the ticket. I'd like to change the sort order to be the message arrival time, not the time of the creation of the ticket's very first message (which is what I understand to be the "Age" of the ticket).
I've looked through the mailing list archive, and searched the Defaults.pm file, but no success. Is the sort order I'm suggesting possible w/ OTRS?
thanks.
-- Alain M. Gaudrault, Reqwireless Inc. Web: http://www.reqwireless.com/
--- Victor R. Rodriguez Departamento de Sistemas Valoraciones del Mediterraneo, S.A. ---

There's an option you can use in Config.pm:
# AgentQueueSortDefault # (default sort order of the queue view / after priority sort) # ASC: oldest on top, default # DESC: youngest on top $Self->{AgentQueueSortDefault} = 'DESC';
Found this already, but it simply reverses the existing order, not at all what I'm looking for. Jack Doyle expressed succinctly what I'm after, which to me seems like a very straightforward way to order messages. Any idea how this might be achieved? Anybody else interested in this type of message queue sorting?
Why do you need this ordering option? Maybe there's another way of doing what you need to do ;) I think that you'll face the problem exposed before sooner or later.
I need this ordering option to prevent the starvation scenario I described previously. I want to make sure that I don't end up spending more time on certain tickets just because they were opened a long time ago. Alain.
participants (4)
-
amg-1
-
Graeme Brough
-
Jack Doyle
-
Victor Rodriguez Cortes