Question

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

Case FC1259445

Answer 1

A warning about modifying the database directly...

I had to do 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 2

This is not changeable in the UI in FogBugz 7. 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.