On 6 Oct 2006, at 09:52, Richard Holland wrote:
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
OR and NOT are not implemented anywhere in the BioMart API. The API
only
understands AND.
Therefore, MartShell can only use AND as it depends on the API to run
the queries for it.
yep, explicit 'OR's were not implemented for performance reasons.
We still of course use implicit 'OR's in thing like inlists eg " ...
where sth in ('a','b','c')"
a.
cheers,
Richard
[EMAIL PROTECTED] wrote:
Hello,
Can any one please tell me how could I use 'OR' and 'NOT' in MQL
query. I
tried to execute the following command and got an error :
using Experiment get experiment_id_key where experiment_id_list in (
71083332 , 55469532 , 47580420 ) OR arraydesign_name like q(%Mouse%);
Error:
Invalid Query Recieved, invalid filter statement in where clause:
using
Experiment get experiment_id_key where experiment _id_list in (
71083332 ,
55469532 , 47580420 ) OR arraydesign_name like q(%Mouse%)
--AL-Mamun
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.2.2 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
iD8DBQFFJhlH4C5LeMEKA/QRAtyBAKCHxYqkAL7GBKZRD+2EpZYCgNMQbACeJvbE
AfCRzFRBlKhZv9AUn0/xd3g=
=0N0o
-----END PGP SIGNATURE-----
------------------------------------------------------------------------
-------
Arek Kasprzyk
EMBL-European Bioinformatics Institute.
Wellcome Trust Genome Campus, Hinxton,
Cambridge CB10 1SD, UK.
Tel: +44-(0)1223-494606
Fax: +44-(0)1223-494468
------------------------------------------------------------------------
-------
