I have a table showing all our service tickets and I would like a way to stop 2 people opening the same ticket at same time.
Any advise is very much appreciated
Thank you in advance
23.06.2016 07:04 von Siobhan
One thing which is comming to my mind:
1. additional boolean column in db (e_flag)
2. create a process to set the flag true and anothe to set the flag false
3. on edit page you need a velocity on initialization. first you need to check if the flag is set to flase, if yes then start background proces to set it to true, if now send a message to user that it is edited by someone
4. on save you need to start process wich set the flag to false
Similar solution - you can create a table with locked records, then you need just add record it to this table and remove it later.
24.06.2016 06:53 von rahn
I like this option.. thanks for your help
24.06.2016 07:14 von Siobhan
there are a lot discussions on the forum about thsi checkin/checkout function and all come to the same answer, you can't handle all cases.
What if the user just closes the browser? Then the record is blocked forever.
24.06.2016 11:22 von falkh