List of modified files per ticket

Hi,

I'm pretty new to Trac, but I find it really useful.
We are currently using Trac 0.11dev-r6048 in my company to
do web 
development.

My question is the following:
Is there a way of getting, from the ticket number, the list
of files 
that have been committed regarding this ticket number?

Let me give you an example of what I am searching for:
- A ticket is opened concerning a bug that has been found.
This ticket 
gets the number 27.
- I make some changes in the file "file1.php", and
commit it to the svn 
repo. This creates the Changeset [324] int the Timeline.
- A few days later, I realize that something more has to be
done in 
"file2.php", and commit it after correcting the
bug. This creates the 
Changeset [361] in the Timeline.
- After validation by another person, the bug is considered
fixed, so I 
want to upload all the files that have been modified to
correct bug #27. 
Currently, I go to the Timeline, and with a little
<ctrl>-F "#27", I 
manually search for each changeset that has been done
regarding this bug 
(I will thus find Changeset [324] and [361]). For each
Changeset, I 
click on the link and note on a post-it the name of the
files that have 
been modified. Additionally I would even check for each file
if it has 
not been modified to correct another opened bug, so as not
to upload by 
error a pending bug fix (I have to admit that I happen to
not check all 
the files, as it is very )

As you can understand, this is OK if there is only a few
Changesets and 
modified files, but if you have a heavy bug that implies a
lot of 
modifications in a lot of files (starting at 10 changesets
and 20 files 
for example), this procedure gets really annoying.

My "dream" is to get from "BUG #27", the
list
- "file1.php"
- "file2.php"

I'm sure I'm not the only one to need this, no? Does a way
of doing this 
exist?

Best Regards,
Emilien Klein.
P.S.: Happy New Year in advance 

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the
Google Groups "Trac Users" group.
To post to this group, send email to trac-usersgooglegroups.com
To unsubscribe from this group, send email to
trac-users-unsubscribegooglegroups.com
For more options, visit this group at http:
//groups.google.com/group/trac-users?hl=en
-~----------~----~----~----~------~----~------~--~---

> I'm sure I'm not the only one to need this, no? Does a
way of doing this
> exist?

You need to tie SVN commit with Trac ticket. You can achieve
this
using the trac pre and post commit script. See the /contrib
directory
that comes with Trac, and
http://tra
c.edgewall.org/wiki/TracFaq#can-trac-automatically-update-a-
ticket-when-i-commit-a-changeset

HTH,
Manu

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the
Google Groups "Trac Users" group.
To post to this group, send email to trac-usersgooglegroups.com
To unsubscribe from this group, send email to
trac-users-unsubscribegooglegroups.com
For more options, visit this group at http:
//groups.google.com/group/trac-users?hl=en
-~----------~----~----~----~------~----~------~--~---

Hi,

You may use trac-post-commit-hook，then you can add
ticket number into
your comment when you commit files to svn. It's very
convenient to
check what files relate to a ticket, have a good luck.

Best Regards
Evan Wang

On Dec 31 2007, 9:06 pm, Emilien Klein <emil...rentalia.com> wrote:
> Hi,
>
> I'm pretty new to Trac, but I find it really useful.
> We are currently using Trac 0.11dev-r6048 in my company
to do web
> development.
>
> My question is the following:
> Is there a way of getting, from the ticket number, the
list of files
> that have been committed regarding this ticket number?
>
> Let me give you an example of what I am searching for:
> - A ticket is opened concerning a bug that has been
found. This ticket
> gets the number 27.
> - I make some changes in the file
"file1.php", and commit it to the svn
> repo. This creates the Changeset [324] int the
Timeline.
> - A few days later, I realize that something more has
to be done in
> "file2.php", and commit it after correcting
the bug. This creates the
> Changeset [361] in the Timeline.
> - After validation by another person, the bug is
considered fixed, so I
> want to upload all the files that have been modified to
correct bug #27.
> Currently, I go to the Timeline, and with a little
<ctrl>-F "#27", I
> manually search for each changeset that has been done
regarding this bug
> (I will thus find Changeset [324] and [361]). For each
Changeset, I
> click on the link and note on a post-it the name of the
files that have
> been modified. Additionally I would even check for each
file if it has
> not been modified to correct another opened bug, so as
not to upload by
> error a pending bug fix (I have to admit that I happen
to not check all
> the files, as it is very )
>
> As you can understand, this is OK if there is only a
few Changesets and
> modified files, but if you have a heavy bug that
implies a lot of
> modifications in a lot of files (starting at 10
changesets and 20 files
> for example), this procedure gets really annoying.
>
> My "dream" is to get from "BUG
#27", the list
> - "file1.php"
> - "file2.php"
>
> I'm sure I'm not the only one to need this, no? Does a
way of doing this
> exist?
>
> Best Regards,
> Emilien Klein.
> P.S.: Happy New Year in advance 

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the
Google Groups "Trac Users" group.
To post to this group, send email to trac-usersgooglegroups.com
To unsubscribe from this group, send email to
trac-users-unsubscribegooglegroups.com
For more options, visit this group at http:
//groups.google.com/group/trac-users?hl=en
-~----------~----~----~----~------~----~------~--~---

how would you then find all the files relating to a ticket?
especially
if you commit more changesets regarding one ticket?

