Forums » Help »
users activity report from my scripts to the database (need to know from where I can get the info)
Added by arrrrgv arrrrgv over 12 years ago
Hello,
I am trying to catch from my script querying directely to my redmine database all the on issue information related with the issues activity.
In fact what I to know is per each ticket which users has interacted, as an interaction I mean:
ticket creation, ticket update, if it has been assigned to the user at any time, ticket resolution.
i'm trying to figureout so looking at the database schema, but I don't see where the activity related with the user and tickets is stored, i can see the actual status in relation with the users (owner, creator, etc...) but nothing like a kind of history.
Could you help me up and let in which tables and fields should i look?
Thank you