Populate third drop down box basedon selection of other two drop downs

 
1
0
-1

Hi experts,

I am using Joget v6 community edition.

I have three select boxes in my form.

Second drop down should populate based on the selected value from first drop down

and third drop down should populate based on second drop down selection.

   In the second drop down, I am using 'Default options binder' and given the grouping field as 'first dropdown field' and ,Second drop down is working fine .

And for the third drop down also I am using  ''Default options binder" . I am not sure how to give grouping field for this drop down.

Can anyone please let me know how can i do this.

 Thanks in advance..

 

 

 

    CommentAdd your comment...

    1 answer

    1.  
      1
      0
      -1

      Hi

      Use JDBC Binder in Option Binder, and use simple quires to populate combo boxes 

      for example we have three combo boxes which is retrieved data for a database table, 3rd one is dependent on 2nd one and 2nd one depends on 1st one, boxes name are src_tag1, src_tag2, src_tag3 

      Query for first box -> 

      select distinct tag1, tag1 from tag_sheet
      order by tag1

      Query for 2nd box -> 

      select distinct concat(tag1, ',', tag2), tag2, tag1
      from tag_sheet
      where tag1 = ?
      order by tag2

      mention "src_tag1" in Field ID to control available options based on Grouping in Dependency Portion

       Query for 3rd box -> 

       

      select distinct concat(tag1, ',', tag2, ',', tag3), tag3, tag2
      from tag_sheet
      where concat(tag1, ',', tag2) = ?
      order by tag3

      mention "src_tag2" in Field ID to control available options based on Grouping in Dependency Portion


      and so on .........

      Regards,

        CommentAdd your comment...