Inflectra Customer Forums: Test Cases Counts per Portfolio (Thread) Hi, Is it possible to count the all the created Test Cases per potfolio using ESQL from Edit Reports on SpiraPlan? Thank you. en-US(C) Copyright 2006-2026 Inflectra Corporation.support@inflectra.com/Computers/Software/Project_Management//Computers/Software/Quality_Assurance/KronoDesksupport@inflectra.comhttp://www.inflectra.com/kronodesk/forums/threads120/Support/Forum/spirateam/issues-questions/3065.aspxthreadId=3065LANCE JEWEL JAVIER (lance.javier@metrobank.com.ph)Test Cases Counts per Portfolio Hi, Is it possible to count the all the created Test Cases per potfolio using ESQL from Edit Reports on SpiraPlan? Thank you. Thu, 17 Jul 2025 08:35:21 -04002026-03-30T08:31:16-04:00/Support/Forum/spirateam/issues-questions/3065.aspxmessageId=7347Mario Clemons (manuelmassey632@gmail.com) Yes, it is possible to count all the created Test Cases per Portfolio in SpiraPlan using ESQ Yes, it is possible to count all the created Test Cases per Portfolio in SpiraPlan using ESQL (Enterprise SQL) from the Edit Reports section. You can write an ESQL query that: Counts all test cases. Groups them by Product (aka Project in SpiraPlan). If your Portfolios are structured using Product Groups (which is SpiraPlans way of grouping products into Portfolios), then you can join across tables to get counts per Portfolio. Tue, 05 Aug 2025 03:38:09 -04002025-08-05T03:38:09-04:00/Support/Forum/spirateam/issues-questions/3065.aspx#reply7347messageId=7349Victoria D (nino.diasamidze@inflectra.com) Hello, Yes, that can be done for sure. Here is the sample query that counts test cases by portfoli Hello, Yes, that can be done for sure. Here is the sample query that counts test cases by portfolio. SELECT COUNT(TC.[TEST_CASE_ID]) AS TEST_CASE_COUNT, PF.[PORTFOLIO_ID] --,PG.PROJECT_GROUP_ID AS PROGRAM_ID, TC.PROJECT_ID FROM SpiraTestEntities.R_TestCases AS TC INNER JOIN SpiraTestEntities.R_ProjectGroups AS PG ON PG.[PROJECT_GROUP_ID] = TC.PROJECT_GROUP_ID INNER JOIN SpiraTestEntities.R_Portfolios AS PF ON PG.PORTFOLIO_ID = PF.PORTFOLIO_ID GROUP BY PF.[PORTFOLIO_ID] --,TC.[PROJECT_GROUP_ID], --,PG.PROJECT_GROUP_ID --,TC.PROJECT_ID If you remove the comment symbols for lines 3, 8,9 and 10 then the output will display also an ID or the product and program test cases belong to. Here you can find more details about how to manage portfolios: https://spiradoc.inflectra.com/Spira-Administration-Guide/System-Workspaces/#viewedit-portfolios Hope that helps. Regards, Victoria - Wed, 06 Aug 2025 10:38:54 -04002025-08-06T10:38:54-04:00/Support/Forum/spirateam/issues-questions/3065.aspx#reply7349messageId=7388James Patton (james598patton@www-ipass.com) Yes, its possible using ESQL in Edit Reports. You can group by PortfolioId and count TestCaseId to Yes, its possible using ESQL in Edit Reports. You can group by PortfolioId and count TestCaseId to get totals per portfolio. Make sure your report joins the relevant tables like TestCases, Projects, and Portfolios. Thu, 25 Sep 2025 11:33:07 -04002025-09-25T11:52:39-04:00/Support/Forum/spirateam/issues-questions/3065.aspx#reply7388