I have a custom work item attribute which is of type Contributor. Which Snapshot / Table / Attribute should I access to retrieve the value for the custom attribute when authoring a BIRT report?

Thanks.

Hey there,

To find custom attributes you look for the STRING_KEY and STRING_VAL in LIVE_WORKITEM_CNT. If the val is not the display value you are looking for but a reference to a contributer id you can use the CONTRIBUTERS dataset from the COMMON Data source to join on.

Hi Kim,

I have a Value-Set based custom attribute I added to a workitem. The type is contributor as it is a drop that displays the users who are assigned to a specific role.

I am trying to access the data in a custom BIRT report. I have checked the STRING_KEY and STRING_VAL in LIVE_WORKITEM_CNT tables, and the fields do not show up.

Do you have any idea where the values for Custom Value Sets based on Roles is stored?

Thanks so much.

Paul Wellman

I have a custom work item attribute which is of type Contributor. Which Snapshot / Table / Attribute should I access to retrieve the value for the custom attribute when authoring a BIRT report?

Thanks.

Hey there,

To find custom attributes you look for the STRING_KEY and STRING_VAL in LIVE_WORKITEM_CNT. If the val is not the display value you are looking for but a reference to a contributer id you can use the CONTRIBUTERS dataset from the COMMON Data source to join on.

We currently only ETL and expose the simple type custom attributes.