Passing parameter to Query in JDBC binder

 
1
0
-1

Hi,

 

I have a select box which is populating using JDBC binder, I have to pass parameter in query's where clause so that it populates data dynamically. 

 

I tried the #form.TABLE.COLUMN# from the same form but it is not working. Please advise!

 

Regards,

TK

    CommentAdd your comment...

    2 answers

    1.  
      1
      0
      -1

      Hi Anders

       

      Basically I need to pass parameters in query like in below image. This is a select box which will populate according to jdbc binder query.

       

       

       

      Regards,

      TK

      1. Anders

        As mentioned in my answer, I doubt the hash variable can automatically determine the primary key or record ID you intend to use so you need to to pass in the record ID in the hash variable.

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

      Hi, you should probably provide more specific information than "not working". If I were to guess, could be because there isn't any default record ID for the hash variable to determine which row to return. You can try passing in the record ID eg #form. tableName . fieldId [recordId]# as mentioned in https://dev.joget.org/community/display/KBv5/Hash+Variable#HashVariable-FormDataHashVariable Hash Variable#FormDataHashVariable

        CommentAdd your comment...