Join us on May 14-15, 2019 at Forrester Digital Transformation & Innovation 2019 in Chicago, USA.

 
1
0
-1

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.

 

 

    CommentAdd your comment...

    2 answers

    1.  
      1
      0
      -1

      Hi Brian Baldwin

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

      "select id, firstName from database_name;"

        CommentAdd your comment...
      1.  
        1
        0
        -1

        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.

         

          CommentAdd your comment...