RSS Feed

Plugin Developer Discussion

I have a query against Bug table in a Fogbugz plugin and sometimes sCustomerEmail don't bring the correct value from database.

Ex.:

In database I have the value:
"FABIANA XXXX XXXX" <FABIANA.XXXX@nonono.com.br>
and I only get:
"FABIANA XXXX XXXX"

Other case:

In database I have the value:
"eveline.xxxx@nonono.com" <eveline.xxxx@nonono.com>
and I only get:
"eveline.xxxx@nonono.com"

How can I solve this problem?


+++ CODE ++++

string feedbackTableName = api.Database.PluginTableName("Feedback");

                    CBugQuery bugQuery = api.Bug.NewBugQuery();
                    bugQuery.IgnorePermissions = true;

                    bugQuery.AddLeftJoin(feedbackTableName, string.Format("Bug.ixBug = {0}.ixBug", feedbackTableName));

                    bugQuery.AddWhere("Bug.fOpen = 0");
                    bugQuery.AddWhere(string.Format("{0}.DataDoFeedback is null", feedbackTableName));
                    bugQuery.AddWhere("Bug.sTicket <> ''");
                    bugQuery.AddWhere("Bug.dtOpened > @dtOpened");
                    bugQuery.AddWhere("Bug.sCustomerEmail <> ''");

                    bugQuery.AddOrderBy("Bug.sCustomerEmail");

                    bugQuery.SetParamDate("dtOpened", new DateTime(2012, 5, 1));

                    CBug[] bugs = bugQuery.List();
                    string emailDoCliente = bugs[0].sCustomerEmail;

++++ END CODE +++++