Custom attribute in BIRT Report

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

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?

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.

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.