Thu, 24 Sep 2026
Login

More than 1 filter condition for Select Query

Confluence User - 18 Sep, 2017

Dear Expert,

 

The example in JDBC Options Binder shows the solution for 1 field value in filter condition.

I have 2 field values to be included in filter condition for selectbox.

Example, I want to show all the purchase order based on company and currency. User will select the company and currency.

Can you help to provide samples to solve this?

#beanshell;#jdbcbinder;#selectbox

2

Confluence User •
19 Sep, 2017 •
confluenceUser •
•
confluenceUser •

I think in this use case, Popup Select Box is more suitable as you can pass as many parameters as you want to the datalist for selection.

 

Confluence User •
20 Sep, 2017 •
confluenceUser •
•
confluenceUser •

Based on the selected purchase order, I have ajax subform which show the details. I understand that when I click the popup selectbox, the data list will display all the details. 

However, I need to grab the details (shown by ajax/datalist) into a grid.

 

It would be great if I can get to know Bean Shell code on retrieving field value (currency & Company Name). 

Below is my current form design.

 

1
CSV | Excel | XML | PDF
RELATED QUESTIONS
How to bind select box with multi parameters?
inner join for jdbc not working
JDBC load binder: Form submit is add a record
How to bind select box with multi parameters?
Bean shell validator Use With Numbers
in select box when we type some name when the name is displayed it should only show that specific name other names should be hide in drop down list
LDAP plugin
jWill JDBC options binder works with Joget v6 community edition?
JDBC Form Binder for MSSQL not populating Datalist
Copy the data in data list to other table in mysql
1
CSV | Excel | XML | PDF

Your answer

To answer a question you'll need an account.

Print