I have a BO called Node.
Attributes are
NodeName : Text
Children : Node
This is to build an organisation chart.
I know every persons Supervisor so I can create a Node for every person and then populate each Node's Children with Other Nodes that have this NodeName as a Supervisor.
So far so good.
Now I need to find the 1 person who is NOT a child of any other node. ie. The Boss.
Something like...
FIND Node WHER NOT(Node IN Node.Children)
That of course does not work but would appreciate anyone more skilled in query language than me to suggest what the query should be please.
