Hi Arek, Sorry for the delay, I had to attend to other matters.
The ID List isn't really what I am looking for because I need the ability to perform "LIKE" queries. Can you do this with the ID list box? I was under the impression that it only does '=' or 'in'. I think your description of a push action filter without the second drop down is accurate. Essentially what I want to do is store different types of data in one table. Then I would like to be able to search a subset of the data in this table by differentiating on its type. The problem I ran into was with cases where a user might want to query on two filters that use the same table. This would create a conflicting SQL query that would never return hits. You could get around this by using a sub select or a UNION but I don't think BioMart supports these. At this point I need to rethink my plan a bit. I'll let you know if I have any more questions. Thanks, Josh Arek Kasprzyk wrote: > > On 5 Apr 2007, at 19:16, Arek Kasprzyk wrote: > >>> In mySQL I was planning to implement this data essentially the same >>> as it is in >>> Chado currently. That is one table, called 'synonym' in Chado, that >>> has a name >>> field to store the value and a type field that distinguishes between >>> a name >>> synonym and a symbol synonym. >>> >>> Is it possible to do this without splitting up each synonym type into >>> individual >>> dimension tables? >>> >> >> Hi Josh, >> can you look at ensembl mart, homo sapiens genes, filter, gene, "ID >> LIst limit"? on www.biomart.org >> Is this the kind of thing you are looking for or you are thinking >> about something completely different? :) >> >> > > > hang on .... I think I know what you mean .... :) > it would work like a push action filter but instead of second drop > dropdown > would have a text box, right? > > a. > > ------------------------------------------------------------------------------- > > 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 > ------------------------------------------------------------------------------- > > >
