Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Clean command flag revisions without environment as deleted #1088

Open
Davidmattei opened this issue Dec 4, 2024 · 0 comments
Open

Clean command flag revisions without environment as deleted #1088

Davidmattei opened this issue Dec 4, 2024 · 0 comments
Labels
bug Something isn't working enhancement New feature or request

Comments

@Davidmattei
Copy link
Member

Davidmattei commented Dec 4, 2024

The clean command should flag revisions that are not linked to any environment as deleted.

Test query;

select distinct concat(c.name, ':', r.ouuid) as emsLink 
from revision r
join content_type c on c.id = r.content_type_id
where r.ouuid not in (
    select r.ouuid from revision r
    join environment_revision er on r.id = er.revision_id
    group by r.ouuid
) and r.deleted is false;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working enhancement New feature or request
Projects
Status: Todo
Development

No branches or pull requests

1 participant