Activities report 
Added by Dali Amaya over 11 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.