Release Notes

QualityChecks Release Notes - v1.5.0

Release Status

Version 1.5.0 updates the My Work section of the site to match the intended role-based access and queue behavior. This release corrects visibility rules, hardens the My Submissions and My Evaluations filters, fixes the page icon mismatch, and includes CDR workflow fixes.

This release includes:

• Hardened My Work access so My Submissions is visible to designers, editors, managers, and admins.
• Hardened My Work access so My Evaluations is visible to editors, managers, and admins.
• Updated row filtering so designers only see their own submissions and finalizer-owned finalizing rows.
• Updated row filtering so editors see all active rows in Intro, Finalizing, Proofer Changes, and Association Changes queues.
• Updated row filtering so editors only see in-progress evaluations where they are assigned in the canonical proofer_id field on the main evaluations table.
• Corrected the evaluation queue contract so all evaluation checks use the stored proofer_id value instead of the frontend-only reviewer/verifier labels.
• Aligned the finalizing evaluation database constraint so Finalizing rows only permit In Progress or Completed, matching the app’s intended status behavior.
• Updated the finalizing evaluation creation path to keep Finalizing rows on the valid Completed/In Progress status contract instead of reintroducing the legacy status mapping.
• Parallelized independent PostgREST lookups and sync work in the creation, save, and edit flows to reduce unnecessary latency without changing business behavior.
• Kept manager and admin views as broader active/in-progress queues instead of person-scoped filters.
• Fixed CDR preview so the Q&A Cover Submission field resolves to the related cover_submission_name value instead of showing the CDR submission id.
• Added CDR lifecycle synchronization so saving a CDR as Approved or Verified marks sibling CDR rows for the same cover submission as Inactive.
• Backfilled the public CDR queue data so CDR-000029 is inactive after CDR-000030 was approved.
• Removed My Submissions and My Evaluations from the configurable sidebar access picker and fixed their role access directly in the nav metadata.
• Restored the My Work sections for impersonated roles by ensuring the hardcoded routes remain available in the impersonation sidebar route map.
• Corrected the page icons so My Submissions and My Evaluations match their sidebar icons exactly.

Summary

QualityChecks v1.5.0 aligns the My Work section with the approved business rules for page access and queue scoping, and closes remaining CDR workflow gaps discovered during verification. The result is a cleaner, more predictable experience for designers, editors, managers, and admins.

Included in v1.5.0

My Work Access Rules

• My Submissions is available to designers, editors, managers, and admins.
• My Evaluations is available to editors, managers, and admins.
• The pages are no longer configurable as optional sidebar tabs in the role access picker.
• Their role lists are now fixed to the intended access model rather than being treated as generic custom sidebar permissions.

My Submissions Queue Behavior

• Designers see the submissions where they are listed as the designer.
• Designers also see finalizing submissions where they are the finalizer.
• Extra roles such as intro reviewer or cover reviewer no longer change the designer queue behavior.
• Editors, managers, and admins see all active submissions in the queue.

My Evaluations Queue Behavior

• Editors see in-progress evaluations where they are assigned in the canonical proofer_id field on the main evaluations table.
• When an evaluation is saved as In Progress, the save path now persists that assigned proofer_id alongside the status so the queue can match the signed-in editor correctly.
• Reviewer and verifier labels are display names only; they do not represent separate assignment fields in the underlying data model.
• Completed or submitted evaluations remain excluded from the queue.
• Managers and admins see all in-progress evaluations.

My Work Page Icon Consistency

• The page-header icon for My Submissions now matches the sidebar folder icon.
• The page-header icon for My Evaluations now matches the sidebar clipboard icon.

Cover Design Review Workflow

• The CDR preview Cover Submission field now shows the related cover_submission_name value.
• When a CDR is saved as Approved or Verified, sibling CDR rows for the same cover submission are now marked Inactive automatically.
• Existing public data was backfilled so CDR-000029 is now Inactive after CDR-000030 was approved.

Fixed in v1.5.0

• Fixed incorrect visibility for My Work pages across role combinations.
• Fixed designer and editor queue filtering so submission tables follow intended scope rules: designer queues are user-scoped, while editors can view all active rows in Intro, Finalizing, Proofer Changes, and Association Changes.
• Fixed the My Evaluations row filter to honor the canonical assignment field in the main evaluations table (proofer_id) instead of relying on UI labels such as reviewer or verifier.
• Fixed the evaluation save path so in-progress drafts persist the assigned proofer_id, ensuring the editor queue matches the correct user instead of leaving rows effectively unassigned.
• Corrected the database check constraint for Finalizing evaluations so the stored status set matches the app’s intended contract: In Progress or Completed only.
• Normalized affected legacy Finalizing rows to Completed before enforcing the stricter database rule in both runtime schemas.
• Fixed the Finalizing creation flow so new rows are inserted using the valid finalized status contract instead of the legacy No Additional Edits Needed mapping that violated the database rule.
• Optimized the creation, save, and edit flows by parallelizing independent PostgREST lookups and sync work to remove avoidable serial wait time without changing business behavior.
• Backfilled affected in-progress evaluation rows with the correct editor assignment so the queue reflects the approved business rules immediately.
• Fixed CDR preview mapping so Cover Submission no longer displays the submission id when a related cover submission name exists.
• Fixed CDR lifecycle handling so approved/verified CDR submissions automatically inactivate sibling rows for the same cover submission.
• Backfilled CDR queue data by marking CDR-000029 inactive in the public schema.
• Fixed impersonation sidebar scoping so editor and designer accounts still retain the My Work section when logged in as another user for debugging.
• Fixed page icon mismatch between the sidebar and page header.
• Fixed the My Work role configuration so the pages are intentionally hardcoded rather than exposed as optional sidebar permissions.

Upgrade Notes

• Finalizing evaluation status validation was updated in both runtime schemas to match the app’s intended behavior.
• Existing legacy Finalizing rows were normalized to Completed where needed before enforcing the stricter database constraint.
• The Finalizing creation and save paths were aligned with the valid Completed/In Progress contract so new rows do not trigger the same database validation failure.
• The creation, save, and edit flows were optimized by parallelizing independent PostgREST lookups and sync work to reduce unnecessary latency while preserving the same business behavior.
• No Power Automate changes.
• No migration step required for the app logic update.

---