/// <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); }
public void Test_AnalysisAndDashboardScripts() { ////Analysis Scripts TDAPIOLELib.AnalysisItemFolder analysisItemFolder = aLM_CORE.Analysis.FindPrivateFolder(); Console.WriteLine("ID of private folder : " + analysisItemFolder.ID); analysisItemFolder = aLM_CORE.Analysis.FindPublicFolder(); Console.WriteLine("ID of Public folder : " + analysisItemFolder.ID); analysisItemFolder = aLM_CORE.Analysis.CreateFolder("Private", "TestFolder1"); analysisItemFolder = aLM_CORE.Analysis.CreateFolderPath("Private\\TestFolder1\\Dummy2\\Dummy3"); TDAPIOLELib.AnalysisItem analysisItem = aLM_CORE.Analysis.CreateExcelReport(analysisItemFolder, "FindAllBugs", "Select * from Bug"); analysisItem = aLM_CORE.Analysis.CreateDefectSummaryGraph(analysisItemFolder, "DefectFirstGraph", "BG_STATUS", ALM_Wrapper.Analysis.DefectSummaryGraphSumOF.ActualFixTime, "BG_DETECTED_IN_REL", ""); Console.WriteLine(analysisItem.LayoutData.ToString()); TDAPIOLELib.AnalysisItemFileFactory analysisItemFileFactory = analysisItem.AnalysisItemFileFactory; foreach (TDAPIOLELib.AnalysisItemFile aif in analysisItemFileFactory.NewList("")) { aif.SetFilePath("C:\\Temp"); aif.Download(); } //TDAPIOLELib.Gra TDAPIOLELib.AnalysisItem analysisItem1 = aLM_CORE.Analysis.CreateDefectAgeGraph(analysisItemFolder, "Defect First Age Graph", "BG_RESPONSIBLE", ALM_Wrapper.Analysis.DefectSummaryGraphSumOF.None, ALM_Wrapper.Analysis.DefectAgeGrouping.NoGrouping, ""); aLM_CORE.Analysis.RenameFolder(analysisItemFolder, "TestFolder2"); Console.WriteLine("New Folder Name : " + analysisItemFolder.Name); ///Dashboard Scripts TDAPIOLELib.DashboardFolder dashboardFolderParent = aLM_CORE.Dashboard.CreateFolder(aLM_CORE.Dashboard.FindPrivateFolder(), "TestFolder1"); TDAPIOLELib.DashboardFolder dashboardFolder = aLM_CORE.Dashboard.CreateFolderPath("Private\\TestFolder1\\Dummy1\\Dummy2"); TDAPIOLELib.DashboardPage dashboardPage = aLM_CORE.Dashboard.CreatePage(dashboardFolder, "TESTPAGE1"); TDAPIOLELib.DashboardPageItem dashboardPage1 = aLM_CORE.Dashboard.AddAnalysisItemToDashboard(dashboardPage, analysisItem, 0, 0); TDAPIOLELib.DashboardPageItem dashboardPage2 = aLM_CORE.Dashboard.AddAnalysisItemToDashboard(dashboardPage, analysisItem1, 0, 1); foreach (TDAPIOLELib.DashboardFolder dashboardFolder1 in aLM_CORE.Dashboard.FindChildFolders(aLM_CORE.Dashboard.GetFolderObject("Private\\TestFolder1"))) { Console.WriteLine("Folder found under Private\\TestFolder1 : " + dashboardFolder1.Name); } foreach (TDAPIOLELib.DashboardPage dp in aLM_CORE.Dashboard.FindChildPages(dashboardFolder)) { Console.WriteLine("Dashboard page found under " + dashboardFolder.Name + " - " + dp.Name); } aLM_CORE.Dashboard.RenameFolder(dashboardFolder, "TestFolder2"); Console.WriteLine("New Dashboard Folder name is : " + dashboardFolder.Name); aLM_CORE.Dashboard.RenamePage(dashboardPage, "PageName1"); Console.WriteLine("New Dashboard page name is : " + dashboardPage.Name); aLM_CORE.Dashboard.DeletePageItem(dashboardPage1); aLM_CORE.Dashboard.DeletePageItem(dashboardPage2); aLM_CORE.Dashboard.DeletePage(dashboardPage); aLM_CORE.Dashboard.DeleteFolder(dashboardFolder); aLM_CORE.Dashboard.DeleteFolder(dashboardFolderParent); aLM_CORE.Analysis.DeleteFolder(analysisItemFolder); aLM_CORE.Analysis.DeleteFolder(aLM_CORE.Analysis.GetFolderObject("Private\\TestFolder1")); Console.WriteLine("Done"); }
/// <summary> /// Deletes report or graph /// </summary> /// <param name="analysisItem">analysisItem Object for graph or report</param> /// <returns></returns> public Boolean DeleteReportOrGraph(TDAPIOLELib.AnalysisItem analysisItem) { TDAPIOLELib.AnalysisItemFactory analysisItemFactory = tDConnection.AnalysisItemFactory; analysisItemFactory.RemoveItem(analysisItem.ID); return(true); }
/// <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); }
public TDAPIOLELib.DashboardPageItem AddAnalysisItemToDashboard(TDAPIOLELib.DashboardPage dashboardPage, TDAPIOLELib.AnalysisItem analysisItem, int Row, int Column) { TDAPIOLELib.DashboardPageItemFactory dashboardPageItemFactory = dashboardPage.DashboardPageItemFactory; TDAPIOLELib.DashboardPageItem dashboardPageItem = dashboardPageItemFactory.AddItem(System.DBNull.Value); dashboardPageItem.AnalysisItemId = analysisItem.ID; dashboardPageItem.Column = Column; dashboardPageItem.Row = Row; dashboardPageItem.Post(); return(dashboardPageItem); }