How to run Post commit activities.
Requirement : When a work object is commited I need to generate a report using the updated values of that object from DB.
Solution Tried :
I created a declare trigger which executes Commited and Saved option.
Problem Faced :
When I traced I found that Declare tigger gets executed even when the object is not written to DB. Even the commit operation is not complete the activity written in the Declare Trigger gets called giving me old values from DB
Is there any other approach that I can use so that my activity gets called post commit to DB.
***Updated by Moderator: Lochan. Removed user added helpme and Ask the Expert tags. Apologies for confusion, shouldn't have been an end-user option***
Areteans Technologies
AU
You can modify the code based on case Resolved-Completed status, declare trigger calls every time when you move from one assignment to other which might not be your WO end.
HSBC
IN
This is what we tried. We put a when rule on Declare Trigger which checks if the WO is Resolved-Complete. However, the Resolved-Complete status is only on the Clipboard when the Declare Trigger calls the activity and the updated status is not in sync with DB. Activity gets called before the Commit operation completes. Hence, I am not getting updated values for my Report at run time.
Question : Is there a place where I can write my code and the Commit operation has completed its write to DB?