2009 Jul 22 10:58 AM
Hi all,
As I understand the ENQUE_<object> will lock the object only for till the transaction/program terminates. Is there a way to get a lock beyond this?
My requirement is in Workflow, where I need to lock an object till an approval happens. This approval process might take days to happen, and the object should be locked till then. I experimented with the _SCOPE parameter and it did not help. Any ideas?
Thanks
Krishna
2009 Jul 22 11:07 AM
well it sound better to me to use some sort of status. If objects has a certain status, then object can not be edited. Only after approval, you will change the status and editing is allowed.
well it sound better to me to use some sort of status. If objects has a certain status, then object can not be edited. Only after approval, you will change the status and editing is allowed.
2009 Jul 22 11:07 AM
well it sound better to me to use some sort of status. If objects has a certain status, then object can not be edited. Only after approval, you will change the status and editing is allowed.
2009 Jul 22 11:26 AM
Hi,
Try this possible solution.
1) create a table which stores the detail workflow approval = YES or NO.
2) create a background job report which locks the object.
In this report ,put the following logic.
do .
select single approval
from new ztable created
into l_status
where.......
if l_status = YES (means approval done).
EXIT.
endif.
enddo.
3) This means the program will not stop untill the approval is done!!!
CHEERS!!!
Regards,
Vimal
| User | Count |
|---|---|
| 6 | |
| 2 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |