joinTypes

Values

Description

joinTypes is a column option that allows you to specify how association fields are joined. It is a string containing a comma-separated list of join types.

Valid Join Types:

• INNER_JOIN (default)

• LEFT_JOIN

• FULL_JOIN Note that not all databases support full outer joins.

There should be one join type for each association in the column, thus the number of join types in the list must equal the number of periods in the column name.

A join type need only be specified once for each association. In order to avoid overwriting a join type specified in another column, you can include blanks (e.g. joinTypes=",LEFT_JOIN").

Example

<dt:datatable name="MyTable" domainClass="this.is.my.DomainClass" serverSide="true">
    <dt:column name="author.name" joinTypes="LEFT_JOIN"/>
    <dt:column name="author.publisher.name" joinTypes=",LEFT_JOIN"/>
</dt:datatable>

Back to Options.