It's all about the answers!

Ask a question

JRS - LQE group_concat not displaying test cases with empty values


Krzysztof Koprowski (1017) | asked May 03 '20, 1:12 p.m.

Hi, 


I have list of test cases with enumaration lists (categories) which values we want to group in JRS report. 

Of course for DCC we can use LISTAGG, but because of enabled configuration management we have to use group_concat. Unfortunetly, if group_concat is used, it resulting in that test case, requirement or anyother arifact when none of enumeration values is selected. 

Summing up if we have function like this in JRS report GROUP_CONCAT(distinct $Requirement:Enum$;separator=", ") then requirements with empty enum values are not displayed in the report at all. 

 Can you please help us to group enumeration values and display as well objects with empty enumerations?

Accepted answer


permanent link
Bartosz Chrabski (3.4k12749) | answered May 03 '20, 2:17 p.m.

I did some research and found that the behavior you reported is a known defect: 


Defect 500325 CQPAR00249443: Custom Expressions on Enum attributes does not list unassigned values 

In some cases it's possible to use a workaround that is explained in the defect work item description. 

The defect has been fixed in 7.0 iFix001 and 6.0.6.1 iFix009

Krzysztof Koprowski selected this answer as the correct answer

Your answer


Register or to post your answer.


Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.