How to Combine 2 Queries in RTC without using JRS
The clarification is to have 2 queries combined as my requirement is not fulfilling with one query.
As per our workflow, we have the current Query
Type is Status is Testing Required
Defect Development Yes
The Query is fetching the below Results.
Id State Testing Required Affects Plan Item
Defect1 Development Yes CR1
Defect2 Development Yes CR2
Defect3 Development Yes CR3
From the result, it is necessary to mouse hover each of the Defect to check the Linked Worktime CR and to check the state under Links Related CR.
The expected query is to have
Type is Status is Testing Required Affects Plan Item State
Defect Development Yes New
Somehow I am not able to see the CR State related condition in the Query . If there is a way where in I can send the result of Query 1 and process Query 2 for the specific CR state.
Any thoughts ?
|
One answer
Ralph Schoon (63.5k●3●36●46)
| answered Apr 04 '22, 2:55 a.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER As far as I can tell, the work item query mechanism does not allow to display data of linked work items. So, for all I can tell this is not possible using EWM queries. Only the reporting capabilities provide this. As far as I can tell, you can display reports in dashboards, so I would suggest to try that. |
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.