We are encountering an issue on getting the task availa ble of certaing group. I

We are encountering an issue on getting the task availa ble of certaing group. In one user group, the members of that group have an action to get the next available task available for that group , clicking on that action, we make a query check the next unassigned task, assigne that to that user & then update DB but now the issue, tha is tasking place is when two users click on the same time. The same task is being fecthed b y both users. One user overwrite the other user in Appian but in DB, it is te foirst tat is tsill updated. So now, when user to whome , it is assigned in DB, see s that task in his name in DB, he/she tries to access it but as in Appian, the task is assigned to another user, they gets an error that requested task is not available. Can anyone suggest a solution for this please?

OriginalPostID-147706

OriginalPostID-147706