Join us on May 14-15, 2019 at Forrester Digital Transformation & Innovation 2019 in Chicago, USA.
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.
Hi Brian Baldwin
To populate a selectbox, you need two values, the id and the value, example:
"select id, firstName from database_name;"
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.