Greetings!

I'm using the community Edition for Joget. I'd like to know what would be the correct way to do a Dynamic cascading drop-down list, but using the Bean Shell Form Binder.

I've try to do so, but I'm not sure I'm using the query in a good way.

For example if I have my query like: "SELECT id, description, cod_materia FROM matriz.mat_motivo_tbl"

I believe the id will be the value, the description the label and the cod_materia de grouping column, also I'm using the option for "Field ID to control available options based on Grouping". But I doesn't seem to group as it's supposed to.