CrashCourse 10.2.5 OQL error CE0174

1
I am getting ‘CE0174 – Error(s) in OQL query, element – ‘ When I open the dataset the OQL actually has no errors, I am at a loss to understand what that – means? OQL seems perfectly well formed... element - SELECT D.Name DepartmentName, COUNT(S/id) Number FROM userManager.shift S JOIN S/userManager.shift_Department/userManager.Department D LEFT OUTER JOIN S/userManager.shift_Employee/userManager.Employee E WHERE E/ID = NULL GROUP BY D.Name   Mendix studio 9.11 (but that option is not available here)    
asked
4 answers
0

Running into the exact same issue also on 9.11.0 (Build 39533) running on a Mac w/ M1.

I fixed a few issues with the OQL given, as several things seemed plain wrong or didn't align with prior instructions:

  • D.Name should be D/Name,
  • S/id should be S/ShiftId
  • E/ID should be E/EmployeeId
  • = NULL should probably be IS NULL

This is the final OQL I used:

SELECT D/Name DepartmentName, COUNT(S/ShiftId) Number
FROM UserManager.Shift S
JOIN S/UserManager.Shift_Department/UserManager.Department D
LEFT OUTER JOIN S/UserManager.Shift_Employee/UserManager.Employee E
WHERE E/EmployeeId IS NULL
GROUP BY D/Name

Nothing worked and very frustrating that no further details are given... But even simple OQL qeries didn't work like:

SELECT E/Firstname
FROM UserManager.Employee E

Then I updated to 9.11.1 and the error is gone...

answered
1

Where E.Id IS NULL

answered
0

 

 

copy an

answered
0

SELECT D.Name DepartmentName,COUNT(S/id) Number FROM UserManager.Shift S JOIN S/UserManager.Shift_Department/UserManager.Department D LEFT OUTER JOIN S/UserManager.Shift_Employee/UserManager.Employee E WHERE E/ID = NULL GROUP BY D.NameSELECT D.Name DepartmentName,COUNT(S/id) Number FROM UserManager.Shift S JOIN S/UserManager.Shift_Department/UserManager.Department D LEFT OUTER JOIN S/UserManager.Shift_Employee/UserManager.Employee E WHERE E/ID = NULL GROUP BY D.Name

answered