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!
Regards,
Wesley
selectbox;jdbcbinder