Ooooh very close. This is nearly perfect except that is seems to be
adding the condition to the where clause as well now, so I am getting:
SELECT ...
FROM Assessment this_
left outer join Categories impactcate1_
on this_.AssessmentId = impactcate1_.AssessmentId
and impactcate1_.CategoryID = 1
WHERE impactcate1_.CategoryID = 1
This is with the following criteria:
session.EnableFilter("ByCategory").SetParameter("id", 1);
session.CreateCriteria(typeof (Assessment))
.CreateCriteria("Categories", JoinType.LeftOuterJoin)
.List();
If I can just get rid of that where clause I will have exactly what I
want.
Thanks very much for the help so far - any help with the last problem
would be fantastic.
On Aug 3, 3:04 pm, Jason Meckley <[email protected]> wrote:
> filters may be the option you are looking for
> <set name="Categories">
> <filter name="ByCategory" condition="CategoryId = :id"/>
> </set>
> ....
> <filter-def name="ByCategory">
> <param name="CategoryId" type="long" />
> </filter-def>
>
> session.EnableFilter("ByCategory").SetParameter("id", 1);
> session.Get<Assesment>(2);
>
> var onlyCategoriesWithIdEqualToOne = Assesment.Categories;
>
> On Aug 3, 9:07 am, julianjelfs <[email protected]> wrote:
>
>
>
> > Hi,
>
> > Is there a way to restrict the join performed to populate a set using
> > a dynamic variable or a parameter. The set mapping allows me to
> > specify a "where" attribute but I need it to look something like this:
>
> > <set name="Categories" table="Categories" where="CategoryId = :id" >
> > ...
> > </set>
>
> > rather than having a static value.
>
> > If I add this condition as a restriction to the overall criteria, the
> > restriction gets added to the where clause of the query rather than as
> > a condition of the join. This is not quite the same thing and not what
> > I want.
>
> > session.CreateCriteria(typeof (Assessment))
> > .CreateCriteria("Categories", JoinType.LeftOuterJoin)
> > .Add(Restrictions.Eq("CategoryId", 1))
> > .List();
>
> > gives me something like:
>
> > SELECT ...
> > FROM Assessment this_
> > left outer join Categories impactcate1_
> > on this_.AssessmentId = impactcate1_.AssessmentId
> > WHERE impactcate1_.CategoryID = 1
>
> > whereas what I need is:
>
> > SELECT ...
> > FROM Assessment this_
> > left outer join Categories impactcate1_
> > on this_.AssessmentId = impactcate1_.AssessmentId
> > and impactcate1_.CategoryID = 1
>
> > I can't think of any way round this at the moment, so any ideas would
> > be appreciated.
>
> > Thanks,
>
> > Julian.
--
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.
