Joget DX Preview Release Available for Download
Check out Joget DX, the next generation successor to Joget Workflow for faster, simpler digital transformation.
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.
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.
Hi Brian Baldwin
To populate a selectbox, you need two values, the id and the value, example:
"select id, firstName from database_name;"
Powered by a free Atlassian Confluence Open Source Project License granted to Joget Workflow. Evaluate Confluence today.