CBQL query to check test case vs test run modified dates?

[PeteG2024]

Does anyone know how to create a codebeamer report or cbql query which does the following?

For Test Runs in a Test Run tracker, compare the modifiedAt field with the corresponding Test Case modifiedAt field, to generate a report of test runs that are out-of-date (i.e. the test case has been modified more recently than the the test-run, so the test-run may need to be re-run)

[EvaBertalan · Accepted solution]

Hello @PeteG2024 ,

This is the closest solution I've found:

[PeteG2024]

Yes I found the same, thanks. I was hoping there might be a Cbql query to do it and just list where TestCase.modifiedAt > TestRun.modifiedAt,  but can't find enough information on those to progress any further.