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
[email protected]
http://lists.fossil-scm.org:8080/cgi-bin/mailman/listinfo/fossil-users
