For example, @WhereJoinTable("status <> 'DELETED'")
could be used to hide associations which have been soft-deleted from an
association table.
API Note
This separate annotation is useful because it's possible to filter
a many-to-many association both by a restriction on the
join table, and, simultaneously, by a restriction on the
associated entity table. The @Where annotation always
filters entity tables.
Where
| Modifier and Type | Method and Description |
|---|---|
| public String |
| clause | back to summary |
|---|---|
| public String clause() A predicate, written in native SQL. | |