"and" with multivalued fields in AQL

Keith Bradnam [NASC] keith at thale.nott.ac.uk
Wed May 9 07:20:32 EST 2001


> 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 







More information about the Acedb mailing list