JDBC Form Binder and Grid

Confluence User - 10 Jul, 2020

Hi, trying to populate a Grid with JDBC binder, which the condition of the query needs to reference a form field:


Select c_program_number From app_fd_sow_remarks Where c_program_number = '#form.sow.program_number#'


the "sow" in the #form.sow.program_number# is the parent form table. I can't seem to get it pass the field value from the parent form. What am I doing wrong here?


Thanks.

forms;jdbc;binder

1


10 Jul, 2020
confluenceUser
confluenceUser

I think that to achieve the effect you need, the program_number field should be a selection list and put the grid in an ajax form, with which you can load the necessary values into a query dependent on a request param variable.

RELATED QUESTIONS

Your answer


To answer a question you'll need an account.

Print