What you put in the where clause will not be substituted - i think it's raw sql.
On Dec 11, 10:41 am, Henning <[EMAIL PROTECTED]> wrote: > 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 -~----------~----~----~----~------~----~------~--~---
