Question & Answer > View Question

JDBC Select get column output and put into a form? for e.g. a user login page

Confluence User - 22 Jun, 2022

Hi,

I have a pre-existing database with data in it, I need to be able to edit these fields and to do so I need to pull that data back into a form, edit the data then submit the form to update the table in the database.

I have been trying to figure out how to get the output from the select statement for process builder, and forms to get the data into a form, or into a new process. Is there anyone that is able to help me or jump on discord and give me some tips?

Regards

forms;process

1

Confluence User •

22 Jun, 2022 •

confluenceUser •

•

confluenceUser •

Joget process creates new records based on a predetermined id pattern, so it won't work with an external database as the primary table unless you add the form for your external table as a Subform to the parent Joget form (and the Subform has its own JDBC Form Binder to read/write the records back to the external table).

1

CSV | Excel | XML | PDF

Your answer

Print

JDBC Select get column output and put into a form? for e.g. a user login page

1

RELATED QUESTIONS

Your answer

To answer a question you'll need an account.

1.builder-style-adcbca5c-6933-4231-88bd-b49087d13c01{color:#008C60 !important;}

RELATED QUESTIONS

Your answer.builder-style-435da33e-1823-49ab-9952-271e7931a3c4{color:#008C60 !important; margin-left:10px !important;}

To answer a question you'll need an account.

1

Your answer