Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

In this Discussion

osTicket v1.10 (stable) and Maintenance Release v1.9.15 are now available! Go get it now

limit searches

Hello,

Our database/server is choking whenever searching all tickets (open/closed/etc). I believe it's because we have too many closed tickets, and so each search takes too long.

Would it be possible to modify code somewhere so we can limit a search to 1 year or 6 months back rather than searching ALL tickets, open and closed?

Comments

  • Hello, could add an additional attribute to which you already have, in class.ticket.php file found in the include folder, look at line 60 or so, or where get the variable $sql and end of the sentence add a date attribute, you selecione from the dates you want to the other.

    I leave a link so you can see how to use the Between.

    http://www.w3schools.com/sql/sql_between.asp
Sign In or Register to comment.