Home > osTicket > How to Make The New Field Searchable in the Ticket List Page of osTicket v1.6 RC5

How to Make The New Field Searchable in the Ticket List Page of osTicket v1.6 RC5

November 25th, 2009 Masino Sinaga Leave a comment Go to comments

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.

  • Share/Bookmark
125 views Print This Post Print This Post

Categories: osTicket Tags: , , , , ,
  1. No comments yet.
  1. No trackbacks yet.