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
|
Accepted answer
![]()
Ralph Schoon (63.3k●3●36●46)
| answered Aug 21 '12, 7:21 a.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER edited Aug 21 '12, 7:21 a.m.
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
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
![]()
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.:) 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.
|
![]()
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 ![]() 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 ![]() Comments ![]() FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER
Sorry Vivek, OSLC is not the area I have invested a lot of time so far. Here is a post from Jorge, who did:
|
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.