Hi guys
I need some help with a small mod to my tickets.inc.php
I have created a new priority called "Deferred"
basically this is to be used as a flag for tickets that are awaiting feedback etc but are being worked on by either the staff member or information is being waited on from the customer.
We have a number of tickets that fall into this category and dont want them clogging up the "open" tickets page even though they are still open
I am trying to find the php / mysql code that searches for everything marked as open to display on the Open Tab to change it to something like
Select * where Status = open and prioity not = "deferred"
so that the tiuckets displayed on the "Open" tab will not display deferred tickets
any suggestions help please?