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