Skip to Content
avatar image
Former Member

differentiate approval between "for document generation " and "for document update" in database

hello experts,

need help in differentiate between "approval for document generation " and "approval for document update" in the database table

i cant seem to find it in the ODRF table

any hint or help is appreciated :)

the reason i need this information is that i want to create blocking from stored procedure that applies to "approval for document update"

so users arent allowed to make an approval request for updating documents

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Dec 20, 2016 at 09:47 AM

    Hi,

    Can you share the screenshots of both so that we can determine the exact requirement?

    Regards,

    Jitin

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 20, 2016 at 08:00 PM

    Hi Ricky,

    If you want know if the draft in odrf is being created or updated you can use the following sintax in your transaction notification:

    IF @object_type = '112' and @transaction_type = 'U' -- [U]pdate
    BEGIN
    
    END
    
    IF @object_type = '112' and @transaction_type = 'A' -- [A]dd
    BEGIN
    
    END
    

    To know if the draft is from an approval procedure or is a draft saved by the user, you can see the field WddStatus.

    When the draft is created by the user, the WddStatus receive "-", otherwise the receive a letter that represent the status of approval procedure.

    Hope it helps.

    Kind Regards,

    Diego Lother

    Add comment
    10|10000 characters needed characters exceeded