Annotation Interface WhereJoinTable


@Target({METHOD,FIELD}) @Retention(RUNTIME) @Deprecated(since="6.3") public @interface WhereJoinTable
Deprecated.
Specifies a restriction written in native SQL to add to the generated SQL when querying the join table of a collection.

For example, @WhereJoinTable("status <> 'DELETED'") could be used to hide associations which have been soft-deleted from an association table.

See Also:
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.
  • Required Element Summary

    Required Elements
    Modifier and Type
    Required Element
    Description
    Deprecated.
    A predicate, written in native SQL.
  • Element Details

    • clause

      String clause
      Deprecated.
      A predicate, written in native SQL.