Hi,We just upgrade to 1.8.1 and we found the column "Department" is missing from ticket list.In a setup where operators are assigned to several departments is important to have which department each ticket belong directly in list view.We are missing this feature. How it could be displayed?Thanks
Missing? It was never in that list. If you had it before then you must have modified your version. There is no way to do this via the ui.That being said this thread here talks about adding custom columns:http://www.forum.osticket.com/d/discussion//a-better-ticket-list#latest
I hate to differ, but I also upgraded this week and have noticed that "Department" is no longer a column in the list of tickets. We had not modified the basic installation. I would assume that displaying (or not displaying) columns should be a setting. I will continue to search for a modification or setting. If anyone else finds a solution, please post it.
Now that I think about it... it was removed as a column in 1.7.1 iirc.The thread I already posted has the basics for the mod to add it back (and other things)
It was there the column for Departments. This is a very important information for our staff... if it were removed to make the system faster.... but no... 1.8.1 is SLOWWWWWW, after some years using osticket we are now forced to find alternatives, it is not usable when a search take more than 2-3 minutes.Even changing from one page of the ticket listing to the next one takes soooo looooong.Really dissapoointed :(
1.8.1 is now old, and you should probably upgrade to 1.8.1.2. I have not experienced any slowness issues like you are describing.Perhaps you should be more specific (hard ware specs, os, php/webserver/mysql versions, etc) and report the problem to the devs on github.
Hello leflores,To make the ticket department available on the ticket list, you can just update the file /include/staff/ticket.inc.phpAnd add the following line in it: (In version 1.8.1.2)######## /include/staff/ticket.inc.php ########added 366 to 368 >><th width="280"><a <?php echo $dept_sort; ?> href="tickets.php?sort=dept&order=<?php echo $negorder; ?><?php echo $qstr; ?>" title="Sort By Department <?php echo $negorder; ?>">Department</a></th>added 444 to 446 >><td align="center" class="nohover"><?php echo $row;?></td>
Hi Alex, thanks a lot for this modification. I tried it and it worked but I recieved DB Error #1044 every 10 minutes:***Access denied for user 'dxxxxxxx'@'%' to database 'information_schema'<br /><br />---- Backtrace ----<br />#0 (root)/include/mysqli.php(163): osTicket->logDBError('DB Error #1044', '[SELECT sum( da...')<br />#1 (root)/include/staff/system.inc.php(62): db_query('SELECT sum( dat...')<br />#2 (root)/scp/system.php(23): require('/www/htdocs/w00...')<br />#3 {main}***Could you maybe upload the files or describe more detailed where to place the new code to see if I can get it to work without DB errors.Anyway @[deleted] there is an easy way to get the department column back:Just disable Settings >> Tickets >> Show assigned tickets on open queue. Disabling this option will change "assigned to" column to "departments" column.Best regards, Stefan
