"and" with multivalued fields in AQL

Dave Matthews matthews at greengenes.cit.cornell.edu
Tue May 8 04:27:57 EST 2001


Hi fellow AQL fans,

This has been driving me nuts for a couple days so it's time to ask for help
even if it is just a blind spot/stupidity on my part.  Hoping somebody will
be kind and clarify for me.  

What I'm trying to do is like this:
 find papers written by author1 and author2
 find papers written by author1 and not author2

For a working example, in the database at ars-genome.cornell.edu -port 2000, 
Anderson has 34 papers of which 3 were coauthored with Yip.  Yip has 3
papers.

The old query language gives correct results:
 query find Reference Author = "Anderson OD" AND Author = "Yip RE"  // -> 3 
 query find Reference Author = "Anderson OD" AND NOT Author = "Yip RE" // -> 31

AQL gives:

 select R from R in class Reference \
 where R->Author = "Anderson OD" and R->Author = "Yip RE"   // -> 0

 select R from R in class Reference \
 where R->Author = "Anderson OD" and not R->Author = "Yip RE"   // -> 34


Same results in ace4_7g and ace4_9a.

I went through the documentation and examples at
http://www.acedb.org/Software/whelp/AQL/.  No examples quite like my case.
The docs seem consistent with what what I'm trying.

- Dave

---





More information about the Acedb mailing list