Database Update Tool - How To Update Status Previous Data with New Run Process

 
1
0
-1

Hi,

how can i udpate status previous application to 'close' after applicant renew their application(with new id) by using database update tool?


UPDATE

app_fd_application SET c_status= 'Close'

WHERE c_id = 'PreviousId'


I dont know how to connect run process with the previous id.


Thanks.


    CommentAdd your comment...

    2 answers

    1.  
      2
      1
      0

      You can store the previousId in one of the workflow variables (Hash Variable#WorkflowVariableHashVariable) on the form and use it in where clause as '#variable.previousID#'

        CommentAdd your comment...
      1.  
        1
        0
        -1

        In your new process form, add a selectbox field element (field id "PreviousId") for the user to select the previous process record to close, store into DB the record id, then in your process tools, use yr SQL above to update the previous process record status, example:

        UPDATE app_fd_crm_application SET c_status= 'Close' WHERE c_id = 'PreviousId'

        1. jogetuser

          how to get the previous id with hash variable?

        CommentAdd your comment...