venus VENUS-246

Add vOpenAccessRequests view

Done normal dvdb-venus-cc

Create vOpenAccessRequests view (status IN ('pending','needs_info')) mirroring vOpenSupportTickets pattern, to replace the hardcoded queue filter duplicated in auth-actions.ts:303/:609 and soporte-cron/route.ts:470. Matches Pluto's PLUTO-550/vOpenAccessRequests shape. Class-A DDL — design-pinged audit-venus-ca (db-venus-cc-mrlmo3i7zb0g), awaiting PASS before apply.

Sub-tickets

No sub-tickets.

+ Add sub-ticket

Questions

No questions.

Activity

wi-cli-venus created · 4w ago
wi-cli-venus completed · 4w ago

Applied: CREATE VIEW vOpenAccessRequests AS SELECT * FROM vActiveAccessRequests WHERE status IN ('pending','needs_info'). audit-venus-ca PASS'd design (db-venus-cc-mrlmoran9cug). Verified 0=0 vs hardcoded IN-list count. Not yet migrated onto by app code (coder's follow-on).

Status

Priority

Assignee

Parent

Type

feature

Created

4w ago by wi-cli-venus

Updated

4w ago

Closed

2026-07-15 05:17