Custom SQL query for Activity possible?
Added by Night Monkey over 14 years ago
Hello. I'm a Redmine user, who uses Redmine primarily for ticketing IT issues. I have multiple clients, each organized as a "project", and we have multiple Redmine users who create and update tickets. What I'd like to do is create a text dump of project activity, and select all activity between certain dates, and ticket activities by Redmine user. Is there an API or DB schema map that would allow SQL queries to gather this information in an automated fashion, either from the shell (on Linux), or from within Redmine itself?
To be clear, this is the kind of question I'd like to answer with SQL:
Show me all tickets created or updated for "Acme Incorporated", from "10/14/2009" and "10/28/2009", inclusive, which were touched by "Joe The IT Guy".
Please forgive me if this has been asked and answered before, but I did search the forums, and documentation, and even tried to sift through the source tree (0.8.7 - stable) to see if there was an obvious answer. Thanks in advance, and thanks for Redmine!
Cheers!