• 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
Help with Search, may require outer joins??
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Help with Search, may require outer joins??


  • Subject: Help with Search, may require outer joins??
  • From: Owen McKerrow <email@hidden>
  • Date: Fri, 13 May 2005 13:51:58 +1000

Hi All,

Im having some trouble with a query to my database and was wondering if anyone could point me in the right direction.
Its a websites for entering details about academic publications. So the order in which the authors appears is important, i.e. there is an order and when every the publication is shown the authors need to be displayed in that order. This part works correctly. Its getting the publications which belong to a given user is where it gets tricky.


OK first the tables

Person <--->>Person Name ( in case someone ever changes their name, we need to remember their old name as that was what the book was published under)
Publication <--->> AuthorPubs <<---> Person Name ( A publication has many authors, which belong to a persons name. In AuthorPubs I store the order of the authors )
Publication <--->> EditorPubs <<---> Person Name ( A publication has many editors, which belong to a persons name. In EditorPubs I store the order of the editors )
Person <--->> Publication ( A Publication has 1 owner, i.e the user who entered the publication)


So what I want to do is ask the DB for all Publications belonging to a particular person. So any publication where they are either the owner, or an editor or an author.
I've made my fetch spec in EOModler so that


(personAuthorPubs.personName.person = $owner) OR (personEditorPubs.personName.person = $owner) OR (person = $owner)

However this is only returning publications for which I am the owner, not ones where I am an author or an editor but not the owner. If I remove the (person = $owner) attribute it only returns publications where I am the only editor or author, if there is more than 1 it doesn't come back.

Now I think this has to do with outer joins, but Im rusty when it comes to such things. Ive read up on teh web and in my Db book, but Im still not sure Im doing the right thing. As in I think I need the relationship from Publication to AuthorPubs and EditorPubs to be Left Outer joins, but when I try this I still get the same results.

Any ideas ?

Im using WO 5.2.3 and Openbase 8 ( sorry to everyone thats on both mailing lists who gets this twice)

Owen McKerrow
WebMaster, emlab
http://emlab.uow.edu.au

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

People who prefer typing to pointing then seem to prefer acronyms to save typing :-)
-Denis Stanton, On people using Command Line Interfaces


_______________________________________________
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: Help with Search, may require outer joins??
      • From: Pierre Frisch <email@hidden>
    • Re: Help with Search, may require outer joins??
      • From: Karl <email@hidden>
  • Prev by Date: Re: Making changes to EO after validation?
  • Next by Date: Re: Help with Search, may require outer joins??
  • Previous by thread: Re: Making changes to EO after validation?
  • Next by thread: Re: Help with Search, may require outer joins??
  • Index(es):
    • Date
    • Thread