Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

In this Discussion

osTicket v1.10 (stable) and Maintenance Release v1.9.15 are now available! Go get it now

How to display Department column in ticket list

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

Comments

  • 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.osticket.com/forum/discussion/75457/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.php

    And 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['dept_name'];?>
    </td>
  • Hi Alex, thanks a lot for this modification. I tried it and it worked but I recieved DB Error #1044 every 10 minutes:

    ***
    [SELECT sum( data_length + index_length ) / 1048576 total_size
                FROM information_schema.TABLES WHERE table_schema = 'dxxxxxxx']

    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 @leflores 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
Sign In or Register to comment.