Hi,
How do i create a report in eazyBI for the below JQL query,
I need to get the test cases status which has components from test plan Test-6,
issuetype = Test AND issue in (testPlanTests(Test-6)) AND component in (SU, SC, SO, GE, CD)
Hi @enthusiasm19851,
The Xray dimensions as Tests and Test Plans are linked by the specific Xray measures - “Xray tests created” etc.
The Xray tests hold the details of their issue status and their last execution status as properties.
If you want to apply the filter on Test Plans and components and only display the status of the Test or the status of the last execution of that test - you might wrap the retrieval of status within the condition of relevance to the report context.
The expression to retrieve the last execution status of Xray Test based on the Test plan (used as a dimension on report pages or rows) and Component (used as a dimension on report pages or rows) might be as follows.
CASE WHEN
--the context is relevant
[Measures].[Xray Tests created]>0
THEN
--retrieve status of test
[Xray Test].CurrentMember.Get('Xray Last execution status')
END
However, more details are needed to provide you with the best solution.
Please contact support directly over e-mail with more details, such as the used test app and the status you are looking for—test Plan status, Test execution status, or Test status. Should the components be taken from the test plan or the test itself?
A more detailed question would allow a more precise answer.
Regards,
Oskars / support@eazyBI.com