• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Re: more on the Vertical Inheritance, the sql
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: more on the Vertical Inheritance, the sql


  • Subject: Re: more on the Vertical Inheritance, the sql
  • From: James Cicenia <email@hidden>
  • Date: Sat, 26 Jan 2013 19:12:47 -0600

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

Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (email@hidden) Help/Unsubscribe/Update your Subscription: This email sent to email@hidden
  • Follow-Ups:
    • Re: more on the Vertical Inheritance, the sql
      • From: Chuck Hill <email@hidden>
References: 
 >more on the Vertical Inheritance, the sql (From: James Cicenia <email@hidden>)
 >Re: more on the Vertical Inheritance, the sql (From: Ken Anderson <email@hidden>)
 >Re: more on the Vertical Inheritance, the sql (From: James Cicenia <email@hidden>)
 >Re: more on the Vertical Inheritance, the sql (From: Chuck Hill <email@hidden>)

  • Prev by Date: Re: more on the Vertical Inheritance, the sql
  • Next by Date: ERD2WWizardCreationPage Rules for Creation vs Editing
  • Previous by thread: Re: more on the Vertical Inheritance, the sql
  • Next by thread: Re: more on the Vertical Inheritance, the sql
  • Index(es):
    • Date
    • Thread