Wiki
Clone wikigrails-datatables / joinTypes
joinTypes
Values
Name | Type | Default |
---|---|---|
joinTypes | String | none |
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.
Updated