On Jan 1, 6:50 am, "evan...gmail.com"
<evan...gmail.com> wrote:
> Hi,
>
> You may use trac-post-commit-hook，then you can
add ticket number into
> your comment when you commit files to svn. It's very
convenient to
> check what files relate to a ticket, have a good luck.
>
> Best Regards
> Evan Wang
>
> On Dec 31 2007, 9:06 pm, Emilien Klein <emil...rentalia.com> wrote:
>
>
>
> > Hi,
>
> > I'm pretty new to Trac, but I find it really
useful.
> > We are currently using Trac 0.11dev-r6048 in my
company to do web
> > development.
>
> > My question is the following:
> > Is there a way of getting, from the ticket number,
the list of files
> > that have been committed regarding this ticket
number?
>
> > Let me give you an example of what I am searching
for:
> > - A ticket is opened concerning a bug that has
been found. This ticket
> > gets the number 27.
> > - I make some changes in the file
"file1.php", and commit it to the svn
> > repo. This creates the Changeset [324] int the
Timeline.
> > - A few days later, I realize that something more
has to be done in
> > "file2.php", and commit it after
correcting the bug. This creates the
> > Changeset [361] in the Timeline.
> > - After validation by another person, the bug is
considered fixed, so I
> > want to upload all the files that have been
modified to correct bug #27.
> > Currently, I go to the Timeline, and with a little
<ctrl>-F "#27", I
> > manually search for each changeset that has been
done regarding this bug
> > (I will thus find Changeset [324] and [361]). For
each Changeset, I
> > click on the link and note on a post-it the name
of the files that have
> > been modified. Additionally I would even check for
each file if it has
> > not been modified to correct another opened bug,
so as not to upload by
> > error a pending bug fix (I have to admit that I
happen to not check all
> > the files, as it is very )
>
> > As you can understand, this is OK if there is only
a few Changesets and
> > modified files, but if you have a heavy bug that
implies a lot of
> > modifications in a lot of files (starting at 10
changesets and 20 files
> > for example), this procedure gets really
annoying.
>
> > My "dream" is to get from "BUG
#27", the list
> > - "file1.php"
> > - "file2.php"
>
> > I'm sure I'm not the only one to need this, no?
Does a way of doing this
> > exist?
>
> > Best Regards,
> > Emilien Klein.
> > P.S.: Happy New Year in advance - Hide
quoted text -
>
> - Show quoted text -
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the
Google Groups "Trac Users" group.
To post to this group, send email to trac-usersgooglegroups.com
To unsubscribe from this group, send email to
trac-users-unsubscribegooglegroups.com
For more options, visit this group at http:
//groups.google.com/group/trac-users?hl=en
-~----------~----~----~----~------~----~------~--~---

> I'm sure I'm not the only one to need this, no? Does a
way of doing this
> exist?

If you use TortoiseSVN on Windows there is another way to
automatically attach a hint:
We apply a property "bugtraq:message" to our
directories with a value
of "Ticket #%BUGID%." (note that %BUGID% is
embedded by '#' and '.' to
distinguish 27 and 270 etc.)
When  committing via TortoiseSVN there is an additional edit
field
named "Ticket#" and on commit a string is appended
to the commit
message resulting to "blah blah Ticket#27."
We use a special report "Tickets and Changesets, mine
first" to group
the changesets by ticket no:
SELECT
    (CASE reporter
     WHEN '$USER' THEN ''
     ELSE reporter
    END) || ' ' || t.id || ": " || summary AS
__group__,
    id AS ticket, rev AS changeset, r.time AS modified,
    c.value AS Defcon, r.author AS Author,
    message
  FROM ticket t, revision r, ticket_custom c
  WHERE r.message like "%%Ticket
#"||t.id||".%%"
    AND c.ticket = t.id AND c.name = 'state'
  ORDER BY (reporter = '$USER') DESC, reporter, t.time desc

This type of report should also be applicable when using
'post commit
hooks'.

Unfortunately the changeset numbers are not rendered as
links but you
can achieve this by patching the templates.

HTH,
jaydee


--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the
Google Groups "Trac Users" group.
To post to this group, send email to trac-usersgooglegroups.com
To unsubscribe from this group, send email to
trac-users-unsubscribegooglegroups.com
For more options, visit this group at http:
//groups.google.com/group/trac-users?hl=en
-~----------~----~----~----~------~----~------~--~---

On 2 Jan., 11:38, Juergen Deuse <jde...medistar.de> wrote:
> > I'm sure I'm not the only one to need this, no?
Does a way of doing this
> > exist?
>
( . . . )
> We use a special report "Tickets and Changesets,
mine first" to group
> the changesets by ticket no:

Well, actually you asked for the files that have been
changed... thus
the report should look like this:
SELECT distinct N.base_path
  FROM revision R, node_change N
  WHERE R.message like "%%Ticket #" || '$TICKET'
|| ".%%"
    AND R.rev = N.rev
  ORDER BY N.base_path

Beware! You have to modify the URL manually (assume it's
report no
'20'):
http://the-name-of-your-server/cgi-bin/trac.c
gi/report/20?TICKET=27

Maybe you create a small web based form which assists
preparing the
correct URL

HTH,
jaydee
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the
Google Groups "Trac Users" group.
To post to this group, send email to trac-usersgooglegroups.com
To unsubscribe from this group, send email to
trac-users-unsubscribegooglegroups.com
For more options, visit this group at http:
//groups.google.com/group/trac-users?hl=en
-~----------~----~----~----~------~----~------~--~---