Thu, 24 Sep 2026
Login

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

Confluence User - 19 Aug, 2021

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.


userviews;datalists;forms

3

Confluence User •
19 Aug, 2021 •
confluenceUser •
•
confluenceUser •

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'

Confluence User •
26 Aug, 2021 •
confluenceUser •
•
confluenceUser •

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#'

Confluence User •
28 Sep, 2021 •
confluenceUser •
•
confluenceUser •

how to get the previous id with hash variable?

1
CSV | Excel | XML | PDF
RELATED QUESTIONS
Process not starting with Form submission.
Form Submission Performance Issue
Export As PDF
Select Box
one to many relationship
Can we create a dropdown field directly in a Joget List so that users can change the status of a record from the list view itself?
How to auto load client data after selecting it in a dropdown?
Retrieve image upload from form into PDF
Error storing data
i am building an app, and for some reason i am not able to open it anymore. All apps --> my app --> system error
1
CSV | Excel | XML | PDF

Your answer

To answer a question you'll need an account.

Print