Define table nesting

The Tables element is used to define a table and its structure in a DNATreeLayoutSchema.xml file. Table nesting employs the same structure, but with additional attributes.

Nesting logic:

1. If the last attribute in the Tables element ends with either a /> or > with </Tables>, it indicates that the Tables element is complete and no nested table follows.

2. If the last attribute in the Tables element ends with a > and the next line is a new <Tables element, it indicates that the next table is a nested table.

3. A nested table may have the following attributes:

   • PrimaryKeyField attribute that defines the column name to be returned for the query.

   • Optional: ColumnsLinkingToParentNodes attribute that defines a list of columns, separated by commas and ending with a column, for the tables defined in the WhereClause attribute that are related to the previous levels.

   • Optional: FromClause attribute defines the table(s) from which to query the data.

   • Optional: WhereClause attribute defines the constraints for the table(s) defined in the FromClause attribute.