Thu, 24 Sep 2026
Login

How do I query external database with JDBC Binder plugin

Confluence User - 20 May, 2016

I am trying to populate a dropdown list from an external database view (MSSQL) using the JDBC Binder plugin.

I am able to create a database connection and test with success, but when I run the form the dropdown is empty.

Am I missing a setting?

Is there an error log that would capture the cause?

Thank you for your help.

 

 

jdbc

2

Confluence User •
20 May, 2016 •
confluenceUser •
•
confluenceUser •

Hi Brian Baldwin

To populate a selectbox, you need two values, the id and the value, example:

"select id, firstName from database_name;"

Confluence User •
20 May, 2016 •
confluenceUser •
•
confluenceUser •

Yes! that worked.

Changed the query as follows -

Before: SELECT FundingAction FROM  GCAWarehouseSQL.dbo.vSageFAInGCA

After: SELECT eGC1_Number AS ID, FundingAction FROM GCAWarehouseSQL.dbo.vSageFAInGCA

 

Thank you for your help Matthew.

 

1
CSV | Excel | XML | PDF
RELATED QUESTIONS
SQLI ERROR
still issue multi page set read only . my load binder is using jdbc binder custom datasource
How to Update Environment Variable of Other Application in Same Environment
If you load & store in the section, what are the right steps to close the connection? load & store it into external database with JDBC Binder plugins and Custom datasource
how i can get value textfield to form grid ?
how i can call value subfrom to jdbc ?
jdbc datalist action
how to set primary key in jdbc binder
Joget DX 7 set up application to database
subform repeater JDBC issue
1
CSV | Excel | XML | PDF

Your answer

To answer a question you'll need an account.

Print