How to show only last runs of a test case in a traceability report?

[PW_10873009]

Hi community,

I have the following configuration (codeBeamer 2.2.1.0.4).

This gives the following result.

Now, I only would like to see the latest run of this test case.

How can this be done in the configuration?

Or is there any other possibility to manage this?

Thanks in advance.

Best regards.

Pascal

[Catalina]

Hi @PW_10873009 

Thank you for your question. 

Your post appears well documented but has not yet received any response. I am replying to raise awareness. Hopefully, another community member will be able to help.

Also, feel free to add any additional information you think might be relevant.

Best regards,

[EA_10840595]

Hi  - i am not from ptc - so not an "official" solution. We do it with 2 calculated fields on the testcase,

the first gets the ID of the latest testrun (basically just the one with the highest ID) and the 2nd field fetches the result of the item with that ID.
Formulas: 

to get the ID of the latest run: "Last Formal Run ID" = max ( distinct (downstreamReferences.trackerTypes('TestRun').{item | ((item.resolutions[0].id <= 4 ) && ( item.formality.name == 'Formal' ) ) ? item.id : null } ) )

to get the result of  that testrun: lastFormalRunID > 0 ? Item(lastFormalRunID).resolutions[0].name : 'No Run'''

This way you can display the last formal run in a traceability table. 

if you need not just the result of the formal run, you can remove the condition in the formula of Last Formal Run ID field. if there is no run, the formula returns 0, that is why we have the condition in the 2nd formula. 

[pgirkar · Accepted solution]

Filter test cases by their last run result in a Codebeamer report.

You can explore the following options:

• Test Cases by Last Run Result Plugin
  This plugin allows you to visualize the latest run result for each test case in a table or chart format.
• Custom Computed Field
  You can also try to create a computed field in the test case tracker to pull the latest result from associated test runs.
• Example formula:
• first(1, downstreamReferences(this).trackerTypes("testrun").{item | item.resolutions[0].name})