It's all about the answers!

Ask a question

Birt- How to count the number of childrens of each workitems


Boris Fornaris (0145) | asked Jun 18 '12, 4:38 a.m.

Hello

In my case, each workitem has two types of childrens: "new components" and "modified components".

In Birt, I must count for each workitem how many new and modified childrens it has. I did it using birt agregation functions, but when I join Datasets it's not working well.

 

 Is there a "Group By" equivalent for BIRT in the LINKS table? How can I do something like that?

Select SOURCE_ITEMID, COUNT(TARGET_ITEMID) from LINKS where LINK_TYPE='com.ibm.san.workitem.extension.linktype.gc2cd.new' group by SOURCE_ITEMID

 

Best regards

Boris

2 answers



permanent link
James Moody (3.3k24) | answered Jun 18 '12, 8:45 a.m.
JAZZ DEVELOPER
There is no built-in aggregation available on the LINKS table. However, you can get similar functionality from LIVE_SNAPSHOT. com.ibm.team.links.AuditableLink. This includes a field "liveRecordCount" which, if you select only that, acts as a COUNT. It contains the same information in the LINKS table and more.

james


permanent link
Boris Fornaris (0145) | answered Jun 18 '12, 9:51 a.m.
I will test it right now. Thank you James.

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.