BIRT Avoid Table Join and use Scripted Datasource and Java Script Instead
"Avoid Table Join and use Scripted Datasource and Java Script Instead" was what I heard from IBM Development. Unfortunately I have no clue how to do it.
My todays Issue.
I have added some custom field of type contributor to my work item and would like to present them on a report. For other fields like enumeration or state I load the items filtered by WI_ITEMID or PROJECT_AREA_ID with Total.count() and prepare an array where I can later on access my data.
But for Contributor I'm not able to filter and would load all 1500 items.
My todays solution is to inner join CONTRIBUTOR with WI_EXTENSION (or similar) table. Works fine but not very elegant. An there is more to come and I'll have to join other tables. Performance going bad :-)
So, my question is: how can I select the 5 CONTRIBUTOR_NAME out of the CONTRIBUTOR table, when I have a area with the 5 CONTRIBUTOR_ID
I did find different tutorials or examples of how to use Scripted Datasource. But none showing me how to get datas from an other table by scripting .
e.g select state, due date from all children of current Item
Any example, tutorial, hint would be welcome
Thanks
erwin
PS: we use 3.0.1.4 and soon 4.0.0.1
Comments
Vladimir Amelin
Oct 25 '12, 3:03 a.m.Usually I have to store all pairs ID-NAME from Contributor table and then use only selected ones (5 in your case). There is no way to get data from "other" data set.