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
---
