hmm, though I noticed, that it seems like the substitutions are not applied to the where-attribute?
I want to filter out stuff with "IsActive=true" where true is supposed to be substituted by "1" ... but I always get some fancy Oracle error about "true" :( On 9 Dez., 09:53, Henning <[EMAIL PROTECTED]> wrote: > cool, that looks just like what I had in mind. Thanx! > > On 8 Dez., 21:02, Tyler Burd <[EMAIL PROTECTED]> wrote: > > > Check out section 6.2 > > athttp://www.hibernate.org/hib_docs/nhibernate/html/collections.html > > > Specifically, there is a "where" attribute that allows you to filter a > > mapped collection based on arbitrary sql. > > > -----Original Message----- > > From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of > > Henning > > Sent: Monday, December 08, 2008 11:34 AM > > To: nhusers > > Subject: [nhusers] Filter collections > > > Hi, > > > I would like to filter the data that is being retrieved by NH from the > > database. I have a class "projecttype", which holds a collection of > > "projectsteps". But I only want to load those steps that are active. > > > So I figured I could define a filter in the mapping somewhere, so that > > I don't have to do that in code. I remembered that there was a filter- > > element inside of the bag-element. So I added > > > <filter name="onlyActive" condition="IsActive=true"></filter> > > > But I figured that I also need a filterdef element as well as I need > > to enable filtering for the session. This might be a little tricky, > > since I get my session from the NHibernateIntegrationFacility via > > CastleWindsor. Also I don't actually need a named parameter, since my > > filter-value would alwasy be constant. > > > Any thought on how to add a general filtering? Is the use of NH- > > filters recommended? Is there a general way to enable filters? > > --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
