I'm implementing a "Changed Tickets" report similar to that in Fossil's ticket system, the main difference is I want to show who made the change. I do this by joining ticket and ticketchg
SELECT DISTINCT date(ticket.tkt_mtime), substr(tkt_uuid,1,10) AS '#', status, login, title FROM ticket LEFT OUTER JOIN ticketchng ON ticket.tkt_id = ticketchng.tkt_id ORDER BY ticket.tkt_mtime desc I'd like to do is show the status value for the particular ticket change (rather than the current value) so the report would return something like: Date Status Modified Title 2013-01-12 Closed Dick 2013-01-12 Tested Dick Some task 2013-01-11 Done Harry Some task 2013-01-10 Started Harry Some task 2013-01-10 Open Dick Some task 2013-01-09 New Tom Some task In this example, assume Tom is an end user, Dick is the tester and Harry is the developer. The above example returned Status Closed for all rows. Can anyone think of a convenient way to achieve the above report? Thanks Steve _______________________________________________ fossil-users mailing list fossil-users@lists.fossil-scm.org http://lists.fossil-scm.org:8080/cgi-bin/mailman/listinfo/fossil-users