Is there a way to capture the SQL query that is ran during an advanced search in v1.9.9? Trying to create a monthly CSV report by help topic, but the results don't provide enough info when I chose to export to csv.
Open this file: /include/staff/tickets.inc.php
Uncomment the "echo $query;" line, run your search. It should be printed in the page.
Should be good mate.
Perfect! Thank you!