Hi all, I’m following the new crash course and am getting an error in the provided OQL query. The query is provided in lecture 10.2.3: SELECT Name DepartmentName, COUNT(ID)Number FROM UserManager.Shift2 JOIN UserManager.Shift2_PlanningPeriod/UserManager.PlanningPeriod/UserManager.PlanningPeriod_Department/UserManager.Department LEFT OUTER JOIN UserManager.Shift2_Employee/UserManager.Employee WHERE ID = NULL GROUP BY Name, ID The error is: cannot resolve path part ‘ID’. The idea is to find unused shifts per department, where there is no employee assigned (hence, HAVING E/ID = NULL). In the course the instruction is to use the expression below but it is not working as well I don t have big experience in coding, an help would be appreciated :) Thanks!
Make ID smallcaps: id
Tim van Steenbergen
thx for feedback! tried already.. I tried almost everything in order to change that but I get always some error..
Thx for your help!
Dont know if you are still interested, but try this:
SELECT D.Name DepartmentName, COUNT(S/id) Number
FROM UserManager.Shift S
JOIN S/UserManager.Shift_PlanningPeriod/UserManager.PlanningPeriod/UserManager.PlanningPeriod_Department/UserManager.Department D
LEFT OUTER JOIN S/UserManager.Shift_Employee/UserManager.Employee E
WHERE S/UserManager.Shift_Employee = NULL
GROUP BY D.Name