Modify the Date search option

[lupolo]

Script URL:
Version of script: 2.2
Hosting company:
URL of phpinfo.php:
URL of session_test.php:
What terms did you try when SEARCHING for a solution:

Write your message below:

How to modify the ticket date search to ONLY show the tickets closed on that day?

[Klemen]

In admin/find_tickets.php try changing

Code: Select all

(`dt` LIKE '".hesk_dbEscape($date)."%' OR `lastchange` LIKE '".hesk_dbEscape($date)."%')

to

Code: Select all

`status` = '3' AND `lastchange` LIKE '".hesk_dbEscape($date)."%'

[lupolo]

This fix also show's the Start date of a ticket, and i wanna see only the closed date of a ticket

[Klemen]

Did you remove the entire code I posted (the "dt LIKE" part)?

Note that the time ticket is closed is not stored in a dedicated database column so using the lastchange column is the best and closest alternative.