how can i get data like that table, from database osTicket?
Asked
Active
Viewed 1,325 times
0
-
What does your question have to do with MySQL? Can you show sample input data in the form of a formatted _table_? – Tim Biegeleisen Sep 25 '18 at 06:21
-
yes i need get data with MySQL but i don't have knowledge about osTicket database – tontowi fajar Sep 25 '18 at 06:25
-
...and you expect that we would have this knowledge? – Tim Biegeleisen Sep 25 '18 at 06:26
1 Answers
0
There is a lot of data on the picture. Which of them do you want exactly? I have a few queries for osticket usage stats.
For example: This query retrieves count of opened tickets by date, that have specific helptopic "topicname".
SELECT DATE(ticketTbl.created), count(*)
FROM osticketdb.ost_ticket AS ticketTbl
INNER JOIN osticketdb.ost_help_topic AS topicTbl
ON ticketTbl.topic_id = topicTbl.topic_id
WHERE topicTbl.topic = 'topicname'
GROUP BY DATE(ticketTbl.created);
Miroslav Adamec
- 1,060
- 1
- 15
- 23