Hi Nuria, i am not sure if this would logically work. Your query multiselct with intersection would be equivallent to:
select bla, bla ... where id ="ABL" and id="BCR". this would not really work, would it? I would always return an empty set. or am i missing something? a On Tue, Sep 27, 2011 at 11:22 AM, <[email protected]> wrote: > ** > > Thanks for your fast reply!**** > > ** ** > > Ok, understood. Then, how could we configure martservice in order to query > the intersection among several options related to a same filter? Thanks > again!!**** > > ** ** > > Cheers,**** > > ** ** > > Núria**** > ------------------------------ > > *De:* Arek Kasprzyk [mailto:[email protected]] > *Enviado el:* martes, 27 de septiembre de 2011 17:04 > *Para:* **QUERALT, NURIA** (IDIBAPS) > *CC:* [email protected] > *Asunto:* Re: [BioMart Users] MultiSelect operation**** > > ** ** > > Hi Nuria, > 'multiselect' is a logical 'OR' (union). > > For multi-datasets multiselect this is implemented as paralel querying and > software 'unionizes' it for you, for intra dataset query e.g filter box, > this is translated to SQL 'in list' which is an equivalent of 'OR' (union). > > give us a shout if you need more info > > a**** > > On Tue, Sep 27, 2011 at 10:56 AM, <[email protected]> wrote:**** > > Dear all,**** > > **** > > I was wondering when a filter is configured as a multiselect operation > type, if the end-user is marking more than one option at the same query in > the multiselection box in the martexplorer, then how is done the filtering, > taking into account interaction (AND) among multi-selected options or union > (OR)?**** > > **** > > On the other hand, is it available the Human Metabolome DataBase as a mart? > Many thanks in advance.**** > > **** > > Kind regards,**** > > **** > > Núria**** > > **** > > **** > > > _______________________________________________ > Users mailing list > [email protected] > https://lists.biomart.org/mailman/listinfo/users**** > > ** ** >
_______________________________________________ Users mailing list [email protected] https://lists.biomart.org/mailman/listinfo/users
