Displaying custom attributes in reports
I'm using the LIVE_WORKITEM_COUNT table and can see all my custom attributes of type STRING in the STRING_KEY column. What is the correct way to have the value of a single String attribute in the report output?
For example, I put 'apar_type' in the Default value of the STRING_KEY parameter and then placed STRING_VAL on the report. I get the output value, but it only returns those rows that have a value for 'apar type' where I want everything to be returned. In addition, my 'apar_type' column uses an Enumeration, but is of type String so when I look in the ENUMERATION table I don't see it there, but I've been able to convert with Priority and Severity. How would I do the conversion with a string type? I'm having a similar issue with the TIMESTAMP_KEY and TIMESTAMP_VAL columns. I added 'dcut' as the default value in the TIMESTAMP_KEY parameter and placed TIMESTAMP_VAL on the report. I get the correct timestamp returned but it's repeating each record multiple times in a row. Am I going about this correct in regards to adding custom attributes to the report? Thanks, |
5 answers
You should first fetch the work items without the custom attributes. Then for each fetched work item, fetch the custom attributes if any.
|
You should first fetch the work items without the custom attributes. Then for each fetched work item, fetch the custom attributes if any. Rafik, Is there any sample code in the pre-installed reports that I can look at to help with this? I'm struggling to fetch the custom attributes. I still get only the records populated with the custom value I'm trying to fetch, and then it's only displaying the literal name. Thanks, |
|
Michael, unfortunatly I do not have an example that does what you are asking for. Can we talk directly and I will walk you through on how to do this? Or create a Work Item (task) for me and I will attach a sample report design. Please assign the Work Item to me.
|
Michael, unfortunatly I do not have an example that does what you are asking for. Can we talk directly and I will walk you through on how to do this? Or create a Work Item (task) for me and I will attach a sample report design. Please assign the Work Item to me. Thanks, I created Task 110146, but it wouldn't let me assign an owner. I filed it against Reports. |
I'm using the LIVE_WORKITEM_COUNT table and can see all my custom attributes of type STRING in the STRING_KEY column. What is the correct way to have the value of a single String attribute in the report output? you need to provide the Enumrations dataset with a project area or you will get no results - use for instance '{Current Project Area}' as parameter |
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.