Multi Dependency Select Box - how to apply dependency in JDBC Binder?

Confluence User - 30 Nov, 2021

Hello everyone.


I understand that for normal select box, we can use JDBC binder to populate data from an external datasource, and also check Use AJAX for Cascade Options checkbox for the query to depend on other fields, as shown in the tutorial in JDBC Options Binder .


But how can we achieve multiple dependency in JDBC Binder for multi dependency select box? can we still use the same way as the normal select box?


SELECT
   ItemCode
FROM
   Items
WHERE
   ItemType = (?) AND ItemCategory = (?)


With the above code I am trying to populate ItemCode into the selectbox base on the ItemType and ItemCategory.

I know the above code won't work, but how can I achieve it?


Thanks! (smile) 


Regards,

Wesley

selectbox;jdbcbinder

2


01 Dec, 2021
confluenceUser
confluenceUser

I found this Filter SelectBox Options from Multiple Dependency Fields - might be useful to you

02 Dec, 2021
confluenceUser
confluenceUser

Hello Bastiana, thank you for your reply.

I have tried on the sample app given in the Multi Dependency Fields, but it is populating the data using default form options binder.

I would like to achieve it via JDBC Binder as I need to populate data from external source.

Thanks!


RELATED QUESTIONS

Your answer


To answer a question you'll need an account.

Print