Eclipse Community Forums: BIRT » Group By in RTC JAZZ Queries for BIRT reports

Help

Home

Home » Archived » BIRT » Group By in RTC JAZZ Queries for BIRT reports(Eliminating duplicate entries)

Show: Today's Messages :: Show Polls :: Message Navigator

Group By in RTC JAZZ Queries for BIRT reports [message #1273070]

Wed, 19 March 2014 12:51

Artur Philipp

Messages: 1
Registered: March 2014

Junior Member

Hi,

I'm new to RTC, BIRT and JAZZ. I'm trying to create a report which summarizes all workitems grouped by their status. My Datasource is a JAZZ Datasource. Therefore I used the table "LIVE_WORKITEM_CNT" from the "Workitem Snapshot" and tried to do an inner join with the table "STATE" on the column "STATE".

My problem is that the table "STATE" contains duplicated row entries which only differ in their "REQUEST_STATE_ID" but have the same "STATE". After joining the tables the result set also contains duplicated rows. That means, that every workitem in "LIVE_WORKITEM_CNT" is combined with the two entries in the "STATE" table.

How can I avoid this behavior? Or how can I eliminate the duplicated rows?
I tried a SQL-like query with "SELECT DISTINCT" which is not supported for JAZZ data source queries.

I would appreciate any help!

Thanks in advance and best regards
Artur

Report message to a moderator