Skip to content

viewField records not soft-deleted when parent view is deleted #16526

@mydalat

Description

@mydalat

Description:
Problem
When deleting a view in Twenty CRM, the parent view record is soft-deleted (deletedAt is set), but the related viewField records remain active (deletedAt = NULL).
This creates orphan records in the database.
Steps to Reproduce

Create a custom view (e.g., KANBAN view for People)
Delete the view from UI
Check database:

`-- View is soft-deleted
SELECT id, name, "deletedAt" FROM core.view WHERE id = '<view_id>';
-- deletedAt = '2025-12-12 12:59:55'

-- But viewFields still active
SELECT count(*) FROM core."viewField" WHERE "viewId" = '<view_id>' AND "deletedAt" IS NULL;
-- count = 23
`

Expected Behavior

When a view is soft-deleted, all related child records (viewField, viewFilter, viewSort, viewGroup, viewFilterGroup) should also be soft-deleted.

Workaround
Manual cleanup:

UPDATE core."viewField" SET "deletedAt" = NOW() WHERE "viewId" = '<view_id>' AND "deletedAt" IS NULL;

Environment

Twenty version: v1.12.0
Database: PostgreSQL (twenty-postgres-spilo)

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    Status

    🔖 Planned

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions