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

Concatenating the two attributes/columns in an RTC query output

Hi

In an RTC query output, I would want to concatenate the values of two attributes/columns. Can this be done?

Regards
Vinay

0 votes


Accepted answer

Permanent link
The queries only display work item attributes. Dependent on the values you want to concatenate you could try using https://jazz.net/wiki/bin/view/Main/AttributeCustomization and use a script based value provider that does the concatenation in a special attribute. As far as I can tell, this would only work with primitive attribute types such as string and integer. Complex types don't allow access to the display data today.
Vinay Kumar AV selected this answer as the correct answer

0 votes

Comments

Thanks Ralph. I thought of the same approach but wanted to check if there is something out of the box that cab help achieve this before going this route.

When you say primitive types which are those?

Hi Vinay,

please see that wiki topic it kind of talks about it. String and int type attributes are primitive. enumerations, contributors and others are not.


2 other answers

Permanent link
Thanks Ralph, Can we display query output as a attribute value inside a work item.

Problem Statement : 'Booking Work Item' contains attribute 'Availability Status', default value of this is 'No'. This attribute is calculated based on Start Date and End Date of work item. Same comparison follow with other work items Start Date and End Date.

By Query i am able to view this records with Start Date, End Date, Status,
If record not found Availability Status must be Yes (Auto complete)
If record found Availability Status must be No(Auto complete)

Thanks in Advance.:)

0 votes

Comments

As far as I know this is not possible today. You might be able to do something with participants and Advisors. I am not sure. See https://rsjazz.wordpress.com/2012/07/31/rtc-update-parent-duration-estimation-and-effort-participant/ and check if that would be an option. You can, on save, calculate related work items and roll up values.

Be aware that my advice is to use RTC OOTB and only create extensions if there is a business value to it. They need to be mantained etc.
 


Permanent link
Thanks Ralph,

Can we create dynamic query with the help of REST API (https://localhost:9443/ccm/rpt/repository). So here i can provide input Start Date, End Date of current work item.
By Http Value Set Provider I will get result in form of XML, will store this in 3 hidden attributes.

Status is calculated by Calculated Value Set Provider, i will manipulate the result by this 3 hidden attributes.
Is that possible Ralph?

But, I am stuck-up to getting custom attribute value by REST API.
[Working]
https://localhost:9443/ccm/rpt/repository/workitem?fields=workitem/workItem/(id|summary|startdate|enddate)
[Not Working]
https://localhost:9443/ccm/rpt/repository/workitem?fields=workitem/workItem/(id|summary|startdate|enddate)
Please help Ralph

0 votes

Comments

Sorry Vivek, OSLC is not the area I have invested a lot of time so far. Here is a post from Jorge, who did:

http://jorgediazblog.wordpress.com/2012/06/27/work-item-customization-httpconector-and-oauth-in-rtc-4-0-for-oslc/

Maybe others with more OSLC knowledge can help too?


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.

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
× 12,022

Question asked: Aug 21 '12, 6:55 a.m.

Question was seen: 6,204 times

Last updated: Nov 06 '12, 10:25 a.m.

Confirmation Cancel Confirm