It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Guidelines | FAQ
Follow this question
Question details

×42,858

question asked: Apr 30 '12, 3:07 a.m.
question was seen: 4,405 times
last updated: Nov 19 '12, 8:12 a.m.

Related questions

Custom attribute in BIRT Report

1
Hansruedi Ehrenberg (25●5●8) | asked Apr 30 '12, 3:07 a.m.
Hello all

In our RTC setup we have defined a custom attribute 'Due Iteration'. This attribute is from type 'Iteration' like the standard workitem field 'Planned for'. In both fields 'Due Iteration' and 'Planned for' exactly the same values are selectable.

Please could someone give me a hint how I can get the value of the custom field 'Due Iteration' of all workitems into a BIRT report. I haven't found a table that contains this field.

Other custom attributes of our RTC setup I could find by using 'string_key', 'string_val' and 'enumerations' table.

Thanks in advance for your help.
Comments
Karol W commented Nov 19 '12, 5:50 a.m.

Hi Hansruedi,

I've just came across very similar problem, were you able to solve your problem?

Hansruedi Ehrenberg commented Nov 19 '12, 7:02 a.m.

Hi Karol, yes I could

1. create a data source based on LIVE_SNAPSHOT

2. create a data set and use 'com.ibm.team.workitem.WorkItem' table

3. use the fields itemId, itemExtensions.key and itemExtensions.value.itemId

I hope this helps 

Karol W commented Nov 19 '12, 8:12 a.m.

Thanks Hansruedi,

it helped :)

4 answers

Most liked answers ↑|Newest answers|Oldest answers

0
permanent link
Kim Soederhamn (1.5k●3●43●48) | answered Apr 30 '12, 9:09 a.m.
Hello all

In our RTC setup we have defined a custom attribute 'Due Iteration'. This attribute is from type 'Iteration' like the standard workitem field 'Planned for'. In both fields 'Due Iteration' and 'Planned for' exactly the same values are selectable.

Please could someone give me a hint how I can get the value of the custom field 'Due Iteration' of all workitems into a BIRT report. I haven't found a table that contains this field.

Other custom attributes of our RTC setup I could find by using 'string_key', 'string_val' and 'enumerations' table.

Thanks in advance for your help.


Are they not in the TIMESTAMP_KEY and TIMSTAMP_VAL of the LIVE_WORKITEM_CNT snapshot ? just a guess
0
permanent link
Hansruedi Ehrenberg (25●5●8) | answered May 02 '12, 5:01 a.m.
Are they not in the TIMESTAMP_KEY and TIMSTAMP_VAL of the LIVE_WORKITEM_CNT snapshot ? just a guess


Hello Kim,
no they aren't in the TIMESTAMP_KEY and the TIMESTAMP_VAL of the LIVE_WORKITEM_CNT snapshot.
Do yo have another hint?
0
permanent link
Kim Soederhamn (1.5k●3●43●48) | answered May 02 '12, 5:48 a.m.
Are they not in the TIMESTAMP_KEY and TIMSTAMP_VAL of the LIVE_WORKITEM_CNT snapshot ? just a guess


Hello Kim,
no they aren't in the TIMESTAMP_KEY and the TIMESTAMP_VAL of the LIVE_WORKITEM_CNT snapshot.
Do yo have another hint?

Hmm no I'm sorry - I would belive ther were in one of those fields - have you checked all the key and vals for values for anything that looks like the right thing ? usually I think iteration ids are a combination of the Item Id of a project area combined with the id of the iteration. So the value you are looking for should start with a key for the project area. and the total value should be rather unreadable :-)
If you don't get an answer here you might consider making a pmr.
0
permanent link
Hansruedi Ehrenberg (25●5●8) | answered May 02 '12, 8:31 a.m.
Hmm no I'm sorry - I would belive ther were in one of those fields - have you checked all the key and vals for values for anything that looks like the right thing ? usually I think iteration ids are a combination of the Item Id of a project area combined with the id of the iteration. So the value you are looking for should start with a key for the project area. and the total value should be rather unreadable :-)
If you don't get an answer here you might consider making a pmr.


Hello Kim,
we have created the . I will check your hint again.

I have checked all keys in the LIVE_WORKITEM_CNT table. I couldn't find an entry that looks like the right thing. I will wait on an answer from the PMR.

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.