Hi
How can I build a query on the number of open and closed cards during a month, day, or the like???
number of open and closed cards during a month
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:
Cheers.
KevinTheJedi
Thank you
im sad
KevinTheJedi
Please help me a little
KevinTheJedi Sorry but I didn't understand
- Edited
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