osTicket v1.10 (stable) and Maintenance Release v1.9.15 are now available! Go get it now
Displaying Topic in the open ticket list
I recently upgraded to v1.10 from v1.8.
In the previous version I was able to add additional columns to the man ticket list view.
I was able to add a custom form field for post code, and that I can still do, but is done as a call to a custom PHP which queries the database to extract the relevant info from tables for the given ticket ID. This obviously slows down the page loading, but I can look at tuning later.
Another thing I was able to do fairly easily in the older version was add the topic to the return data and present that in the list.
In the upload/include/staff/tickets.inc.php script, this item was in the SELECT column list:
.' ,IF(ptopic.topic_pid IS NULL, topic.topic, CONCAT_WS(" / ", ptopic.topic, topic.topic)) as helptopic '
So in the loop that prints out each ticket in teh list I simply added:
<td align="center" ><?php echo $row['helptopic']; ?></td>
But, the new version, this is completely esoteric/abstracted, making it extremely difficult to figure out how to re-apply this mod, or go about showing this data (other than doing what I did to show the post code items, but this would really slow it down).
I was also excited to see that custom ticket statuses can be defined, but how to include this in the ticket list?