Right now I have modified the OS Ticket system to be used as an internal only system for inbound customer service. As such, all tickets are created by internal staff and the Internal Notes are used exclusively to communicate information on these tickets.
What I need is a way to sort tickets on the View Tickets pane via the "updated" column in the ost_ticket table. I have found plenty of advice for the "lastmessage" and "lastresponse" columns, but those will not work as everything is by internal notes.
Anyhow, I've been trying unsuccessfully to implement this for some time, so if anyone has any advice, it would be appreciated.
I have found the getUpdateDate() in the class.ticket.php, but I am not familiar enough with the code in order to use this properly.
Thanks in advance.
EDIT: Figured it out. I'll post a mod on this later, as it is a bit different than the other "most recent activity" mods posted.
EDIT 2: I've finished the testing and posted the code and instructions. They can be found at: (http://www.osticket.com/forums/showthread.php?t=3951)