How Can I Display an Attribute Value in report Builder Output when the Attribute Type is Contributor?
We are using RTC to track membership within an organization within the company. We track a member's name, ID, team, and other information about the member. They are using Report Builder to create output files with member information. I can pull all of the data that they need except for one item, the “Member Name”. The “Member Name” attribute is a “Contributor” type and is not selectable and therefore I am not able to display that in my Report Builder output. Is this a flaw in the Report Builder capability, or for some reason should I not be allowed to display values where the attribute type is “Contributor”?
This is going to be a real bummer if this turns out to be the case as I am able to pull all of this information about a member of this organization except for their name! Not very worthwhile. Any help would be appreciated!
Accepted answer
Complex custom attributes (such as Contributor, Team Area, Iteration) are not yet supported by Report Builder. The story User would like to support complex custom attributes (i.e. of type Iteration or Work Item) and add conditions and add them as columns (376959) is currently open, but it hasn't been assigned to any release yet.
If you have all the data you need, except the Member Name attribute, you could use the Advanced section on the Format Results page to edit the SQL statement. You would need to add the RICALM.REQUEST_RESOURCE_EXT table to the SQL, using the REQUEST_ID field to link it to the REQUEST table.
Please let me know if you need help adding that table to the rest of the SQL statement, I can help you with that.
Thank you,
Clara Forero
Comments
Hey Clara, yes, I have all of the data I need except for Member Name. I thought that query outputs and report Builder were so similar that is why I am surprised that you cannot dump a "contributor" attribute in Report Builder since you can in a query.
So I have dumped out the SQL information but never edited it. I would appreciate your help in regards to this. What do I need to provide?
I'll send you the instructions by e-mail.
Thanks,
Clara Forero
Modifying the SQL query worked! Awesome!
@ clara forero
Hi Kesav,
There is no script, the solution that I proposed to Rob was to modify the SQL statement. If you want to follow the same procedure, build a new report, select the artifact Work Item and in the Format Results page, go to Advanced SQL section. Edit the query and add the extension table that contains the attributes of type Contributor (RICALM.VW_RQST_RESOURCE_EXT). Here is an example of the finished SQL statement, querying an attribute named "MyOtherContributor":
SELECT DISTINCT T1.PROJECT_NAME,
T1.REFERENCE_ID,
T1.NAME AS URL1_title,
T1.URL AS URL1,
T2.RESOURCE_NAME AS Contributor
FROM RIDW.VW_REQUEST T1
LEFT OUTER JOIN RICALM.VW_RQST_RESOURCE_EXT T2
ON T2.REQUEST_ID=T1.REQUEST_ID AND T2.NAME = 'MyOtherContributor'
WHERE (T1.ISSOFTDELETED = 0) AND
(T1.REQUEST_ID <> -1 AND T1.REQUEST_ID IS NOT NULL)
Thank you,
Clara Forero
thanks very much Clara Forero for the query.
Hi Kesav,
In the SQL you included, the condition for the name of the custom attribute is missing (e.g. AND T2.NAME = 'MyOtherContributor') . If you want to add other attributes of type contributor, you can add again the extension table using in the join condition the name of each of those attributes.
Thank you,
Clara
6 other answers
Hi,
The story that implemented the complex custom attributes mentioned before User would like to support complex custom attributes (i.e. of type Iteration or Work Item) and add conditions and add them as columns (376959) was delivered in 6.0.3.
Thank you,
Clara Forero
Thanks @Clara Forero.
Hi Sayli,
The custom attribute of type contributor is available in CLM 6.0.3. When using a previous version, if you modify the SQL in a similar way as mentioned before, you should be able to see the contributor information in the report results, but the attribute won't be available in the conditions pane.
If you can't upgrade to CLM 6.0.3 and require assistance creating the SQL in your CLM 6.0.2 environment, please contact IBM Support. They should be able to look into the data you have in your environment and guide you to create the SQL statement you require for your report.
Thank you,
Clara
Comments
Clara Forero
JAZZ DEVELOPER May 20 '16, 1:45 p.m.Hi Rob,
I'm trying to understand what exactly you mean by "Member Name". Is that a custom attribute that you added to a specific work item type in RTC? Where exactly is this "Member Name" attribute located? What artifact(s) are you using in the report? What other related attributes are you able to include in the report?
Thank you,
Clara Forero
Rob Olsen
May 20 '16, 3:40 p.m.Clara, thanks for responding ...
So, correct, "Member Name" is a custom attribute that is defined as "Contributor". "Member Name" is located in the "Overview Layout" area, in the "Details" section.
Member Information (Overview Layout)
Member Information Details (layout slot: Details)
Member Name (Contributor)
As far as "What artifact(s) are you using in the report?", I am not exactly sure what you are asking. I am using as much detail about the member that I can. Member ID, Function, Assigned Manager .... all of these are selectable from the drop down menu in the report.
I can create a query and under "Column Display" in the "Select Attributes" pop up menu, I can select "Member Name". The query runs and the member names are listed. But I cannot select "Member Name" when doing something similar in Report Builder, "Member Name" is not an attribute that I can choose to display.