How do I query external database with JDBC Binder plugin

 
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

      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...
      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...