> 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
>
I've tried rephrasing your query in a different way but I still run into
the same problem. If I try:
select all class Reference where ->Author.name = "Anderson OD" // -> 34
select all class Reference where ->Author.name = "Anderson OD" and
->Author.name = "Yip RE" // -> 0
select all class Reference where ->Author.name = "Anderson OD" and not
->Author.name = "Yip RE" // -> 34
I can't see why this doesn't work...if I use 'or' rather than 'and' then
the expression seems to evaluate correctly. In the context of your data
it doesn't make too much sense to use 'or' but I tried an AQL query on my
database which was essentially 'Find all Papers; Find author x or y' and
it finds both, but '...Find author x AND y' doesn't work, nor does
'...Find Author x and not y'.
I'm stumped Dave.
Keith
~ Keith Bradnam - UK CropNet (http://ukcrop.net) webmaster and
~ Arabidopsis Genome Resource (http://ukcrop.net/agr) developer.
~
~ Nottingham Arabidopsis Stock Centre, University Park,
~ University of Nottingham, NG7 2RD, UK. Tel: (0115) 951 3091
