How can i use SQL Advanced for delete item in service studio?

Hi,

I want to know how can i do to delete a specifc item of the table in service studio.

Solution

Create an action with an advanced query with the statement:

DELETE FROM {YourEntity}.id;

Solution

Flavio Lucio wrote:

Create an action with an advanced query with the statement:

DELETE FROM {YourEntity}.id;


Thank you!

Hi,

The solution presented deletes all records on that table and not a specific one. Is that what you want? If not can you explain better what you want to accomplish?

Regards,

Marcelo

Marcelo is correct.

If you don't want to delete all the records you should put a condition on your delete query


Also if you have your table with expose read only, you can't delete records from the table consumers.For that you need to create an server action on the table producer and then share it to the consumers.