Thu, 24 Sep 2026
Login

JDBC Load Binder Where Clause

Confluence User - 01 Nov, 2019

Greetings - I am trying to use a current text field on a form as a parameter in the SQL statement to populate a SelectBox. example:

Select Name, Name from TableName Where Condiition = "TextfieldName"

How is the textfield referenced within the SQL query? the form would not be saved yet.


thanks


tony 

jdbc;binder

3

Confluence User •
01 Nov, 2019 •
confluenceUser •
•
confluenceUser •

Ok - so I structure the sql in the selectbox as such:


SELECT c_Balance, c_Balance
FROM aimsportal.app_fd_PurchaseOrder
WHERE c_PurchaseOrderNumber = ?


and in the next screen I setup a textfield as the Field ID to control available options based on Grouping.

however it doesnt seem to work? is it due to the community edition we are testing on?




Confluence User •
01 Nov, 2019 •
confluenceUser •
•
confluenceUser •

so it works with the form binder and same process  as above. I guess its a Jdbc limitation.


Cheers - Tony

Confluence User •
01 Nov, 2019 •
confluenceUser •
•
confluenceUser •

Hi Anthony

These links in Joget Knowledge Base might help:


1
CSV | Excel | XML | PDF
RELATED QUESTIONS
Access a subform field in a spreadsheet element
Can I specify each app to have its own database?
SQLI ERROR
is possible on javascript when click submit on joget , the javascript do first before store binder joget ?
Show SP return value in a form
Run external stored procedure using a date parameter and show results
AJAX Cascading Not Working in JSON API Options.
still issue multi page set read only . my load binder is using jdbc binder custom datasource
How to Update Environment Variable of Other Application in Same Environment
issue on multi page when set read only
1
CSV | Excel | XML | PDF

Your answer

To answer a question you'll need an account.

Print