Plugin Developer Discussion

Discussion for FogBugz Plugin developers

AddLeftJoin hates me!

The following code crashes in the latest alphs:

var qb = api.Bug.NewBugQuery();
    "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)
Stefan Rusek Send private email
Sunday, May 17, 2009
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.
Stefan Rusek Send private email
Sunday, May 17, 2009
Whoops, yep, I have a bug open for that...Joining the same table twice causes it to fail with that (incorrect) exception.
David Fullerton Send private email
Monday, May 18, 2009
Also, I am working on clarifying the documentation for CBugQuery and tables defined in IPluginBugJoin
Adam Wishneusky Send private email
Tuesday, May 19, 2009

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics
Powered by FogBugz