Plugin Developer Discussion

Discussion for FogBugz Plugin developers

Alias main table in NewSelectQuery

When joining tables to a query we can specify an alias.  It doesn't seem possible to do the same for the first table.  Specifically:

var query = api.Database.NewSelectQuery(MyTable);
query.AddInnerJoin(OtherTable, OnClause, "O");

In the first line, there is no way to specify an alias for MyTable which would be useful in other clauses (where, on, etc).
Samuel Neff Send private email
Wednesday, October 21, 2009
Yep, unfortunately we missed this in v1 so there's currently no way to do it.
David Fullerton Send private email
Wednesday, October 21, 2009

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

Other recent topics Other recent topics
Powered by FogBugz