Hi Nuria, you just need a simple combination of boolean filters ei 'expressed in tissue 1' yes no 'expressed in tissue 2' yes no
the user is supposed to click 'yes' twice this is supported and easy to configure. We usually use boolean columns in the main table that have precomputed values based on the content of dimension tables. the existing mart implementations have plenty of examples like that. please let me know if you need more pointers a On Wed, Sep 28, 2011 at 3:36 AM, <[email protected]> wrote: > ** > > Hi Arek,**** > > ** ** > > You are right, this select i also think would not work. But, let me explain > what kind of information I want to retrieve from my database. We store > information of probesets ID and in which tissues are expressed. If we want > to query which probesets are expressed in tissue 1 and tissue 2 (but not to > retrieve probesets expressed only in one of these two tissues), how could it > be the best way to do it? Maybe, the multiselect operation type of setting > for the tissue filter is not suitable for this kind of queries? Maybe is it > not possible to query this? **** > > ** ** > > Thank you!**** > > ** ** > > Regards,**** > > ** ** > > Núria**** > ------------------------------ > > *De:* Arek Kasprzyk [mailto:[email protected]] > *Enviado el:* martes, 27 de septiembre de 2011 18:13 > > *Para:* **QUERALT, NURIA** (IDIBAPS) > *CC:* [email protected] > *Asunto:* Re: [BioMart Users] MultiSelect operation > **** > > ** ** > > 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
