This following modification will make the new field that you have added to the osTicket System become searchable in the ticket list page at the staff-side. Assuming the new field name is applications. You can read my modification regarding how to add new or extra fields by reading this article: How to Add Extra Fields on the Open Ticket Form of Client Side in osTicket v1.6 RC5.
Open your \include\staff\tickets.inc.php file, and find this code:
145 146 147 148 149 150 151 152 | $qwhere.=" AND ( ticket.email LIKE '%$queryterm%'". " OR ticket.name LIKE '%$queryterm%'". " OR ticket.subject LIKE '%$queryterm%'". " OR message.message LIKE '%$queryterm%'". " OR response.response LIKE '%$queryterm%'". " OR note.note LIKE '%$queryterm%'". " OR note.title LIKE '%$queryterm%'". ' ) '; |
then replace with this following code:
145 146 147 148 149 150 151 152 153 | $qwhere.=" AND ( ticket.email LIKE '%$queryterm%'". " OR ticket.name LIKE '%$queryterm%'". " OR ticket.subject LIKE '%$queryterm%'". " OR message.message LIKE '%$queryterm%'". " OR response.response LIKE '%$queryterm%'". " OR note.note LIKE '%$queryterm%'". " OR note.title LIKE '%$queryterm%'". " OR ticket.applications LIKE '%$queryterm%'". // <-- this is the change ' ) '; |
If you add more than one field, then you have to add the other field the same way you do above. Hope it is helpful.
Recent Comments