I combined the department column and the status column mod into one file. I give you guys credit for figuring it out. I have attached tickets.inc.php with both mods done already on 1.9.14.

I really want to also add a column for date created, since the current date column is based on the last response of the ticket. I'm just not sure how to query the created column in the ticket_thread table

Okay, I know I am doing something stupid here but my brain is toast and I have had enough.

I am trying to add a custom list field to my ticket view. I have al ist of all of our locations and I want that to display in the agent view. I added the columns and everything is great except the view shows the index value instead of the friendly name from the list. In OST 1.9.4 it worked fine but in 1.9.14 it shows the ID not the value from the list.

I tried adding a JPOIN statement to fix this but I know I am doing something wrong here. Any help please?

The list id comes back but I want the value or even the extra field value will do here.

Wonder if someone could help, using v1.10 and trying to incorporate two fields. First is a custom field which is populated when the contact has been created. The other field is I want to display the Help Topic associated with the ticket. I am not a programmer in anyway, but will to give it a try if someone can point me in the right direction with examples.

Has anyone successfully added a column in 1.10 yet? The code was changed so much with the addition of the custom sort options that my old mod does not work.

I did basically the same thing as @chiefer above but used 'topic' instead of 'topic_id' and have the same results. My help topic column is showing the topic id number rather than the name (with the exception that its blank rather than displaying 0 for tickets with no assigned help topic). I tried the suggestion from @Kushelbek on page 7 but got a blank column.

I want to do exactly what @rowlandan25 did but with version 1.10. I'm the attached guide he posted clear back when, but the code has changed so much I don't even know where to begin. Following the steps in page 7 of this thread just confuse me more. REally looking for some help.

I would like to add a student ID number to the view. This student ID number is a required custom field in the users contact information. I know how to modify the code to add this as into the table how I don't know how to get this information from the database?

In addition I would also like to modify the search field to that I can also search for this custom student ID number?

I would be very happy if you could help me with the sql query and where to edit it.

. I went at the code on my own with very little coding experience, and I got a working and sortable department column on the open queue.

In /include/staff/tickets.inc.php I modified two sets of code. WARNING this worked great for me so far, but I'm not sure of any future erorrs or implications it might cause down the road. Backup up your db and your tickets.inc.php file. The column is still titled "assigned to" but shows the departments and I'm ok with that and not going to attempt to make it perfect.

Line 327>332 These are responsible for making the column sortable when you click it.

Just FYI, I've been running this modified code live for about a month now and it has worked perfectly. All departments are shown in the "open" tickets queue and it allows me or any agent to sort tickets by department.