Question

Hi, I'm using the FogBugz XML API to create a report of Kiln code reviews. When I include the "events" column, I get a lot of great info about items in the review - but I'm not able to discern the hierarchy of the events. For example, one user posts a comment, to which another user posts a reply. In Kiln, the reply is shown indented - so it somehow knows that it's a reply to the prior post. But as far as I can tell, the API doesn't include that relationship binding.
Is it there somewhere? If not, that would be a feature request. I'm using version 8.4.90. Thanks, Mike

Answer 1

The hierarchy of bug event replies for Code Reviews in Kiln is actually stored and maintained entirely by Kiln and the Kiln FogBugz Plugin, not FogBugz itself.

While Kiln has its own API, code review bug events are not currently exposed through it. If you'd like to see this added to the official Kiln API, here is the feature request in the Kiln support site.

To workaround this, you could write a FogBugz plugin that read's the BugEventReplies table used by the Kiln Plugin directly.

WARNING: This is an internal Kiln Plugin table, and as such, might change at any time without warning and cause your code to burst into angry flames of sadness and despair. This is not in any way a supported means of getting at this information. You have been warned.

var sb = new StringBuilder();
var query = api.Database.NewSelectQuery(
    api.Database.PluginTableName("KilnPlugin@fogcreek.com", "BugEventReplies")
);
var ds = query.GetDataSet();
foreach (DataRow row in ds.Tables[0].Rows)
{
    sb.AppendFormat(
        "<p>ixBug:{0}<br />ixBugEvent:{1}<br />ixBugEventInReplyTo:{2}</p>",
        row["ixBug"].ToString(),
        row["ixBugEvent"].ToString(),
        row["ixBugEventInReplyTo"].ToString()
    );
}
return sb.ToString();