The previous query was just effectively finding any evaluation id
[!IMPORTANT]
Fix query in POST function in route.ts to correctly associate evaluation labels with the correct evaluation ID using a join and filtering by resultId and projectId.
Behavior:
Fix query in POST function in route.ts to correctly associate evaluation labels with the correct evaluation ID.
Uses innerJoin and filters by resultId and projectId to find matching evaluations.
Misc:
Adds a TODO comment to optimize the query by using a subquery instead of a join.
This description was created by for 7d0478b383209f61694b4bd60eabdc40e222b88c. It will automatically update as commits are pushed.
The previous query was just effectively finding any evaluation id