How to fetch a tree of objects with restrictions.

newbe · **Joined:** Mon Sep 18, 2006 5:21 am **Posts:** 6

Hi,

I have the tree of objects of the following class:

class Node {
Node parent;
String color;
}

Parent property is not lazy initialized, so when I get a root object (parent == null) I am getting tree of objects. I am using the following query:

Code:

from Node where parent is null

Now I would like to get the root but with the restriction that color of each node (no matter how deep in hierarchy) is not equal to "blue". How to do that?

regards
John

newbe · **Joined:** Mon Sep 18, 2006 5:21 am **Posts:** 6

Is is at all possible?

albert_gorski · **Posted:** Tue Sep 26, 2006 10:53 am

Hi,

try to use filters - I think it solves your problem.

Greetings,
Albert

newbe · **Joined:** Mon Sep 18, 2006 5:21 am **Posts:** 6

Perfect - thats what I exactly needed! Thanks a lot!

Best regards
John