function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion

Nesting a datatable


I am trying to create a tree structure on a visualforce page. Is it possible to nest one datatable into another datatable. Is there and expample for such a thing.




I've had success nesting dataTables 1 level.   My solution is based on a SOQL Query with an in-line relationship query.


NOTE:  Try true/false for the 'breakBefore' attribute in apex:column to see the different behaviors.



<apex:dataTable value="{!quotes}" var="q">
<apex:column value="{!q.quote_number__c}" />
<apex:column value="{!q.quote_date__c}" />
<apex:column breakBefore="true">
<apex:dataTable value="{!q.QuoteLines__r}" var="qLine">
<apex:column headerValue="Line #" value="{!qLine.line_number__c}" />
<apex:column headerValue="P/N" value="{!qLine.part_number__c}" />

 Here's the SOQL:  (a quote has many quote lines)


List<Quote__c> quotes = [Select id, name, quote_number__c, quote_date__c, (SELECT line_number__c, part_number__c from QuoteLines__r) from Quote__c];

You cannot go additional levels using a SOQL statement; however, you may be able to go deep (like a tree) using your own custom class for the tree's data source.





Message Edited by mikeafter6 on 2009_0714 06:01 PM