My Tickets showing closed.

rmcgeown

I feel like im spamming the forums at the moment! Sorry!

Our staff My Tickets page shows tickets closed by that staff as well as their open. I want it to only show open.

The ticket stats count is correct though.

I had read that this is standard in 1.6...however I have added the MOD to stop showing closed tickets when there are no open.

Any help is appreciated.

scottro

Taken from my Reports MOD article:

This will still make the ticket show up under "My Tickets" (even when closed) in order to get it to stop doing that (if you desire), then change the following entry

from:

include/staff/tickets.inc.php

$qwhere.=' AND ticket.staff_id='.db_input($staffId);

to:

$qwhere.=' AND ticket.status="open" AND ticket.staff_id='.db_input($staffId);

scottro

And another portion that you'll probably come back for next ;)

You’ll also need to change the following (otherwise it will count that you have tickets assigned but won’t list them thus confusing everyone).

scp/tickets.php

'LEFT JOIN '.TICKET_TABLE.' assigned ON assigned.ticket_id=ticket.ticket_id AND assigned.staff_id='.db_input($thisuser->getId());

To:

'LEFT JOIN '.TICKET_TABLE.' assigned ON assigned.ticket_id=ticket.ticket_id AND ticket.status=\'open\' AND assigned.staff_id='.db_input($thisuser->getId());

rmcgeown

Scottro, once again, thank you! :)

scottro

You bet! :)

tanyad

Staff unable to see any tickets

I tried this solution and now my staff can't see any of the tickets listed.