Skip Navigation LinksHome Page > Forums > SpiraTeam Forums > Spira Custom Reports > ESQL String Aggregate
Hello,
I am trying to create an ESQL query that groups the results by the Test Case ID. For example, if I have the following table:
I want an ESQL query the groups the Requirements by Test Case ID and outputs:
For SQL, it appears that the query would be:
SELECT TEST_CASE_ID, STRING_AGG(REQUIREMENT_NAME,',') AS REQUIREMENTS
FROM SpiraTestEntities.R_RequirementTestCases
GROUP BY TEST_CASE_ID
However, ESQL removed the STRING_AGG function. Is there another way to do this?
I don't think ESQL supports that I'm afraid.
You may want to simply group by requirement name and then use XSLT to do the further aggregating and grouping.