id,summary,reporter,owner,description,type,status,priority,milestone,component,version,severity,resolution,keywords,cc,branch,changelog,apichanges,internalchanges 6817,[patch] Showing related changesets on a ticket,kevin@…,Jonas Borgström,"Attached is a small patch that adds a list of related changesets to the ticket view. (By related changeset, I mean those that reference a ticket in the commit message, in the form ''#nn''). The extra section is only shown if there are any changesets to link to for that ticket; otherwise it looks the same as before. It looks like: [[Image(screenshot.PNG)]] We've been using a patch like this where I work for a year or so now, and we've found it to be really helpful (especially in conjunction with TortoiseSVN's `bugtraq:warnifnoissue` and `bugtraq:logregex` properties). I wondered if anyone else would like to see this sort of thing in a future release? (I did see that there is an ''xref'' branch that looks like it will address this type of thing, along with a lot more, but I wasn't sure what plans there might be for merging that. This patch is also just for one part of the ''xref'' stuff -- the part that I found myself wanting -- and as such it's a much smaller change.) It does add a new table (to avoid incurring a full index scan on each ticket view). That will be created in an install or upgrade, but if anyone wants to try the patch on an existing installation you'll need to do something like this: {{{ create table ticket_revision ( ticket integer not null, rev text not null, primary key (ticket, rev) ); create index idx_ticket_revision_rev on ticket_revision (rev); }}} I've only tested the code against PostgreSQL 8.2 and 8.3 at this point. Apologies if this is something that has already been discussed. I did see mention of some similar things on the mailing list a while back, but I just didn't find anything that quite filled my own needs the same way. Lastly, this is my first time trying to submit anything to this project, so any feedback on the patch/ticket would be much appreciated :) Thanks, Kevin ",enhancement,closed,normal,,ticket system,,normal,duplicate,,,,,,