Thu, 24 Sep 2026
Login

Passing parameter to Query in JDBC binder

Confluence User - 03 Jun, 2017

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

forms;jdbc;selectbox

3

Confluence User •
04 Jun, 2017 •
confluenceUser •
•
confluenceUser •

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

Confluence User •
05 Jun, 2017 •
confluenceUser •
•
confluenceUser •

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

Confluence User •
05 Jun, 2017 •
confluenceUser •
•
confluenceUser •

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.

1
CSV | Excel | XML | PDF
RELATED QUESTIONS
Process not starting with Form submission.
Form Submission Performance Issue
Export As PDF
Select Box
one to many relationship
Can we create a dropdown field directly in a Joget List so that users can change the status of a record from the list view itself?
How to auto load client data after selecting it in a dropdown?
Retrieve image upload from form into PDF
Error storing data
How to generate unique ID using Textfield?
1
CSV | Excel | XML | PDF

Your answer

To answer a question you'll need an account.

Print