• 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
empty relationship qualifier question
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

empty relationship qualifier question


  • Subject: empty relationship qualifier question
  • From: "Michael Bushkov" <email@hidden>
  • Date: Fri, 4 Jul 2008 12:32:34 +0400

Hi,
I have quite simple task, but I don't see any proper solution. The
task is as follows:
I have 2 entities - Song and Track. Song has a one-to-many
relationship to Track (Song->tracks). And I need to fetch all songs
which have no tracks. That's all - plain and simple.

I've looked through the list of available qualifiers and even started
to write one by myself, but it looks like an overkill for such a
simple task. The straightforward solution, that I see is to cache
number of tracks in Song entity (make a Song->tracksNumber field). But
it looks like modifying model for implementation purposes (this
however can be very effective on large datasets, because such database
structure doesn't require using subqueries to find songs with no
tracks).

Any suggestions are greatly appreciated )

--
With best regards,
Michael Bushkov
 _______________________________________________
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: empty relationship qualifier question
      • From: Pierre Bernard <email@hidden>
  • Prev by Date: Re: DB uniqueness constraints and dealing with them
  • Next by Date: Re: WOXMLCoder uses objectIDRef for mutable objects
  • Previous by thread: Re: ERXLocalizer getting rid of the binding errors?
  • Next by thread: Re: empty relationship qualifier question
  • Index(es):
    • Date
    • Thread