Any ideas? I'm sure this is a simple use case of filters. I feel like im doing something silly and this should be an easy fix. or perhaps not
On Apr 1, 8:54 am, Sean Chambers <[email protected]> wrote: > I have a soft delete filter I am applying to all entities like so: > > <entity xml> > <filter name="NotDeletedFilter" /> > </entity xml> > > My filter def looks like this: > > <hibernate-mapping xmlns="urn:nhibernate-mapping-2.2" default- > access="property" auto-import="true" default-cascade="none" default- > lazy="true"> > <filter-def name="NotDeletedFilter" condition="Deleted > = :isdeleted" /> > </hibernate-mapping> > > The filter applies fine, the only problem is with associated entities > of the one I am retrieving. Having this filter applied to all entites > causes for where clauses to be added to all associations, which in > certain cases where the association is null, causes the main record to > never be returned. > > Ie. I have a user that has a many-to-one association with Company. > Upon selecting a user the following query gets built: > > FROM Users this_ > left outer join Companies company4_ > on user3_.CompanyId = company4_.Id > WHERE > and company4_.Deleted = 0 > AND 1 = 1 > > In this instance the query is retrieving all users most of which, > _user3_.CompanyId is NULL as it is not a required association. > > Other clauses were ommitted for brevity, but this shows that with this > filter applied, the where clause prevents from any records for the > main entity from being returned because of the where clause. > > Has anyone run into applying a site wide filter and running into > problems like this? -- You received this message because you are subscribed to the Google Groups "nhusers" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/nhusers?hl=en.
