I'm fighting with migration from OTRS 2.3 to newest one available right now.
I've already successfully updated database and files and system works.
But my client used on 2.3 customly created views, and i have to somehow move them to new version.
In 2.3 it was pretty easy, but now I've got stuck.
So What I want to achive is Tickets/Queue View to get from this: to something i imagine like this: I know, that If I click on this CustomerID, it will popup screen with information that I need. So basicly What I want to do Is to move this counter(All tickets) somehow from this last screen to AgentTicketQueue View.
Before in 2.3 we were using query like this:
Code: Select all
SELECT a.a_subject,a.id,u.first_name,a.a_body FROM ticket_history h JOIN article a ON h.article_id = a.id JOIN users u on u.id = a.create_by where h.history_type_id =15 AND h.ticket_id = $tkId ORDER BY a.id DESC LIMIT 1
I've found this file:
which i think is proper one, but I'm not able to change it anyhow, since I'm not a perl programmer and it's pretty confusing to me./opt/otrs/Kernel/Modules/AgentTicketQueue.pm
So any change I think kicks whole view, and I only got errors.
So I would like to ask:
How to achive what I want to do, as simple as it's possible.
Or maybe I'm doing something that is already solved by some module/plugin - but I didn't find any and I think I've checked all of them
I Will be very thankfull for any help.