Hello Everyone:
I've setup trac with a ticket state of 'reviewing', indicating that code is
in review for a specific set of revisions. I have a custom field as
follows:
fixedrevision = text
fixedrevision.label = Fixed Revision(s)
Now, what I'd like to do is generate a report that automatically links to
these revisions (so that the user can click the report, see what reviews
they need to do, and then click the revision column to automatically get a
summary in trac of the differences in a particular file). Here is the
reporting that I have setup:
SELECT p.value AS __color__,
id AS ticket, summary,
(CASE owner
WHEN $USER THEN 'My Reviews'
ELSE 'Other Reviews'
END) AS __group__,
component, version, milestone,
c.value as id
FROM ticket t
LEFT OUTER JOIN ticket_custom c ON (t.id = c.ticket AND c.name =
'fixedrevision')
JOIN enum p ON p.name = t.priority AND p.type='priority'
WHERE status = 'reviewing'
ORDER BY (COALESCE(owner, '') = $USER) DESC, CAST(p.value AS signed),
milestone, t.type, time
Now, it works pretty good, but of course there are no links in the revisions
column. What I would like to do is allow a developer to enter, for
instance, [172:180] into the 'Fixed Revisions' field, assign another
developer for review, and then have the report for that developer
automatically take him/her to the source revision screen (e.g. if it had
been linked from within a ticket description) that would be generated by the
traclink [172:180].
I tried setting the realm to wiki, and then having the fixedrevisions be
selected as 'id', but this tried to take the user to a wiki page called
#[172:180], which of course doesn't exist. I don't quite understand what
other realms are available in trac. Is there a 'source' or some other realm
that I could use to accomplish what I am trying to do?
Does anyone know how to accomplish this?
Thanks,
~Scott
--
View this message in context:
http://old.nabble.com/Revision-Links-Inside-Report-tp27083571p27083571.html
Sent from the Trac Users mailing list archive at Nabble.com.
--
You received this message because you are subscribed to the Google Groups "Trac
Users" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/trac-users?hl=en.
