Feature Request: Remove relations (links) between cases - FogBugz Knowledge Exchange

Feature Request: Remove relations (links) between cases

2009-12-17T19:41:26Z

I have cases linked to my case in the see also section. I want to remove the links. How do I do it?

One use case for removing a relation is using Case Event Edit to fix the text of a bugevent. When I incorrectly type in 'case x' where I meant to enter 'case y', If I then edit the post, It adds the new relation to y. I would assume the link to case x would be removed as well.

Case FC1259445

Answer by adambox for Feature Request: Remove relations (links) between cases

2009-12-17T19:43:44Z

We have a case open to consider this feature for a future release. Please up-vote this question (not this answer) to show your support for adding this feature.

This is not changeable in the UI in FogBugz. For now, the only option is to remove the relevant rows from the BugRelation table directly in the database. This requires direct access (i.e. locally installed FogBugz). Whenever you make changes directly in the database, make sure to back it up first.

Note: adding and removing subcases to a case is possible. This answer concerns the see also links created when you type "case XYZ" into a case.

Answer by James McLeod for Feature Request: Remove relations (links) between cases

2009-12-18T17:41:30Z

A warning about modifying the database directly...

I had to delete a cross-reference yesterday (I added an incorrect cross-reference to a case which had the potential to cause huge confusion). After I deleted the bad entry from the bugrelation table, I also deleted the corresponding event from the bugevent table. Unfortunately, this had been the last bugevent for the bug, and so FogBugz couldn't find the event corresponding to the ixBugEventLatest field in the bug table and refused to display it in any filters...

I used this to look for other instances where I might have inadvertently deleted the last bugevent for a bug:

SELECT b.ixBug,MAX(ixBugEvent),b.ixBugEventLatest
  FROM bug b
  JOIN bugevent e
    ON b.ixBug = e.ixBug
 WHERE (SELECT MAX(x.ixBugEvent)
          FROM bugEvent x
         WHERE x.ixBug=e.ixBug) <> b.ixBugEventLatest
GROUP BY e.ixBug;

Answer by unknown (google) for Feature Request: Remove relations (links) between cases

2011-05-16T15:14:53Z

James McLeod's answer presumes direct access to the database. Since my company uses the FogBugz service, I have no such access. Therefore, if this feature is not provided in the UI, then I have no ability to accomplish this. Well, I suppose I could pester the folks at FogBugz to do it manually. And maybe I should do that. After all, if they get enough 'manual' requests, then they'd more quickly develop the code that could be placed in the UI? Just a thought off the cuff.

BTW, my initial request came from this use case: Edit a case and incorrectly type in 'case x' where I meant to enter 'case y'. Then edit the post, assuming that if I change the post from 'case x' to 'case y', that the link to case x would be replaced with a link to case y. It didn't work and that's how I came to find this stackexchange post.

Answer by Mike Dougherty for Feature Request: Remove relations (links) between cases

2011-07-21T18:17:45Z

I too would like to have this feature. And on a related note, I would like some way to be able enter the word "case" followed by an number without FogBugz relating that comment to a case...

The Use Case would be if my comment contained the phrase "Use Case #1...". Currently any comment I make on a case that uses that phrasing become associated to FogBugz case #1, 2, 3, 4, and so on.