To identify testcases mapped to testexecution based on Test label

[rajm]

Hi Everyone,

I am trying to find the count of testcases mapped to test execution based on the label (e.g UI_Functional, UI_Regression). Can you please help with the measure. i have created a custom field as below

[jira.customfield_11111]
name=“Tests association with a Test Execution”
dimension = true
multiple_values = true
data_type=“string”
split_by=","

thank you very much in advance
Raj

[zane.baranovska]

Hi @rajm,

This is quite an ambiguous use case and the solution is based on the source data.

1. From the code example, I understand that you have Jira. Do you also use any testing apps, for example, Xray?
2. How Tests and Test Executions are mapped in Jira? Do you use issue links or some custom fields?
3. Have you already built a report that you are looking forward to improving with the Label filter?

Best,
Zane / support@eazyBI.com

[rajm]

HI Zane,

thanks for the reply.

1. Yes . I use xray for test management
2. I use custom links.
   customfield id = “custmofield_11222”
   customfieldname>Test association with a TestExecution</customfieldvalue
   custmofieldvalues
   customfieldvalue>[ABC-2821, ABC-2822, ABC-2823]</customfieldvalue
   /customfieldvalues
3. I have used a measure which is counting the testcases based on the label in test execution instead of label on Tests
   ([Measure].[Xray Test Runs],[Label].[UI_Regression])

thanks in advance for your help
Raj

[zane.baranovska]

Thanks, @rajm, for additional information!
Xray test run-related measures like “Xray Test Runs” are grouped by Test Execution fields by default (see documentation: Xray Test Management).

However, you can create a calculated measures (in Measures section) to change the relation of the “Label” dimension and measure “Xray Test Runs”.

The expression might look like this:

Sum(
 --filter set of Tests
 Filter(
  Descendants([Xray Test].CurrentMember,[Xray Test].[Test]),
  --Test issue has selected Label
  DefaultContext((
   [Measures].[Xray Tests created],
   [Xray Test].CurrentHierarchyMember,
   [Label].CurrentHierarchyMember
  )) > 0 ),
 --sum up test runs ignoring Component assigned to Test Execution
 ([Measures].[Xray Test Runs],
 [Label].CurrentHierarchy.DefaultMember)
)

Here are few more topics on similar use cases how to analyse Xray test runs by Test fields, not Test Execution fields:

Beginner Question: XRAY and components

Here is a more universal expression for calculated measure to get Xray Test Runs by the Component of Test and other fields associated with Test Execution issues and test run results. Sum( --filter set of Tests Filter( Descendants([Xray Test].CurrentMember,[Xray Test].[Test]), --Test issue has selected Component DefaultContext(( [Measures].[Xray Tests created], [Xray Test].CurrentHierarchyMember, [Component].CurrentHierarchyMember )) > 0 ), --sum up test runs ignoring Compone…

XRay Test repository: amount of created tests vs. tests with an execution

Hi, There is a specific behavior of the Xray Tests with executions if used with the Priority dimension in eazyBI. Each test is counted for each priority of the Test executions. The result is that test is counted the number of times of the execution when Priority (and other Jira standard dimensions) is used. I added this issue to our backlog for evaluation if any fix might be needed. The workaround for your use case is to create a custom calculation with the following formula: NonZero(Count( …

[rajm]

Hi Zane,

thanks for the reply .
It worked and provided the count of tests for the label selected as expected.

However, when clicked on the “Drill through Issue” even on small count, i was not able to view the tests details.
I received the error popup “There was error when performing your request. Please retry or go to other page.”

Is this related to increasing the heap memory?.

thanks in advance
Raj

[rajm]

@zane.baranovska
thanks for the reply .
It worked and provided the count of tests for the label selected as expected.
However, when clicked on the “Drill through Issue” even on small count, i was not able to view the tests details.
I received the error popup “There was error when performing your request. Please retry or go to other page.”

Can you please suggest how i could see the test details using “Drill through Issue” .

thanks
Raj

[gustavo_salvato]

Hi @zane.baranovska , I have a similar situation,.
I need to obtain all Xray Test Executed of every Xray Test Plan with label “Sportbooks-Performance”. I’m using it Label as Pages.
I´m using eazy for jira and Xray.

Can you please help me?

Regards,
Gustavo

[zane.baranovska]

Hi,

eazyBI has a new functionality for Xray data. Now, you can import Test fields as separate dimensions to group and filter test runs and executions using Test fields without complex calculations (this improves report performance). The feature is available on Cloud and since eazyBI version 7.2.

1. Go to import options, tab Add-ons, and import the Label of the Test issue.
   

   

2. In the report, use the new dimension “Xray Test Label” with predefined measure “Xray test Runs”.
   

   

Visit the documentation for more details: Xray Test Management.

Best,
Zane / support@eazyBI.com