Hi How can I build a query on the number of open and closed cards during a month, day, or the like???
luningarcia
Run an Advanced Search with the desired criteria and you can view the total count at the bottom of the search queue or in your recent search history.
Cheers.
I mean how do I do that with an command in database osticket_db????
We don’t have any guides on this so you will be on your own in accomplishing this. We have ERDs available here that should help you with the table relations though:
KevinTheJedi Thank you im sad
KevinTheJedi Please help me a little
How about make an advanced search and print the raw SQL query from the ORM.
KevinTheJedi Sorry but I didn't understand
More clearly, I want this information, where it is in the tables in the database, how do I make a query about it
luningarcia Those are not stored anywhere in the database. They are calculated based on thread events. You can see how exactly in include/class.report.php file
include/class.report.php
