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

IBM Report Builder issue with enumeration list in DNG and LISTAGG

Questions
Tags
Users
Badges
Krzysztof Koprowski
(101●7) May 11 '20, 12:42 p.m.
Hi

I have issue with LISTAGG function in Report Builder when generating reports from DNG.

Requirements has enum list that can have values from 1 to 10, so one requirement can have for example 1,5 and 6.

When we will execute report with LISTAGG using this attribute we are getting 1,1,1,5,5,5,6,6,6.

Each selected value is displayed 3 times.

Can You help us to make each value to appear once like it should be 1,5,6.

1 vote

1 answer
2,362 views
1 vote

Accepted answer

Permanent link
Bartosz Chrabski
(3.6k●2●29●49) edited
May 11 '20, 12:48 p.m.

 Hi Krzysztof,


If you want to get rid of duplicates, you should use distinct function other with listagg. I do not know what database are you using but for DB2 it should look like "LISTAGG(DISTINCT T4.LITERAL_NAME,',') AS LITERAL_NAME".

Additionally, if this query wont validate because it will be too complex for Report Builder to validate then You can turn off the validation.

/validate_off{/ (LISTAGG(DISTINCT T4.LITERAL_NAME,',') AS LITERAL_NAME /}/

Krzysztof Koprowski selected this answer as the correct answer

1 vote

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.

Ask a question
Guidelines
FAQ
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
× 11,078

Question asked: May 11 '20, 12:42 p.m.

Question was seen: 2,362 times

Last updated: May 11 '20, 12:48 p.m.

Related questions
Confirmation Cancel Confirm