you'll need to provide the mappings as well. the first problem I see is you are writing hql the same way you would sql, which is not the case.
On Sep 16, 12:08 pm, alexey_baranov <[email protected]> wrote: > 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.
