Confluence User •

19 Apr, 2021 •

confluenceUser •

•

confluenceUser •

Hi,

> I want to input primary key to a form field 

set a textfield ID to id. Ensure to put relevant validators on the field i.e mandatory / no duplicates / etc

> get record from external database and populate the rest of form fields with the data.

Use JDBC Form Load Binders: JDBC Form Binder#ConfigureJDBCLoadBinder preferably use it at section level instead of the form level.

Confluence User •

19 Apr, 2021 •

confluenceUser •

•

confluenceUser •

Hi Ian,

I did configure the JDBC form binder but the form is not populated.

Do I need to configure the fields as well?

Sorry I am new to this.

Confluence User •

19 Apr, 2021 •

confluenceUser •

•

confluenceUser •

was there any issue when you click on the test connection button? if there are errors on screen or on your tomcat log, refer here: JDBC Form Binder - Knowledge Base for DX 7 - Joget | COMMUNITY

Ensure query column names are the same as the fields in the Joget form. You can use the AS command. i.e if joget field is Customer → SELECT CustomerName AS Customer FROM ext_db

1

CSV | Excel | XML | PDF