Project

General

Profile

Activities report

Added by Dali Amaya about 10 years ago

Hi,
I started working with redmine recently and I need to generate a query that brings me all user activities ordered by ticket and date, which includes user notes, the hours reported and the date, something like this:

User Ticket Activity Notes Hours Date
1 25 40 CuackCuak 5 2014/01/01
1 24 39 Blabla 3 2014/01/08
2 25 28 notes 1 2014/01/04
2 23 21 Something 4 2014/01/05
2 21 20 more notes 1 2014/01/03

I´ve tried with diferentes querys(Some I have found in forums) but I can´t get this result, Ihope someone can help me, thanks.