Konstantin, Maybe you could achieve a similar effect by using a "constant join". Have a look at the following section in the manual:
http://openjpa.apache.org/builds/latest/docs/manual/manual.html#ref_guide_mapping_notes_nonstdjoins Regards, Milosz > Hello All > > We are migrating from Hibernate to OpenJPA and we faced the following > problem: it seems there is no alternative to Hibernate's @Where annotation > for collection properties. This annotation allowed us to add arbitrary SQL > for collections loading, e.g. @Where("IS_DELETED=0"). > We used this to filter so called "marked as deleted" records. > > Could anybody suggest a way to filter collection when loading them from > database? > Using LRS will be too heavyweight solution for us. > > Thanks in advance. > > -- > View this message in context: > http://n2.nabble.com/Restrict-collection-items-tp1690569p1690569.html > Sent from the OpenJPA Users mailing list archive at Nabble.com. > >
