query for bubbled up finish date - for use in Time Reports
|Reported by:||jamescook||Owned by:||ChrisNelson|
- i have a number of tasks related by "blocked by" and "blocking".
- tracjsgantt make a great job of displaying them, linked with a red arrow line.
- most of the tasks contain no date - the first has a "Start Date"
- all these tasks are 100% complete - shown as a greyish bar inside the task bar.
All the above is great and as expected.
The tasks are shown from 13 Sept. 2013 onwards.
When I come to do time reporting, these tasks are shown in March 2014 - because that's when I got round to setting the status to closed/fixed. (Developer Work Summary). That's because the report query uses:
AND ticket_change.time >= $STARTDATE
AND ticket_change.time < $ENDDATE
I looked in ticket_custom and other tables in sqlite etc. to find the date tracjsgantt uses, but couldn't find anything (probably calculated on the fly) (?).
What db field or query can I use to have the tasks appear in September 2013 in the "Developer Work Summary" Time Report?
One idea - a query to set the ticket_change.time to the time tracjsgantt uses/calculates, which I can run now and then before generating Time Reports.