
Hi, I search a more convenient way to see all locked tickets. At the moment we use a search template to show all open tickets, then we change to the small view and then we sort by lock status. But unfortunately one can't use the lock state as a search criterion. Workflow : - 1 queue <-> n agents - on average < 30 tickets - on average < 10 locked tickets Situation 1 : We get a user call and want to know if the problem was already reported by another user. (Later we would solve this by assigning tickets to a unique service or device id.) Situation 2 : We want to see how much tickets each agent has locked to balance the work. Can someone give a hint how to extend the search mask or how to create a appropriate search template ? Or has someone even achieved to create a virtual queue or something like this which consists of all locked tickets. I'm sorry, this exceeds my little perl and SQL knowledge so I can't solve this problem by myself at the moment. Regards Alexander Halle -- radprax Gesellschaft fuer medizinische Versorgungszentren mbH, Bergstr. 7 - 9, 42105 Wuppertal, Fon: +49 202 2489 1110, Fax: +49 202 2489 94 1119 Geschaeftsfuehrer: Andreas Martin, Dr. med. Heiner Steffens, Dr. med. Renate Tewaag Amtsgericht Wuppertal: HRB 19359, St.-Nr.: 5132/5889/0264, DE 814559152 Web: http://www.radprax.de

I wrote:
I search a more convenient way to see all locked tickets.
I discovered the StatusView feature which is a bit more convenient. But if anyone has a hint how to search only for locked, open tickets I would be glad. Any SQL statement, URL parameter or dtl modification I could build on ? Regards Alexander Halle -- radprax Gesellschaft fuer medizinische Versorgungszentren mbH, Bergstr. 7 - 9, 42105 Wuppertal, Fon: +49 202 2489 1110, Fax: +49 202 2489 94 1119 Geschaeftsfuehrer: Andreas Martin, Dr. med. Heiner Steffens, Dr. med. Renate Tewaag Amtsgericht Wuppertal: HRB 19359, St.-Nr.: 5132/5889/0264, DE 814559152 Web: http://www.radprax.de

HI, On 09.09.2009, at 18:51, Alexander Halle wrote:
I wrote:
I search a more convenient way to see all locked tickets.
I discovered the StatusView feature which is a bit more convenient.
But if anyone has a hint how to search only for locked, open tickets I would be glad. Any SQL statement, URL parameter or dtl modification I could build on ?
Why not a saved search. Then you can activate the search panel in the navigation bar. -- Shawn Beasley shawn@otrs.org Computers make work that one would not have without them go faster!

Shawn Beasley wrote:
But if anyone has a hint how to search only for locked, open tickets I would be glad. Any SQL statement, URL parameter or dtl modification I could build on ?
Why not a saved search. Then you can activate the search panel in the navigation bar.
Hi, because I found no search field for lock in AgentTicketSearch (OTRS 2.4.4) :( At the moment I use a saved search to show all open tickets, then sort by lock and ignore the unwanted search results (open, but unlocked tickets). Regards Alexander Halle -- radprax Gesellschaft fuer medizinische Versorgungszentren mbH, Bergstr. 7 - 9, 42105 Wuppertal, Fon: +49 202 2489 1110, Fax: +49 202 2489 94 1119 Geschaeftsfuehrer: Andreas Martin, Dr. med. Heiner Steffens, Dr. med. Renate Tewaag Amtsgericht Wuppertal: HRB 19359, St.-Nr.: 5132/5889/0264, DE 814559152 Web: http://www.radprax.de
participants (2)
-
Alexander Halle
-
Shawn Beasley