relations Questions - FogBugz Knowledge Exchangemost recent 30 from http://fogbugz.stackexchange.com2012-02-09T13:49:56Zhttp://fogbugz.stackexchange.com/feeds/tag/relationshttp://www.creativecommons.org/licenses/by-nc/2.5/rdfhttp://fogbugz.stackexchange.com/questions/1119/feature-request-remove-relations-links-between-casesFeature Request: Remove relations (links) between casesadambox2009-12-17T19:41:26Z2011-09-13T23:23:11Z
<p>I have cases linked to my case in the <strong>see also</strong> section. I want to remove the links. How do I do it?</p>
<p>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.</p>
<blockquote>
<p><img src="http://www.gravatar.com/avatar/baf927dcc0b0c5d0f41dece1e575aa0f?s=32&d=identicon&r=PG" alt="Fog Creek"> <a href="http://fogbugz.stackexchange.com/questions/1023/whats-that-kiwi-logo-and-case-number-at-the-bottom-of-my-feature-request" rel="nofollow">Case FC1259445</a></p>
</blockquote>
http://fogbugz.stackexchange.com/questions/9075/definitive-syntax-to-associate-link-cases-in-fogbugz-kiln-and-the-wikiDefinitive Syntax to Associate & Link Cases in FogBugz, Kiln and the Wiki. Quang2011-08-30T07:39:23Z2011-09-08T20:55:29Z
<p>Okay so I think there should be a point of reference on how to cross-link / associate / relate cases to and from each other within FogBugz, Kiln, the Wiki, Discussions etc...</p>
<p>Because linking Cases in FogBugz and Kiln is awesome.</p>
<p><strong>The Basics</strong>:</p>
<p><a href="http://kiln.stackexchange.com/questions/491" rel="nofollow">http://kiln.stackexchange.com/questions/491</a></p>
<pre><code>review 123
case 123
bug 123
</code></pre>
<p><a href="http://fogbugz.stackexchange.com/questions/4405" rel="nofollow">http://fogbugz.stackexchange.com/questions/4405</a> & <a href="http://fogbugz.stackexchange.com/questions/4417" rel="nofollow">http://fogbugz.stackexchange.com/questions/4417</a></p>
<pre><code>BugzID: 1234
</code></pre>
<p>Assuming these works too?</p>
<pre><code>Review: 123
Case: 123
Bug: 123
</code></pre>
<p>How bout plural?</p>
<pre><code>Cases 123
Bugs 123
</code></pre>
<p><strong>Advance stuff</strong>: </p>
<p><a href="http://kiln.stackexchange.com/questions/1320/" rel="nofollow">http://kiln.stackexchange.com/questions/1320/</a></p>
<blockquote>
<p>If you haven't made a commit yet, simply mention the case in the commit message. For example, "Fixes case 123", "bugzid: 123", "Solves some bugs (bug ids 123, 456, and 789)" all work just fine, and will cause bidirectional linking.</p>
</blockquote>
<pre><code>bug ids 123, 456, 789
</code></pre>
<blockquote>
<p>I tried to make this clear, but apparently I failed. You need the word "case", "bug", "bug id", "bugz id", or "review" in front of the case number. All of the examples above follow that. The only pseudoexception is that, if enumerating multiple cases, you only need to have the word appear in front of the first. Thus, "Fixes cases 123 and 456" will work, but "Fixes 123 and 456" will fail.</p>
</blockquote>
<pre><code>cases 123 and 456
</code></pre>
<p>...<a href="http://fogbugz.stackexchange.com/questions/8863/plural-case-linking-related-cases" rel="nofollow">but not</a></p>
<pre><code>Case 123 & 456
</code></pre>
<p>How about...</p>
<pre><code>BugzId: 123 456 789
Cases 123, 456, 789
</code></pre>
<p>Sadly some of the advance linking only works from Kiln to FogBugz but <a href="http://fogbugz.stackexchange.com/questions/8863/plural-case-linking-related-cases" rel="nofollow">doesn't work</a> from within FogBugz itself.</p>
<p>The point is, I'm not sure which does work, and which doesn't work... the fact that you can say: </p>
<pre><code>Case #blah #blah
</code></pre>
<p>and have it show up auto-magically in FogBugz under "See also" related cases field is awesome and amazing. (should be <a href="http://fogbugz.stackexchange.com/questions/1119/feature-request-remove-relations-links-between-cases" rel="nofollow">easy to unlink</a> though)</p>
<p>I just think it should work the same way throughout FogBugz & Kiln, or at least have a definitive reference for all the syntax in <a href="http://fogbugz.stackexchange.com/questions/tagged/documentation" rel="nofollow">the</a> <a href="http://kiln.stackexchange.com/questions/tagged/documentation" rel="nofollow">docs</a> somewhere. </p>
<hr>
<p>Editted:</p>
<p>Ben Pollack was nice enough to release the RegExp for Kiln <a href="http://kiln.stackexchange.com/questions/4163/case-linking-eg-case-1-2" rel="nofollow">here</a>:</p>
<pre><code>\b(?<case>(review|case|bug[zs]?(\s| )*(id)?:?)s?(\s| )*([#:; ]| )+)((([ ,:;#]|and)*)(?<bugid>\d+))+
</code></pre>
http://fogbugz.stackexchange.com/questions/8863/plural-case-linking-related-casesPlural Case Linking "Related Cases"Quang2011-07-26T06:50:53Z2011-07-26T06:50:53Z
<p><img src="http://i.imm.io/7wIe.png" alt="alt text"></p>
<p>Plural text "Cases 308, 309" doesen't auto-link ?</p>
<p>I thought it did... (I think it <a href="http://kiln.stackexchange.com/questions/491" rel="nofollow">links in Kiln</a>?)</p>
<p>Shouldn't have to say "Case 308, Case 309"</p>
<p><img src="http://i.imm.io/7wIO.png" alt="alt text"></p>
<p>Thanks :)</p>
http://fogbugz.stackexchange.com/questions/3594/how-do-i-get-the-list-of-related-cases-for-a-cbug-in-my-pluginHow do I get the list of related cases for a CBug in my plugin?adambox2010-07-12T18:33:46Z2010-09-09T00:22:12Z
<p>I can get the related cases for a given case via the XML API, but how do I get them in a plugin?</p>
<blockquote>
<p><img src="http://www.gravatar.com/avatar/baf927dcc0b0c5d0f41dece1e575aa0f?s=32&d=identicon&r=PG" alt="Fog Creek"> <a href="http://fogbugz.stackexchange.com/questions/1023/whats-that-kiwi-logo-and-case-number-at-the-bottom-of-my-feature-request" rel="nofollow">Case FC1917292</a></p>
</blockquote>
http://fogbugz.stackexchange.com/questions/3838/can-i-use-the-number-of-see-also-links-to-a-case-to-search-or-even-display-thisCan I use the number of "see also" links to a case to search or even display this figure in fogbugz?Neil Trodden2010-07-28T17:30:14Z2010-07-29T20:52:38Z
<p>I'd like to be able to list or even find cases based on how many other cases it is linked to, we are using this to record duplicate requests from users for new features.</p>
<p>Should I be using occurrences instead? I can't seem to find a simple way to mark one case as another occurrence of another case?</p>
http://fogbugz.stackexchange.com/questions/3690/can-i-use-a-custom-field-to-connect-several-cases-to-one-caseCan I use a custom field to connect several cases to one case?Mohsin2010-07-20T20:50:03Z2010-07-27T19:32:08Z
<p>Can I create a custom field to define several cases to one case? If so, how?</p>
http://fogbugz.stackexchange.com/questions/1802/incoming-customer-emails-create-case-relations-when-they-have-case-numbers-in-theIncoming customer emails create case relations when they have case numbers in the bodiesRich Armstrong2010-02-05T16:33:01Z2010-07-16T22:08:25Z
<p>I have a case 1234. If a customer emails in with the text "case 1234" in the body of their email, a case relation is created. Is this intended?</p>
<blockquote>
<p><img src="http://www.gravatar.com/avatar/baf927dcc0b0c5d0f41dece1e575aa0f?s=32&d=identicon&r=PG" alt="Fog Creek"> <a href="http://fogbugz.stackexchange.com/questions/1023/whats-that-kiwi-logo-and-case-number-at-the-bottom-of-my-feature-request" rel="nofollow">Case FC1129713</a></p>
</blockquote>
http://fogbugz.stackexchange.com/questions/3214/xml-api-returns-wrong-ixrelatedbugs-when-referenced-on-wiki-pageXML API returns wrong ixRelatedBugs when referenced on wiki pageiamgoat2010-06-02T14:30:05Z2010-07-12T18:47:30Z
<p>Using the XML API, if you pass in an <code>ixBug</code> that is referenced on a Wiki Page, the <code>ixRelatedBugs</code> column will return the same ixBug you're passing in for each wiki reference instance. I ended up having to filter out the display of those if the <code>ixBugRelation</code> values match the <code>ixBug</code> being passed in.</p>
<p><strong>1. Find one to test:</strong></p>
<pre><code>SELECT TOP 10 *
FROM fogbugz.dbo.BugRelation (NOLOCK)
WHERE ixWikiPageFrom <> 0
ORDER BY ixBugTo DESC
</code></pre>
<p><strong>2. Call the XML API</strong></p>
<pre><code>/api.asp?cmd=search&ixBug=[ixBug]&cols=ixRelatedBugs&token=[token]
</code></pre>
<p><strong>Expect</strong></p>
<p><code>ixBug</code> not in the list as a related case</p>
<p><strong>Bug</strong></p>
<p><code>ixBug</code> is in the list</p>
<blockquote>
<p><img src="http://www.gravatar.com/avatar/baf927dcc0b0c5d0f41dece1e575aa0f?s=32&d=identicon&r=PG" alt="Fog Creek"> <a href="http://fogbugz.stackexchange.com/questions/1023/whats-that-kiwi-logo-and-case-number-at-the-bottom-of-my-feature-request" rel="nofollow">Case FC1917312</a></p>
</blockquote>