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

Sort Ticket by Due Date on Staff Panel

Hello,
Is it possible to sort tickets by Due Date on Staff Panel ?

Thank You

Comments

  • Hi, 

    At the moment, no we do not currently support sorting by due date. However, you may sort tickets by priority. The priority level settings for tickets will depend on It is in our development road map to add custom columns to the ticket queues.

  • Hello,

    On Staff Window displaying list of tickets (as you can see on the attachment), is it possible to add more column ? Our Staff will love to view Due Dates on this window

    Thank you
  • There is no way to do that using the ui currently.

    However if you know PHP you can modify the source of the project to do it.  Please see this thread:
    http://www.osticket.com/forum/discussion/75457/a-better-ticket-list#latest

    note: yes it was started for an older version but it does cover up through 1.8.1.2 iirc)
  • Hi Ntozier,
    The link you provided is very interesting but it is for a complete new list and variables.
    It looks like my problem could only be resolved by doing the right things in this folder 
    Includes -> Staff -> tickets.inc.php
    the Variable that i need to manipulate seems to be " duedate"
    but not sure yet of what to do exactly

  • bcvbcv
    edited June 2014
    I'm using v1.9.1 and here's what I did (but sorting by due date column doesn't work though):

    include/staff/tickets.inc.php

    line 149 - add to array:
    'due_date'=>'ticket.duedate'

    line 326 - change sort variable:
    <a  <?php echo $date_sort; ?> href="tickets.php?sort=due_date&order=<?php echo $negorder; ?><?php echo $qstr; ?>"
    title="Sort By Date <?php echo $negorder; ?>">Due Date</a></th>

    line 414:
    <td align="center" nowrap><?php echo Format::db_datetime($row['duedate']); ?></td>

    If you figure out the fix for the sorting issue, please let me know thanks.

  • Thank you BCV,

    I will let you know, otherwise i will just hope the future versions of osticket accommodate this option.

    Thx again

  • Hello BCV

    Here is a copy of my ticket.inc file,
    As you can see on attachments, i was able to display Due Dates which is already very good but, the liitle arrow for sorting the new column is not working. any idea on how i can have it to sort duedate ?

    Thank you
    Duedate03.pdf
    93K
    tickets.pdf
    106K
  • Tried on my version of 


     osTicket (v1.9.3)


    Not working :-(
  • Hello All

    Is it possible to sort tickets based on Due Date on the 1.9.8.1 version ?

    thanks
  • Yes.I have it on the latest version
    See my code in this link

    http://osticket.com/forum/discussion/comment/94976/
  • Thanks Yisrael

    Let me give it a try and let you know
  • It worked !

    thanks again Yisrael !
  • My pleasure
Sign In or Register to comment.