Hmmm,
Why would I want it abstract?
Anyway, I put a qualifier in the root entity osType = 'All'
then the sql that was generated was:
DEBUG (ERXNSLogLog4jBridge.java:46) - evaluateExpression: <com.webobjects.jdbcadaptor._MySQLPlugIn$MySQLExpression: "SELECT RTRIM(t0.alertString), t0.appConfigAndroidID, t0.appConfigBBID, t0.appConfigIOSID, t0.appConfigWinID, t0.appConfigWinPhoneID, t0.appID, t0.badge, RTRIM(t0.cronExpression), t0.dateCompleted, t0.dateCreated, t0.dateToPush, t0.id, RTRIM(t0.message), t0.notificationAlertAppleID, RTRIM(t0.osType), RTRIM(t0.sound), t0.status, RTRIM(t0.title) FROM Notification t0 WHERE (t0.osType = ? OR t0.osType = ? OR t0.osType = ? OR t0.osType = ? OR t0.osType = ? OR t0.osType = ?)" withBindings: 1:"ALL"(osType), 2:"IOS"(osType), 3:"BB"(osType), 4:"ANDROID"(osType), 5:"WIN8PHONE"(osType), 6:"WINDOWS"(osType)>
Which works!
You da man like always!
James
|