Skip to Content (Press Enter)
Back to Ideas
18
Like
Follow Idea
Data CleanUp from Entity
1704Views
19Comments
On our RadarOn our Radar
Backend

Hi Team,


Please gives us option to delete test data from entity directly from entity.


Thanks1

07 Sep 2018
Copy link to comment
Changed the category to
Backend
01 Jan 2019
Copy link to comment
Merged this idea with 'Option to empty Entity/Table from within Service Studio' (created on 26 Aug 2019 13:29:02 by Vincent Koning)
27 Aug 2019
Copy link to comment

During development I sometimes find the need to clear all related entities of the project I'm working on. This because I need to change a datamodel or because I finally got the excel file with actual data that I can use in my app (I filled in bogus data during a Proof of Concept for instance).

Right now I need to do a lot of manual actions to empty the entities in questions (hosted environment, no access to DB) and this could be made a lot easier if I can right click an entity and select a "Delete All" option. 



This comment was:
- originally posted on idea 'Option to empty Entity/Table from within Service Studio' (created on 26 Aug 2019 by Vincent Koning)
- merged to idea 'Data CleanUp from Entity' on 27 Aug 2019 10:13:09 by Ângela Dinis
26 Aug 2019
Copy link to comment
Changed the category to
Backend
and the status to
On our RadarOn our radar

Hi Vincent,

Thank you so much for your idea!

I'm marking your idea as "On our radar" because we actually think it's a good idea! Let's also see what the rest of the community thinks about it! :-)

Have a nice week,

Ângela



This comment was:
- originally posted on idea 'Option to empty Entity/Table from within Service Studio' (created on 26 Aug 2019 by Vincent Koning)
- merged to idea 'Data CleanUp from Entity' on 27 Aug 2019 10:13:09 by Ângela Dinis
26 Aug 2019
Copy link to comment

Hi, in fact is a good idea but there is already other that propose it 

consider to merge it


https://www.outsystems.com/ideas/5413/data-cleanup-from-entity

Regards 



This comment was:
- originally posted on idea 'Option to empty Entity/Table from within Service Studio' (created on 26 Aug 2019 by Vincent Koning)
- merged to idea 'Data CleanUp from Entity' on 27 Aug 2019 10:13:09 by Ângela Dinis
27 Aug 2019
Copy link to comment
Changed the status to
On our RadarOn our radar

Hi JitendraYadav,

Your idea makes sense, and it is now "On our radar" until we're able to check if other community members would also find this feature useful :-)

Thank you so much!

Have a nice week,

Ângela

27 Aug 2019
Copy link to comment
Merged this idea with 'Have option to clean all test data' (created on 08 Oct 2018 08:55:16 by Mykola (Nick) Tkachenko)
27 Aug 2019
Copy link to comment

It causes troubles when deploying to upper environment "test data" from "view data. it would be good to either have option to remove all filters and other test data for entities "view data" or automatically clean it on deploying.



This comment was:
- originally posted on idea 'Have option to clean all test data' (created on 08 Oct 2018 by Mykola (Nick) Tkachenko)
- merged to idea 'Data CleanUp from Entity' on 27 Aug 2019 10:23:00 by Ângela Dinis
08 Oct 2018
Copy link to comment

Hi Mykola,


Thank you for the feedback!


Could you please clarify your use-case? Perhaps with an example?



This comment was:
- originally posted on idea 'Have option to clean all test data' (created on 08 Oct 2018 by Mykola (Nick) Tkachenko)
- merged to idea 'Data CleanUp from Entity' on 27 Aug 2019 10:23:00 by Ângela Dinis
08 Jan 2019
Copy link to comment

Hi Stoyan,

For example one of developers used "view data" option and added a filter by specific Id to verify some changes in db and didn't remove it after. After deployment to next environment it causes warnings that may be time consuming to fix if you don't know exactly where to look at.



This comment was:
- originally posted on idea 'Have option to clean all test data' (created on 08 Oct 2018 by Mykola (Nick) Tkachenko)
- merged to idea 'Data CleanUp from Entity' on 27 Aug 2019 10:23:00 by Ângela Dinis
08 Jan 2019
Copy link to comment
Changed the category to
Aggregates & Queries

Thank you for the clarification, Mykola.



This comment was:
- originally posted on idea 'Have option to clean all test data' (created on 08 Oct 2018 by Mykola (Nick) Tkachenko)
- merged to idea 'Data CleanUp from Entity' on 27 Aug 2019 10:23:00 by Ângela Dinis
09 Jan 2019
Copy link to comment

Hi Team,


Any update?


Thanks

20 Apr 2020
Copy link to comment
Merged this idea with 'Add a Functionality to Drop Unused Entity Tables in Each Module' (created on 18 Jun 2021 16:14:02 by Varada Rajan)
19 Jun 2021
Copy link to comment

I post this Idea To Implement 'Drop Unused Tables' functionality in the Studio tools for Each Module that Carries Data Entities.

when there is an Change in the database Entities,

Developer needs to Drop the Unused Entity Tables Explicitly From the Environment,which is a kind of Extra task and there is a chance for unnecessary data to be loaded on Database in case of forgetting to Drop the tables.

This would be as comfortable to add a new Row Data in the Studio and save it with a button Click.



This comment was:
- originally posted on idea 'Add a Functionality to Drop Unused Entity Tables in Each Module' (created on 18 Jun 2021 by Varada Rajan)
- merged to idea 'Data CleanUp from Entity' on 19 Jun 2021 14:26:06 by Justin James
18 Jun 2021
Copy link to comment
Merged this idea with 'Database cleanup' (created on 10 Oct 2018 10:39:40 by Nuno Fernandes)
19 Jun 2021
Copy link to comment

With the grow of the factory is very important to keep our databases clean and with performance.

I would like to have a tool that show us all columns and tables that are not used and that help us to hard delete them.

This hard delete should drop the tables from database and cleanup the outsystems metadata.





This comment was:
- originally posted on idea 'Database cleanup' (created on 10 Oct 2018 by Nuno Fernandes)
- merged to idea 'Data CleanUp from Entity' on 19 Jun 2021 14:26:47 by Justin James
10 Oct 2018
Copy link to comment

There are tools available on the forge that do this already.

Take a look at DBCleaner and OneClickCleanup.

They make use of the DbCleaner API that is bundled with OutSystems.


Here is a list of the APIs available with OutSystems.




This comment was:
- originally posted on idea 'Database cleanup' (created on 10 Oct 2018 by Nuno Fernandes)
- merged to idea 'Data CleanUp from Entity' on 19 Jun 2021 14:26:47 by Justin James
11 Oct 2018
Copy link to comment
Changed the category to
Database


This comment was:
- originally posted on idea 'Database cleanup' (created on 10 Oct 2018 by Nuno Fernandes)
- merged to idea 'Data CleanUp from Entity' on 19 Jun 2021 14:26:47 by Justin James
25 Nov 2018
Copy link to comment
2020-03-16 13-52-40
Daniel Eugénio

Hi there!

This idea was already implemented in Service Studio.

One can easily select multiple records from an entity, on the aggregate view, and delete them.


Thanks,

Daniel

01 Oct 2021
Copy link to comment