▣ wi

vUserActiveRoles view: consolidate userRoles+vLookupOptions JOIN repeated at users-actions.ts:164/169/230 + data-health-actions.ts:58 + self-service-assignment.ts:51 — return userId, roleValues[], roleLabels[] (filtered deletedAt IS NULL)

Ref

#188 (#188)

Project

mars

Parent

backlog #174 Vercel + Supabase optimization — reduce Fluid Active CPU bill creep, eliminate dashboard misconfig, lower latency

Status

done

Priority

normal

Type

task

Assigned

—

Created by

—

Created

2026-05-03T02:29:31.736Z

Updated

2026-05-18T09:58:25.917Z

Closed

2026-05-18T09:58:25.917Z

Sub-items

Questions

Event log

• 2026-05-03T02:29:31.786Z · created
  wi cli; parent=#174
• 2026-05-03T02:30:09.662Z · note
  Audit-3414: auth.ts repeat-JOIN sites (113-118, 157-162) are inside React-cached getSession, effectively free. View benefit narrows to non-cached admin paths (users-actions, data-health, self-service-assignment).
• 2026-05-18T09:58:25.918Z · completed
  vUserActiveRoles view consolidation + roleId→roleOptionId latent-bug fix (v1.100.1 689cbcb PASS)