public CBugQuery GridColumnQuery(CGridColumn col) { return api.Bug.NewBugQuery(); }
public CBugQuery GridColumnSortQuery(CGridColumn col, bool fDescending, bool fIncludeSelect) { CBugQuery gridColumnQuery = api.Bug.NewBugQuery(); string orderByColumn = null; string tableName = null; switch (col.iType) { case 0: orderByColumn = "Hours"; tableName = Tables.HOURS_TABLE; break; case 1: orderByColumn = "LastEditor"; tableName = Tables.SPLIT_TABLE; break; } var pluginTableName = GetPluginTableName(tableName); gridColumnQuery.AddOrderBy(string.Format("{0}.{1} {2}", pluginTableName, orderByColumn, fDescending ? "DESC" : "ASC")); return gridColumnQuery; }
public CBugQuery GridColumnSortQuery(CGridColumn col, bool fDescending, bool fIncludeSelect) { CBugQuery bq = api.Bug.NewBugQuery(); if (fIncludeSelect) bq.AddSelect(string.Format("{0}.sFullName", PERSON_TABLE_ALIAS)); if (col.iType == 0) { bq.AddOrderBy(string.Format("{0}.sFullName {1}", PERSON_TABLE_ALIAS, fDescending ? "DESC" : "ASC")); } return bq; }
public string[] GridColumnDisplay(CGridColumn col, CBug[] rgBug, bool fPlainText) { string columnName = "Hours"; switch (col.iType) { case 0: columnName = "Hours"; break; case 1: columnName = "LastEditor"; break; } var valuesAsStrings = new string[rgBug.Length]; for (int i = 0; i < rgBug.Length; i++) { object value = rgBug[i].GetPluginField(Statics.PluginId, columnName); if (col.iType == 0) { valuesAsStrings[i] = (value == null) ? "No" : "Yes"; } else { valuesAsStrings[i] = (value == null) ? "No" : "Yes"; } } return valuesAsStrings; }
// original opener comes up as blank if the case originated as an email public string[] GridColumnDisplay(CGridColumn col, CBug[] rgBug, bool fPlainText) { string[] rgsValues = new string[rgBug.Length]; for (int i = 0; i < rgBug.Length; i++) { CBug bug = rgBug[i]; bug.IgnorePermissions = true; object oQueryField = bug.QueryField(PLUGIN_FIELD_NAME); int ixPersonOriginallyOpenedBy = (oQueryField == DBNull.Value) ? IXPERSON_INVALID : Convert.ToInt32(oQueryField); if (ixPersonOriginallyOpenedBy == IXPERSON_INVALID) { rgsValues[i] = ""; } else { CPerson personOrigOpener = api.Person.GetPerson(ixPersonOriginallyOpenedBy); rgsValues[i] = (api.Person.GetCurrentPerson().CanSee(personOrigOpener.ixPerson)) ? GetPersonLink(personOrigOpener) : personOrigOpener.sFullName; } } return rgsValues; }
public CBugQuery GridColumnQuery(CGridColumn col) { CBugQuery bugQuery = api.Bug.NewBugQuery(); bugQuery.AddSelect(string.Format("{0}.ixPerson as {1}, {2}.sFullName", BUGEVENT_TABLE_ALIAS, PLUGIN_FIELD_NAME, PERSON_TABLE_ALIAS)); bugQuery.AddLeftJoin("BugEvent", GetBugOpenedEventLeftJoinClause(), BUGEVENT_TABLE_ALIAS); bugQuery.AddLeftJoin("Person", string.Format("{0}.ixPerson = {1}.ixPerson", PERSON_TABLE_ALIAS, BUGEVENT_TABLE_ALIAS), PERSON_TABLE_ALIAS); return bugQuery; }
public string[] GridColumnDisplay(CGridColumn col, CBug[] rgBug, bool fPlainText) { string sTableColumn = "sName"; switch (col.iType) { case 0: sTableColumn = "sName"; break; case 1: sTableColumn = "dtBirth"; break; } string[] sValues = new string[rgBug.Length]; for (int i = 0; i < rgBug.Length; i++) { /* For tables joined in IPluginBugJoin, use * GetPluginField to fetch the values you need * for the GridColumn. */ object pluginField = rgBug[i].GetPluginField(PLUGIN_ID, string.Format("{0}", sTableColumn)); sValues[i] = (pluginField == null) ? "" : HttpUtility.HtmlEncode(pluginField.ToString()); } return sValues; }
public CBugQuery GridColumnSortQuery(CGridColumn col, bool fDescending, bool fIncludeSelect) { string sTableColumn = "sName"; switch (col.iType) { case 0: sTableColumn = "sName"; break; case 1: sTableColumn = "dtBirth"; break; } /* Return a CBugQuery with the data you need joined * in and sorted appropriately. Include an explicit * select if fIncludeSelect is true. If your table is * already joined to bug in IPluginBugJoin, FogBugz * does the work for you, ignore fIncludeSelect. */ CBugQuery bugQuery = api.Bug.NewBugQuery(); bugQuery.AddOrderBy(string.Format("{0}.{1} {2}", sPrefixedTableName, sTableColumn, (fDescending ? "DESC" : "ASC") ) ); return bugQuery; }
public CBugQuery GridColumnQuery(CGridColumn col) { /* Return a CBugQuery with the data you need joined * in. If your table is already joined to bug in * IPluginBugJoin, FogBugz does the work for you. */ return api.Bug.NewBugQuery(); }
public CBugQuery GridColumnSortQuery(CGridColumn col, bool fDescending, bool fIncludeSelect) { /* It's good practice to switch on the unique column iType if your plugin * specifies multiple custom columns. */ string sTableColumn = "ixAwesomeness"; switch (col.iType) { case 0: sTableColumn = "ixAwesomeness"; break; } /* Return a CBugQuery with the data you need joined * in and sorted appropriately. Include an explicit * select if fIncludeSelect is true. If your table is * already joined to bug in IPluginBugJoin, FogBugz * does the work for you, ignore fIncludeSelect. */ CBugQuery bugQuery = api.Bug.NewBugQuery(); bugQuery.AddOrderBy(string.Format("{0}.{1} {2}", sBugAwesomenessTableName, sTableColumn, (fDescending ? "DESC" : "ASC") ) ); return bugQuery; }
public string[] GridColumnDisplay(CGridColumn col, CBug[] rgBug, bool fPlainText) { string[] sValues = new string[rgBug.Length]; for (int i = 0; i < rgBug.Length; i++) { if (rgBug[i].GetPluginField(PLUGIN_ID, "ixAwesomeness") == null) sValues[i] = String.Empty; else sValues[i] = HttpUtility.HtmlEncode( GetAwesomenessString( Convert.ToInt32(rgBug[i].GetPluginField(PLUGIN_ID, "ixAwesomeness")) ) ); } return sValues; }