Hi,

There must be one action which can automatically delete/truncate the entities created by users not the system entities because sometimes while testing the application we used to create lots of junk data and after that if want to clean the environment junk data it takes lots of effort if, we have more than 100 relational entities. Do not delete the data from static entity, only from standard entities, So that environment got cleaned easily. I know that for production this function must be disabled otherwise it will be a problem. 

Regards,

Manish jawla

Hi Team,

Please add entity action for delete all as  DeleteAll or take list of ids as a input for multi delete.

Thanks!

You mean like on Mobile?

This will be really useful instead of having to iterate through each time

Hi Team,

Any update?

Thanks

It is possible to have (delete all) function in entities like the function which in the locale storage 

It would be handy to have the ability delete all the results of an Aggregate and also to have a Bulk Delete action for an entity.

There two hacks in ServiceStudio to accomplish something similar.

1. Delete all rows from Table

• Select the Entity in the Data tab (EntityName) 
• Copy the entity from the context menu.
• Paste the entity from the context menu (create EntityName2)
• Delete the EntityName.
• Rename EntityName2 to Entity Name

Note this method also resets the EntityName identifier back to 1.

2.  SQL Aggregate

• In non SQL Aggregate, copy the generated SQL statement.
• Create a new SQL aggregate and past the the copied SQL Statement.
• Surround the SQL statement in a commit transaction (SQL Server and Oracle differ in syntax)
• Click the Test button

Note this method preserves the last used EntityName identifier.

The first hack doesn't work as it messes with the foreign keys (unless you don't have relationships between entities that is).

I'm not sure about your second hack as I wouldn't know where to copy the generated SQL from, however I just added my own SQL to the effect of:

DELETE from {MyEntity} WHERE {MyEntity}.[MyAttribute] = @MyAttributeVariable;

However it would be better if there was a quick and simple way to clear an entity of all data, particularly handy if your data model changes and indexing edits conflicts with existing data.

Also the ability to pass a parameter (filter) for the data to be deleted would be really handy, as well as a basic delete all.

Erik -

That's really not what was asked for, original poster is just looking for something that accepts a record list that has IDs in it and deletes them, rather than calling DeleteXYZ within a ForEach on the record list.

J.Ja

Any update on this matter?

A delete all or delete a list of ids would be fantastic, as a create a list of elements would be too.
Sometimes in sync modules we need to use delete all and create a lot of data and need to use Advance SQL, but if we have large modules we end up with Monolithics or we break and have circular references ou exposed entities, both bad solutions...
If we use "for" we end up with slow solution...

If we have 1000+ of record and want to delete that all record from entity. Right now, we are doing with two ways.
1) SQL query to delete record
2) for each and delete one by one

Instead of, this if we get one more action for Delete all like below screenshot. so, it will be easy or more handy to delete all records