Hi,
I wish to export a csv of monthly completed tickets along with hyperlinks to them. Is there anyway to do that?
Thank you.
Hi,
I wish to export a csv of monthly completed tickets along with hyperlinks to them. Is there anyway to do that?
Thank you.
This is not a feature in osTicket at this time.
You could probably write a script to query the information from the database though.
Ah, that's a shame. I'm not too great with writing scripts, can you give me a hint on where to start?
Thank you very much
That would really depend on how much information (data points) you are looking to extract.
The more you want to pull out the more complex it will be.
a mysql Query like
select ticket_id,number FROM
ost_ticketWHERE created BETWEEN '2022-01-01' AND '2022-01-31'
would get you a list of all ticket_id's and their ticket numbers created between the dates.
Then you can loop through the results and output it.
You would build the url to the ticket like this
YOURDOMAIN.TLD/scp/tickets.php?id=ticket_id
Then you could use html to link the url.
<a href=http://YOURDOMAIN.TLD/scp/tickets.php?id=ticket_id>number</a>
If you want to do more than that you would need to look at the database ERDs to make the query more complex.
https://docs.osticket.com/en/latest/_static/images/erd_Tickets.pdf