Question & Answer > View Question

I want to update status of selected items "Created" to "Assigned" using JDBC

Confluence User - 11 May, 2020

Now, I want to update status when I will click on assign button then selected checkbox's status value will be update to Assigned.

Thank you.

forms;datalists

1

Confluence User •

12 May, 2020 •

confluenceUser •

1 •

confluenceUser •

You'll need to use the SQL Update statement. Ensure the columns has a prefix "c_" and the table name has the prefix "app_fd_"

example: You have a form with the table named "projects", and in it you have a field called "status". Hence your SQL update statement should look something like:

UPDATE app_fd_projects SET c_status='Assigned' WHERE <whatever conditions set>;

I want to update status of selected items "Created" to "Assigned" using JDBC

1

RELATED QUESTIONS

Your answer

To answer a question you'll need an account.

1.builder-style-5735b3e8-8635-42d1-b919-89662da36816{color:#008C60 !important;}

RELATED QUESTIONS

Your answer.builder-style-85b33668-217b-417b-84da-a20d053df6d8{color:#008C60 !important; margin-left:10px !important;}

To answer a question you'll need an account.

1

Your answer