Delete data from an entity and commit it 

Delete data from an entity and commit it 

  

Hi, I want to delete all data from an entity so that I can make changes to the table structure. I am trying to do this with a Delete from {entity_name} - it is executing and returning with a message 'Query returned no rows'. But when I do 'View Data' on the entity, it shows me data values. 

Can someone help?

Regards


Solution

Hi Suresh,

From the sounds of it, you are clicking the test query button right? You will need to deploy this query to have it execute within the app. You can create a timer and set its schedule to 'Run on Deploy', and inside of the timer, make a call to the delete query.

Let me know if you have any trouble,

Justin

Solution

Justin Babel wrote:

Hi Suresh,

From the sounds of it, you are clicking the test query button right? You will need to deploy this query to have it execute within the app. You can create a timer and set its schedule to 'Run on Deploy', and inside of the timer, make a call to the delete query.

Let me know if you have any trouble,

Justin

Thanks Justin. This worked. I was trying to add a '.' at the end of the DELETE statement in the Query run to make it commit, which looks like does not work. Suresh