Welcome and thank you for joining our new OpenText forum. Your questions, responses, best practices, and tips shared with other members will help make this channel vibrant. We're glad you're joining us and look forward to collaborating with you online.

Check out the Getting Started With OpenText Forums for tips on personalizing your experience.

How to use nested table-data or list in table?

iparkeriparker Member
edited December 31, 1969 in Designing Analytics Reports
Hello,

I have a question about the output nested data. How is the procedure to output nested data, for example a table in another table or a list in a table-cell?

The problem I see is that I have to access the parent_id in the child-sql-statement. The only way I see is to create a report-parameter, write the parent_id into this parameter while output the parent-data and use this variable in the child-sql-statement as parameter.

So is this the correct way or are there better options to solve this problem?

Timo

Comments

  • mwilliamsmwilliams BIRT Guru
    edited December 31, 1969
    Hi Timo,

    You can use a dataSet parameter in the embedded table's dataSet's query to limit the data. Then, in the binding tab in the property editor, you can click on the dataSet parameter binding button and set the binding to be the key from the outer table that will get you the correct info. Hope this helps. Let me know if you have questions or would like an example.

    Regards,

    Michael Williams

    eSignLive Evangelism & Community Manager | eSignLive by VASCO
     
    Find me on:
    Twitter
    Facebook
    Blog

    LinkedIn

    eSignLive Developer Community
     
    Email me:
    Google: [email protected]

  • iparkeriparker Member
    edited December 31, 1969
    Hello Michael,

    Is this also possible without the use of any parameter? I tried to set a filter in the filter-tab of the embedded table, and I set a equal-filter to the parent_id via row._outer["parent_id"]. And it seems to work.

    Is the disadvantage of this solution that BIRT queries all data from the child-table and filters after the execution of the query?
  • CBRCBR Member
    edited December 31, 1969
    you re right. Using the filter functionaltiy of the BIRT framework instead of using a where clause in your sql query means that all data is fetched from database and afterwards this data is filtered using Java.
    That's the reason why filtering or sorting your data is always faster when you let the database doing the work.
  • iparkeriparker Member
    edited December 31, 1969
    Ok - thanks for your answer!
  • edited December 31, 1969


    Hi Timo,





    You can use a dataSet parameter in the embedded table's dataSet's query to limit the data. Then, in the binding tab in the property editor, you can click on the dataSet parameter binding button and set the binding to be the key from the outer table that will get you the correct info. Hope this helps. Let me know if you have questions or would like an example.




    thank u mwilliams.

    this tutorial help me a lot.



    this is what i'm looking for.
  • mwilliamsmwilliams BIRT Guru
    edited December 31, 1969
    Hi delonge182,

    Glad to help! Let us know whenever you have BIRT questions! :)

    Regards,

    Michael Williams

    eSignLive Evangelism & Community Manager | eSignLive by VASCO
     
    Find me on:
    Twitter
    Facebook
    Blog

    LinkedIn

    eSignLive Developer Community
     
    Email me:
    Google: [email protected]

  • Apologies for re-opening this topic again.


     


    The inner table can be filtered by using row._outer["parent_id"]. But then disadvantage is also discussed that dataset would get all the data and then filter it out, which is not a good practice if there are multiple child tables and fetching small data from huge resultset. So whats is the best way to achieve this nested table logic without hampering the performance of report.


     


    Apologies, if I missed to understand this properly..


     


    Thanks


Sign In or Register to comment.