Hi there...

In the documentation there is a Weblog example (Chapter 18).

I am trying to find out how to retrieve:

- a Blog object with Id 1

AND

- In the property "Items" (IList) of this blog, I would like to retrieve only the items with Title like '%abc'.

In other words, I would like to filter the Items list by some criteria, in this blog object that I am retrieving.

Is that possible? How would I do that using an ICriteria query?

I appreciate any help!
Kind regards.

I think this should do the job

List blogs = sess.createCriteria(Blog.class)
.add( Restrictions.eq("id", new Integer(1)) )
.createCriteria("items")
.add( Restrictions.like("text", %abc") )
.list();


Go through this link for more info

http://www.hibernate.org/hib_docs/v3/re ... teria.html

After going through your post again, I realize that you want to put restriction on items in Blog object.

I think this can be achieved through hibernate filters. See this for more details

http://www.hibernate.org/hib_docs/v3/re ... lters.html

Cheers, I'll try that.