Attempting to print multiple attribute values in one row in JRS 6.0.3
Greetings!
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>