It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Follow this question
Question details

×42,788

question asked: Feb 24 '17, 8:10 a.m.
question was seen: 1,630 times
last updated: Mar 01 '17, 11:41 p.m.

Related questions

FAQ - How this Forum works

Why custom attribute is not seen in RTC JRS 6.0.2?

0
sayli Boralkar (15●7) | asked 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.

Comments
Lily Wang commented 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 commented 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

Most liked answers ↑|Newest answers|Oldest answers

0
permanent link
Kenji Sarai (960●2●9) | answered Feb 28 '17, 5:05 a.m.
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
permanent link
sayli Boralkar (15●7) | answered 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.

Comments
Kenji Sarai commented 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.

0
permanent link
sayli Boralkar (15●7) | answered 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


Your answer

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