Showing tickets on closed data

rockz0r

Hi Guy's,

We are gonna use the osticket system and i have a question:

When we open a ticket and close it afterwards, there will be a create date and close date, which we can see after we press on the ticket id.

blank

We want to see how many tickets get closed for a total of period day/week/month, to show the manager how many tickets we closed, so we go to the closed tickets and sort them by date. However; this date is not the closed date but the creation date :(

blank

Does anyone knows a solution to solve this problem? Thanks in advance.

Leigh

We're also very interested in a solution to this problem.

Thanks!

dohcjs

Try this

modify this code

if($startTime){

$qwhere.=' AND ticket.duedate>=FROM_UNIXTIME('.$startTime.')';

$qstr.='&startDate='.urlencode($params);

}if($endTime){
$qwhere.=' AND ticket.duedate<=FROM_UNIXTIME('.$endTime.')';
$qstr.='&endDate='.urlencode($params);
}

from tickets.inc.php

to this

if($startTime){

$qwhere.=' AND ticket.'.($status=='closed'?'closed':'duedate').'>=FROM_UNIXTIME('.$startTime.')';

$qstr.='&startDate='.urlencode($params);

}if($endTime){
$qwhere.=' AND ticket.'.($status=='closed'?'closed':'duedate').'<=FROM_UNIXTIME('.$endTime.')';
$qstr.='&endDate='.urlencode($params);
}

Now when you search for closed tickets and include a date, it will filter on the closed date rather than the duedate.