Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

Attempting to print multiple attribute values in one row in JRS 6.0.3

 Greetings!


I'm attempting to put together a JRS report that lists the (comma separated) multiple attribute values for each record in one row, instead of a row for each value. 

Here's what I have...

SELECT DISTINCT T1.REFERENCE_ID, 
       T2.VAL AS VAL, 
       T3.LITERAL_NAME AS LITERAL_NAME 
FROM RIDW.VW_REQUIREMENT T1 
LEFT OUTER JOIN RICALM.VW_RQRMENT_STRING_EXT T2 
ON T2.REQUIREMENT_ID=T1.REQUIREMENT_ID AND T2.NAME='CSSS Tag' 
  LEFT OUTER JOIN RICALM.VW_RQRMENT_ENUMERATION T3 
  ON T3.REQUIREMENT_ID=T1.REQUIREMENT_ID AND T3.NAME='Variant' 
WHERE T1.PROJECT_ID = 15  AND 
(  T1.REQUIREMENT_TYPE = 'CSSS' AND 
  LOWER(T2.VAL) LIKE '%csss1.03%' 
) AND 
(T1.ISSOFTDELETED = 0) AND 
(T1.REQUIREMENT_ID <> -1 AND T1.REQUIREMENT_ID IS NOT NULL) <o:p> </o:p>


The attribute called 'Variant' is the source of the multiple values. 

I'm trying to find the correct function and syntax to make this happen. Can't seem to get LISTAGG to work, and can't find the right syntax for CONCATENATE to make that work either. 

Any clues?

Thanks in advance.

0 votes



One answer

Permanent link

Hi,


IBM has posted a support article here in regards to this question.

0 votes

Your answer

Register or log in 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.

Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details
× 12,020

Question asked: Aug 23 '17, 1:08 p.m.

Question was seen: 3,029 times

Last updated: Dec 04 '19, 9:50 p.m.

Confirmation Cancel Confirm