/// <summary> /// Creates a Defect Age graph under analysis folder /// </summary> /// <param name="analysisItemFolder">AnalysisItemFolder Object</param> /// <param name="graphName">Name of the graph</param> /// <param name="groupByField">Group by field name</param> /// <param name="sumOfField">Sum of field, if this is emplty then count of will be automatically selected</param> /// <param name="ageGrouping">Age Grouping Enum object.</param> /// <param name="filterString">Filter defects. You can get this using TDFilter Object</param> /// <returns></returns> public TDAPIOLELib.AnalysisItem CreateDefectAgeGraph(TDAPIOLELib.AnalysisItemFolder analysisItemFolder, String graphName, String groupByField, DefectSummaryGraphSumOF sumOfField, DefectAgeGrouping ageGrouping, String filterString) { TDAPIOLELib.AnalysisItemFactory analysisItemFactory = analysisItemFolder.AnalysisItemFactory; TDAPIOLELib.AnalysisItem analysisItem = analysisItemFactory.AddItem(System.DBNull.Value); analysisItem.Name = graphName; analysisItem.Type = "Graph"; String SOF = ""; if (sumOfField.Equals(DefectSummaryGraphSumOF.ActualFixTime)) { SOF = "BG_ACTUAL_FIX_TIME"; } else if (sumOfField.Equals(DefectSummaryGraphSumOF.EstimatedFixTime)) { SOF = "BG_ESTIMATED_FIX_TIME"; } else if (sumOfField.Equals(DefectSummaryGraphSumOF.None)) { SOF = ""; } else { throw (new Exception("Invalid Defect SumOf Fields")); } String AG = ""; if (ageGrouping == DefectAgeGrouping.NoGrouping) { AG = "All"; } else if (ageGrouping == DefectAgeGrouping.OneMonth) { AG = "OneMonth"; } else if (ageGrouping == DefectAgeGrouping.OneWeek) { AG = "OneWeek"; } else if (ageGrouping == DefectAgeGrouping.SixMonths) { AG = "SixMonth"; } else if (ageGrouping == DefectAgeGrouping.OneYear) { AG = "OneYear"; } analysisItem.FilterData = GetDefectAgeGraphFilterData(groupByField, SOF, AG, filterString); analysisItem.SubType = "AgeGraph"; analysisItem.Module = "defect"; analysisItem.Post(); return(analysisItem); }
private TDAPIOLELib.AnalysisItem CreateSummaryGraph(TDAPIOLELib.AnalysisItemFolder analysisItemFolder, String GraphName, String GroupByField, String SumOfField, String XAxisField, String FilterString, String ReportModule) { TDAPIOLELib.AnalysisItemFactory analysisItemFactory = analysisItemFolder.AnalysisItemFactory; TDAPIOLELib.AnalysisItem analysisItem = analysisItemFactory.AddItem(System.DBNull.Value); analysisItem.Name = GraphName; analysisItem.Type = "Graph"; analysisItem.FilterData = GetDefectSummaryGraphFilterData(GroupByField, SumOfField, XAxisField, FilterString); analysisItem.SubType = "SummaryGraph"; analysisItem.Module = ReportModule; analysisItem.Post(); return(analysisItem); }
/// <summary> /// Creates a new excel report under analysis folder /// </summary> /// <param name="analysisItemFolder">AnalysisItemFolder Object</param> /// <param name="name">Name of the Excel Report</param> /// <param name="query">Query to be added</param> /// <returns></returns> public TDAPIOLELib.AnalysisItem CreateExcelReport(TDAPIOLELib.AnalysisItemFolder analysisItemFolder, String name, String query) { TDAPIOLELib.AnalysisItemFactory analysisItemFactory = analysisItemFolder.AnalysisItemFactory; TDAPIOLELib.AnalysisItem analysisItem = analysisItemFactory.AddItem(System.DBNull.Value); analysisItem.Name = name; analysisItem.Type = "ExcelReport"; analysisItem.FilterData = GetExcelReportFilterData(query); analysisItem.SubType = "ExcelReport"; analysisItem.Module = "UnspecifiedEntity"; analysisItem.Post(); return(analysisItem); }
/// <summary> /// Renames a report or graph /// </summary> /// <param name="analysisItem">Analysis Item object</param> /// <param name="newItemName">new item name</param> /// <returns></returns> public Boolean RenameReportOrGraph(TDAPIOLELib.AnalysisItem analysisItem, String newItemName) { analysisItem.Name = newItemName; analysisItem.Post(); return(true); }