# Question - delete all Legacy Views
**URL:** https://discussions.eramba.org/t/question-delete-all-legacy-views/6505
**Category:** Forum - Software
**Tags:** question
**Created:** [April 1, 2025, 2:57pm UTC](https://discussions.eramba.org/t/question-delete-all-legacy-views/6505 "2025-04-01T14:57:28Z")
**Posts on this page:** 15
**Page:** 1
### Author:  [@Embezzle](https://discussions.eramba.org/u/Embezzle)
#### Post date: [April 1, 2025, 2:57pm UTC](https://discussions.eramba.org/t/question-delete-all-legacy-views/6505/1 "2025-04-01T14:57:28Z")
The new UI is very much appreciated and results in much better adoption among non-techy users that are part of our GRC processes. Is it possible though to delete all the legacy views that are not tied to notifications or reports? As administrator I went through all modules and deleted the legacy views only to find out that these were only deleted for my profile while still being visible to all remaining users.
Is it possible to delete them somehow for all users?
---
### Author:  [@sam](https://discussions.eramba.org/u/sam)
#### Post date: [April 2, 2025, 7:56am UTC](https://discussions.eramba.org/t/question-delete-all-legacy-views/6505/2 "2025-04-02T07:56:40Z")
Hello,
Unfortunately, in the previous version, filters were created per user. This means that each user will have those legacy filters.
I’ll check if there’s a query you can run to remove them completely.
---
### Author:  [@Embezzle](https://discussions.eramba.org/u/Embezzle)
#### Post date: [April 3, 2025, 1:21pm UTC](https://discussions.eramba.org/t/question-delete-all-legacy-views/6505/3 "2025-04-03T13:21:30Z")
Thank you, that is very much appreciated!
---
### Author:  [@sam](https://discussions.eramba.org/u/sam)
#### Post date: [April 7, 2025, 1:12pm UTC](https://discussions.eramba.org/t/question-delete-all-legacy-views/6505/4 "2025-04-07T13:12:54Z")
I contacted you over support email.
---
### Author:  [@divadnagrom](https://discussions.eramba.org/u/divadnagrom)
#### Post date: [April 11, 2025, 1:54am UTC](https://discussions.eramba.org/t/question-delete-all-legacy-views/6505/5 "2025-04-11T01:54:57Z")
Is there a way this can be shared for the rest of us who see the same issue?
Thanks
---
### Author:  [@sam](https://discussions.eramba.org/u/sam)
#### Post date: [April 11, 2025, 8:30am UTC](https://discussions.eramba.org/t/question-delete-all-legacy-views/6505/6 "2025-04-11T08:30:12Z")
This can only be done directly in the database.
Please proceed **only if you are 100% sure** of what you’re doing.
```auto
delete from filters
where advanced_filter_id is not null
and id not in (
select filter_id from notification_system_items
where filter_id is not null
)
and id not in (
select filter_id from report_block_filter_settings
where filter_id is not null
);
```
---
### Author:  [@Embezzle](https://discussions.eramba.org/u/Embezzle)
#### Post date: [April 14, 2025, 2:39pm UTC](https://discussions.eramba.org/t/question-delete-all-legacy-views/6505/7 "2025-04-14T14:39:16Z")
Thank you, that worked really well. I checked the affected filters and users beforehand with the following SQL query. Good to have a rough idea what you’re about to delete.
```auto
select f.name as "filter name", u.email as "user email" from filters f
join users u ON f.user_id = u.id
where f.advanced_filter_id is not null
and f.id not in (
select filter_id from notification_system_items
where filter_id is not null
)
and f.id not in (
select filter_id from report_block_filter_settings
where filter_id is not null
);
```
---
### Author:  [@Ovidiu](https://discussions.eramba.org/u/Ovidiu)
#### Post date: [May 12, 2025, 7:38am UTC](https://discussions.eramba.org/t/question-delete-all-legacy-views/6505/8 "2025-05-12T07:38:13Z")
I tried deleting these Legacy Views as explained, but I am wondering why a new employee who was just hired and logged in for the first time now also has Legacy Views?
Am I going to have to delete these legacy views every time I have a new user in Eramba or am I misunderstanding something?
---
### Author:  [@sam](https://discussions.eramba.org/u/sam)
#### Post date: [May 13, 2025, 7:40am UTC](https://discussions.eramba.org/t/question-delete-all-legacy-views/6505/9 "2025-05-13T07:40:31Z")
Yes, I think there was a misunderstanding.
Legacy views were copies of custom filters created by users in the old UI.
A new user will only have the default set of views — no legacy views will be available for them.
---
### Author:  [@Ovidiu](https://discussions.eramba.org/u/Ovidiu)
#### Post date: [May 13, 2025, 7:55am UTC](https://discussions.eramba.org/t/question-delete-all-legacy-views/6505/10 "2025-05-13T07:55:19Z")
Hm, that is weird.
We used the above code to delete legacy views. After that, it seemed that if a user had not yet logged in after the upgrade to the new Eramba UI, legacy views would be created after they logged in for the first time with the new UI.
I then asked all my existing users to log in once, and a few days later, when I ran the code above again, I saw legacy views for a user who has just started our company show up. Like this user account didn’t even exist before we upgraded to the new Eramba UI.
Anyway, I will check the output of the above code again, after the next employee starts and let you know if I see legacy views again.
---
### Author:  [@sam](https://discussions.eramba.org/u/sam)
#### Post date: [June 2, 2025, 7:42am UTC](https://discussions.eramba.org/t/question-delete-all-legacy-views/6505/11 "2025-06-02T07:42:04Z")
Starting from [release 3.26.4](https://discussions.eramba.org/t/release-3-26-4-hotfix-not-yet-released/6904), you can do this directly from the user interface.
You’ll find the option under **Settings \> Remove Legacy Views**.
Of course, any views that are pinned or used in notifications or reports will not be removed.
The modal will show you how many views are going to be deleted.
This may also help improve the system’s performance a bit.
---
### Author:  [@Ovidiu](https://discussions.eramba.org/u/Ovidiu)
#### Post date: [July 8, 2025, 9:59am UTC](https://discussions.eramba.org/t/question-delete-all-legacy-views/6505/12 "2025-07-08T09:59:23Z")
I just realized that the last minor update brought all Legacy views back.
I have now removed them using: **Settings \> Remove Legacy Views**
> Check if you are really sure to remove legacy views migrated from the previous user interface. This action will remove 3250 legacy view(s). Views that are pinned or used in notifications or reports will not be deleted.
I hope they won’t be back with the next update.
---
### Author:  [@david.davis](https://discussions.eramba.org/u/david.davis)
#### Post date: [July 8, 2025, 2:06pm UTC](https://discussions.eramba.org/t/question-delete-all-legacy-views/6505/13 "2025-07-08T14:06:25Z")
Mine keep coming back! I had over a quarter of a million of them last time I ran Settings \> Remove Legacy Views.
Eramba Support are looking into it 🙂
---
### Author:  [@kisero](https://discussions.eramba.org/u/kisero)
#### Post date: [July 14, 2025, 8:51am UTC](https://discussions.eramba.org/t/question-delete-all-legacy-views/6505/14 "2025-07-14T08:51:02Z")
> [@Ovidiu](#):
>
> I just realized that the last minor update brought all Legacy views back.
yes, we messed something up, we are aware of it we are on it for the next release
sorry guys
---
### Author:  [@sam](https://discussions.eramba.org/u/sam)
#### Post date: [July 17, 2025, 10:04am UTC](https://discussions.eramba.org/t/question-delete-all-legacy-views/6505/15 "2025-07-17T10:04:07Z")
We’ve just published version 3.26.6, which will hopefully fix this issue.
Thanks for your patience and for reporting it.