Filter by Unassigned

dcbour

Any way to do a quick filter on unassigned tickets. Don't see it. Would be nice.

jpowers40828

Upload the view_unassigned.gif file into your scp/images directory. (For some reason it wouldn't let me upload it as a gif, so i had to add .txt to the end. Make sure you remove that) I wasn't able to get it the same as the other 2, but you can probably do better.

Find the following in include/staff/tickets.inc.php ~ line 41

case 'assigned':

$status='Open';

$staffId=$thisuser->getId();

break;

Add the following after it.

case 'unassigned':

$status='open';

$staffId=0;

break;

Find the following in include/staff/tickets.inc.php ~ line 82

//Staff's assigned tickets.

if($staffId && ($staffId==$thisuser->getId())) {

$results_type='Assigned Tickets';

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

}

Add this after it.

//Unassigned

if($staffId==0 && $_GET=='unassigned') {

$results_type='Unassigned Tickets';

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

}

Then find the following in include/staff/tickets.inc.php ~ line 316

<a href="tickets.php?status=open"> <img src="images/view_open.gif" alt="View Open" border=0></a>

<a href="tickets.php?status=closed"> <img src="images/view_closed.gif" alt="View Closed" border=0></a>

Add the following after it.

<a href="tickets.php?status=unassigned"> <img src="images/view_unassigned.gif" alt="View Unassigned" border=0></a>

[view_unassigned.gif.txt](https://forum.osticket.com/assets/files/migrated/8/5f4d7f13dd01e00fffcca9b2769269f.txt)

vflopez

Help with this code

I am a relatively new osTicket user and I've installed several mods but I can't get this one to work. I put in the code and the image file but nothing happens. The last part does not match the code I have (1.6.0). Do we need and update for this?

caspdk

show count for unassigned

I've implemented the "filter by unassigned" on the latest release, but would like to know how i can show the COUNT next to the Unassigned nav button.

I.e. Unassigned (2) would show on the nav bar if i had two unassigned tickets.

There must be a simple SQL query i have to add, i just don't know much about SQL! Thanks in advance for any help you can offer!

thrustinj

I think this is missing from ~342 to add "Unassigned" to Status in Advanced Search

<option value="unassigned" <?=!strcasecmp($_REQUEST,'Unassigned')?'selected':''?>>Unassigned</option>

thrustinj

Also, this would be better in the Sub-statuses Trust Me section. ~100 or so.

//Sub-statuses Trust me!

if($staffId && ($staffId==$thisuser->getId())) { //Staff's assigned tickets.

$results_type='Assigned Tickets';

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

//Unassigned

<STRONG><s>**</s>}elseif<e>**</e></STRONG>($staffId==0 && $_GET=='unassigned') {

$results_type='Unassigned Tickets';

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

}elseif($showoverdue) { //overdue

$qwhere.=' AND isoverdue=1 ';

}elseif($showanswered) { ////Answered

$qwhere.=' AND isanswered=1 ';

}elseif(!$search && !$cfg->showAnsweredTickets() && !strcasecmp($status,'open')) {

$qwhere.=' AND isanswered=0 ';

}