Duplicate Database Query in Test Runs API Endpoint

[soumojit-D48]

Bug Description

The GET /workflows/:workflowId/test-runs/:id endpoint makes two separate database queries when fetching a single test run - one for authorization check and one for retrieving the data. This is inefficient and can be optimized to use a single query.

To Reproduce

1. Make a GET request to /workflows/:workflowId/test-runs/:id endpoint
2. Observe that two database queries are executed:
   • First query: findOne in getTestRun() method for authorization
   • Second query: getTestRunSummaryById() to fetch the data with relations

Expected behavior

The endpoint should fetch the test run with a single database query that also handles authorization check.

Add a new repository method getTestRunSummaryByIdWithAuthorization that combines:

1. Fetching the test run with relations (testCaseExecutions)
2. Authorization check against allowed workflow IDs
3. Calculation of finalResult

This reduces the endpoint from 2 database queries to 1.

Debug Info

The issue is in:

• packages/cli/src/evaluation.ee/test-runs.controller.ee.ts - Line 57 (before fix)
• packages/@n8n/db/src/repositories/test-run.repository.ee.ts - getTestRunSummaryById method

Operating System

Windows (development environment)

n8n Version

2.12.0

Node.js Version

24.14.0

Database

SQLite (default)

Execution mode

main (default)

Hosting

self hosted

[n8n-assistant]

Hey @soumojit-D48,

Thank you for reaching out! We’ve received your issue and are looking into it. To help us track this internally, we’ve created a Linear ticket with the reference: "GHC-7258".

We’ll keep you updated as we make progress, but if you have any additional details or context to share, feel free to add them here - it’s always helpful!

Thanks for your patience and for bringing this to our attention.

---

For INTERNAL use only: GHC-7258

[dev-kinsukghosh]

I think that intended
Let me ask internally

[dev-kinsukghosh]

ok that not intented