ricoh Posted June 24, 2017 Share Posted June 24, 2017 I am looking for an option from where i can export a list of all closed tickets for a last 30 days. But i am not getting any option in report section. please help me to find this. I have to sumbit this report to my manager as soon as possible. Or suggest me how to generate this customize report. 0 Quote Link to comment Share on other sites More sharing options...
brian! Posted June 27, 2017 Share Posted June 27, 2017 if there isn't a specific built in report that can do, then you could always use a SQL query in phpmyadmin and export the result from that... e.g to get a list of closed tickets for January 2017, you could use this... SELECT * FROM tbltickets WHERE tbltickets.status = 'Closed' AND tbltickets.lastreply BETWEEN '2017-01-01' AND '2017-01-31' if you need more detail than the result supplies (e.g replies), then you'd need to join tables into the query... and for that you might need to post in Service Offers & Requests and pay a developer to write a specific custom query for you (or a WHMCS report to do the same thing). 0 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.