How to hold the data in table till the process gets completed.

(0) Share

Report

Posted on by Adam123

516

Hi guys,

I have one requirement.

Initially I was doing in a way like , I will be inserting few records in the temp table and I will be sending request(JSON) from the table.

Now I have changed table to regular because I need to run in the batch since temp table will not support in the batch.

So after I changed to regular table before insertion I will be deleting all the record, Now my problem is when multiple user sending at a same time only once user data we are getting and other user record in getting deleted. This is happening because we are writing /deleteFrom_table/.

Is there is any way that I can hold the records till that user completes it's process, it should not get deleted till then.

Categories:

Development / Customization / SDK

All responses (1)

Answers (0)

Suggested answer

André Arnaud de Cal... 290,277 Super User 2024 Season 2 on at

Like (0)

Report

How to hold the data in table till the process gets completed.

Hi Adam123,

You can add a field to store the user ID or a current session reference. Then delete only the records for the current user or session to keep the records from other users untouched. The delete_from command is supporting the where clause.