Dear Friend/s,
I want to know how many tickets I received monthly in the ticketing. Can anyone share information on how I will be able to do that in the ticketing? Thank you!
You could run a SQL query similar to
SELECT count(ticket_id) FROM ost_ticekt WHERE created BETWEEN DATE1 AND DATE2;
Where DATE1 and DATE2 are two dates that you want to check.
Thank you. Sorry for this question, but how I will run an SQL within the ticketing? I don't know how to do it yet (I'm new in this ticketing world so I am still figuring things out). Thank you for your understanding and patience.
YeN You need to run command @ntozier above in the MySQL server
Connect to your MySQL server: mysql -h host -u user -p Enter password: ********
If you don't know name of database you can run: SHOW DATABASES;
Then select the database: USE NameOfosTicketDatabase;
4 Then run the commands: SELECT count(ticket_id) FROM ost_ticekt WHERE created BETWEEN DATE1 AND DATE2;
here is how to tutorial link: https://dev.mysql.com/doc/mysql-tutorial-excerpt/8.0/en/
