v1.7.27 - Fix compliance API 500 error

Bug Fix

Fixed: Overview tab showing "No Compliance Scans Yet"

The /api/v1/compliance/scans/:hostId/latest-by-type endpoint was returning a 500 error due to a raw SQL query issue.

Root Cause: The $queryRaw with ${hostId}::uuid cast was failing in Prisma.

Fix: Rewrote the endpoint to use standard Prisma findMany instead of raw SQL.

Action Required

Restart your backend server after updating to apply this fix.

---

🤖 Generated with Claude Code