How to display multiple rows of data in the spreadsheet of an ajax sub-form?

 
1
0
-1

How can I display multiple rows of data in the spreadsheet of an ajax sub-form which is linked to the multi-select box?

eg. when I select 2 different order numbers from the multi-select drop-down box, the details of both should be displayed in the spreadsheet in separate rows.

    CommentAdd your comment...

    1 answer

    1.  
      2
      1
      0

      When you use a multiselect box it stores semi colon separated (;) value. E.g Value1;Value2;Value3
      If you Ajax is working on multiselect box and you are getting ids of the rows that you want to display in the spreadsheet then:
      You need to user jdbc binder, write an sql query that can display the records of semi colon separated ids into separate rows  

      1. Meghana

        Thank you Anas Misbah Shami for your reply.


        I have written an SQL query that fetches the data from the table view. But the spreadsheet displays the details of only one of the order numbers selected from the multi-select drop-down.

      2. Anas Misbah Shami

        There must be wrong something with the query. Have you tried running the query in heidisql?

      CommentAdd your comment...