More than 1 filter condition for Select Query

 
1
0
-1

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?

    CommentAdd your comment...

    2 answers

    1.  
      1
      0
      -1

      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.

       

        CommentAdd your comment...
      1.  
        1
        0
        -1

        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.

         

          CommentAdd your comment...