Hello!

We try to use HQL first time and found exception. What does this "Path
expected for join!" means ? Path is a string not null property. Wwe
try to use this HQL to find Persons within Department rootDepartment
and not in subdepartments.


Path expected for join! [
                select p
                from
                Helpdesk.Person p
                left join Department d on p.Path like d.Path +
cast(d.Id as String) + '/%'
                where
                p.Path like :rootDepartmentPath2 + '%'
                and d.Path like :rootDepartmentPath2 + '%'
                and d is null
                ]

Thanks.

-- 
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.

Reply via email to