RSS Feed

Plugin Developer Discussion

The following code crashes in the latest alphs:

var qb = api.Bug.NewBugQuery();
qb.AddLeftJoin(api.Database.PluginTableName("Kanban"),
    "Bug.ixBug = " + api.Database.PluginTableName("Kanban")
    + ".ixBug");


FogCreek.FogBugz.Exception.FogBugzException: Invalid syntax: JOIN ON clause may only reference one table from each side of the join (tables referenced: Bug, Plugin_2_Kanban)

It turns out that my plugin returns the same table as one of the tables to automatically joined with the Bug table. It took ma a while ti figure this out. A better error message would have saved me a lot of time.

Whoops, yep, I have a bug open for that...Joining the same table twice causes it to fail with that (incorrect) exception.

Also, I am working on clarifying the documentation for CBugQuery and tables defined in IPluginBugJoin