Dear Arek,
I tried to configure the filter type in the configuration with the 'multiSelectBoolean' option, but it seems not to work quite well. Is this the way to configure the multiselect operation as you described me on the below email? Núria ________________________________ De: Arek Kasprzyk [mailto:[email protected]] Enviado el: miércoles, 28 de septiembre de 2011 19:18 Para: QUERALT, NURIA (IDIBAPS) CC: [email protected] Asunto: Re: [BioMart Users] MultiSelect operation 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
