Custom report for latest test results per release

In order to get the current state of test case execution in specified release, an ESQL query is required. Is there a way to obtain data about all the latest test execution results for all the test sets that have specific release selected? Couple of notes:

• If a test case belongs to a test set marked with specific release, then latest execution result per that release is required
• If a test case belongs to a test set marked with specific release and test case has not been executed per that release, it should be marked as such
• Just a couple defining properties of the test case will be sufficient (TR.TEST_CASE_ID, TR.NAME, TR.RELEASE_ID)
• Release should be selectable in Custom Section Filter