Organize PreMade Reply List on Ticket Page

carlynleigh

I'd like to find a way to organize the drop-down menu of premade replies when the staff is on the ticket reply page. Currently they are listed in order of when each premade reply was created, but with dozens of premade replies it's a mess!

Anyone code geniuses out there know how to alphabetize the list of premade replies on the ticket reply page?

Thanks!

carlynleigh

Figured it out...

in include > staff > viewticket.in.php, change the premade response query from:

<? $sql='SELECT premade_id,title FROM '.KB_PREMADE_TABLE.' WHERE isenabled=1'.' AND (dept_id=0 OR dept_id='.db_input($ticket->getDeptId()).')'; $canned=db_query($sql); if($canned && db_num_rows($canned)) {?>

... to

<? $sql='SELECT premade_id,title FROM '.KB_PREMADE_TABLE.' WHERE isenabled=1'. ' AND (dept_id=0 OR dept_id='.db_input($ticket->getDeptId()).') ORDER BY title';$canned=db_query($sql);if($canned && db_num_rows($canned)) {?>