Hi,
some JPA provider support a @Where annotation, e.g Hibernate, for filtering a to-many relationship. This annotation is very useful if you are using soft deletes instead of physical deletes.
Without the annotation, it is not possible to use a getter to retrieve a collection of entities without all soft-deleted entities from the database.
So I would like to propose this annotation for the JPA specification.
Thanks a lot,
Heinz
--
Heinz Wilming
Diplom Wirtschaftsinformatiker (FH)
akquinet tech_at_spree GmbH
Bülowstrasse 66, D-10783 Berlin
Fon: +49 (0)30 235 520 - 0
Fax: +49 (0)30 217 520 - 12
E-Mail: heinz.wilming_at_akquinet.de<mailto:heinz.wilming_at_akquinet.de>
www.akquinet.de<http://www.akquinet.de>
akquinet tech_at_spree GmbH, Berlin
Geschäftsführung: Martin Weber, Dr. Torsten Fink
Amtsgericht Berlin-Charlottenburg HRB 86780 B
USt.-Id. Nr.: DE 225 964 680