Hi Mamun Could you please rewrite the same queries using 'or' otherwise avoiding spaces in you species name in your datasets. looks to me a possible solution. Although you query looks fine to me, but i would still recommend you to have a look at documentation page 15 (-Filter List, 'b' and 'c'). Hope that would work.
Cheers Syed On Tue, 2006-07-18 at 16:09 +0100, Hawlader Al-Mamun wrote: > Hi, > Can any one tell me how to execute a mart query with in key words. I > need all the experiment id involving either Species1 or Species2. I > tried with the following but there is no output. > > MartShell> using DWD.Experiment get experiment_id_key, sample_species > where sample_species in q(Schizosaccharomyces pombe); //this is working > > all of the following are not working: there is no error message. But I'm > > expecting some output. But no output. > > MartShell> using DWD.Experiment get experiment_id_key, sample_species > where sample_species in q(Schizosaccharomyces pombe, Homo sapiens); > > MartShell> using DWD.Experiment get experiment_id_key, sample_species > where sample_species in q(Schizosaccharomyces pombe,Homo sapiens); > > MartShell> using DWD.Experiment get experiment_id_key, sample_species > where sample_species in q(Schizosaccharomyces pombe , Homo sapiens); > > MartShell> using DWD.Experiment get experiment_id_key, sample_species > where sample_species in (Schizosaccharomyces pombe , Homo sapiens); > > MartShell> using DWD.Experiment get experiment_id_key, sample_species > where sample_species in (Schizosaccharomyces pombe, Homo sapiens); > > Thanks. > > --Mamun > Trainee, EBI > > > -- ====================================== Syed Haider. EMBL-European Bioinformatics Institute Wellcome Trust Genome Campus, Hinxton, Cambridge CB10 1SD, UK. ======================================
