Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

Why custom attribute is not seen in RTC JRS 6.0.2?

Questions
Tags
Users
Badges
sayli Boralkar
(15●9) Feb 24 '17, 8:10 a.m.

 I want to build report so I go though url  "https://server_name:9443/rs" then I clicked Build and follow some basic steps for generating report but I didnt get custom attribute after clicking on Add Condition only default attribute are displayed. 

I am using RTC6.0.2 version and JRS6.0.2
I followed some links provided by jazz.net but no result is came.
One of the link that i go through is 


please give me suggestion over this.

0 votes

Comments
Lily Wang
Feb 26 '17, 8:40 p.m.

What's the type of your custom attribute? Some attribute type are not supported due to the product limitation.

In addition, refreshing RS data source is the most possible solution. Otherwise I suggest you contact IBM Support to check the data in data warehouse.

sayli Boralkar
Feb 27 '17, 12:34 a.m.

Thanks for answer Lily Wang.


        I  am using Contributor Type. When I referred some site there was mentioned about Contributor List is not supported but Contributor Type is supported. 
I also refresh RS Data source but custom attribute are not displayed. 

3 answers
2,320 views
0 votes

3 answers

Permanent link
Kenji Sarai
(960●3●9) edited
Feb 28 '17, 5:08 a.m.

Hi Sayli,

The custom attributes for workitem are stored in the database table RICALM.REQUEST_ XXX_EXT, where XXX is the workitem type name. For example
REQUEST_DECIMAL_EXT > Decimal type
REQUEST_ENUMERATION > Enumeration type
REQUEST_INT_EXT > Integer type
REQUEST_REQUEST_EXT > Request type 
...

You may run the query "select * from RICALM.REQUEST_ XXX_EXT" in Advanced tab in JRS Build menu to see if there is any data. I cannot find a table for Contributor type, though.

0 votes

Permanent link
sayli Boralkar
(15●9) Mar 01 '17, 11:21 p.m.

 hello kenji sarai,


We manually create a query for Contributor type attribute in Advance section because RTC6.0.2 version is not support Contributor or any complex type attribute. There may be the reason of contributor type doesn't show into database table.

0 votes

Comments
Kenji Sarai
Mar 01 '17, 11:31 p.m.

Good to know you find the answer in
https://jazz.net/forum/questions/221341/how-can-i-display-an-attribute-value-in-report-builder-output-when-the-attribute-type-is-contributor
I have tested in CLM 6.0.2 too, so that's why I could not find them either.

Permanent link
sayli Boralkar
(15●9) Mar 01 '17, 11:41 p.m.

 I also checked in CLM6.0.2 but contributor type attribute is not working there in add condition pane.  So As per the link u mentioned with help of this I solved my Query but now we have to see this type attribute is support in 6.0.3 or not and also Database table fetches that value in database or not. because database fetches the value i.e. already available in Data warehouse


0 votes

Your answer

Register or log in 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.

Ask a question
Guidelines
FAQ
Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details

Question asked: Feb 24 '17, 8:10 a.m.

Question was seen: 2,320 times

Last updated: Mar 01 '17, 11:41 p.m.

Confirmation Cancel Confirm