2 Replies Latest reply on Oct 23, 2009 10:52 AM by Sylvain Catudal

    How to obtain revision number of current transaction

    Sylvain Catudal Newbie

      Let's start from the fact that a new revision info is inserted for each transaction concerning audited entities.

      I'm running a task that changes data in the DB and I'd like to attach the REV that corresponds to the revision at which the job was done. This way, if ever that job has to be undone, I'll have the exact revision number.

      So here is the business situation:

      I am processing the merge of two patient medical records. Since sometimes those merges are wrong, they may need to be undone. Having the exact revision number that matches the transaction would be more reliable than a date and time because two merges could be processed at the same time.

      Thanks for your help