Arek, >hmm ... that's a bit annoying I admit. We can think about something >more clever for the future but for now could >you get away with some global replace or would it not work for you?
I'm trying to get around the comma issue by replacing all the commas in the value field with '%' and changing the qualifier to LIKE from '='. This works, however the update command on the mart editor (v0.4, we still cannot get v0.6 to run) automatically undoes all of my changes. On a related topic, is there an maximum number of filter options allowed? I just received a warning "Too many Options for filter" when trying to restart our mart. Thanks, Andrew -----Original Message----- From: Arek Kasprzyk [mailto:[EMAIL PROTECTED] Sent: Saturday, July 14, 2007 4:42 AM To: Vallejos, Andrew Cc: [email protected] Subject: Re: [mart-dev] Question on Filter Values On 13 Jul 2007, at 21:58, Vallejos, Andrew wrote: > > All, > > I have a simple question here. Does a comma pose any problem when in > a filter value? > > I ask, because I have a filter list. One of the values in the filter > list is "Anemia, Sickle Cell". However, I only get results whose > value is "Anemia". Basically the value is truncated after the comma. > This is the same for all values with a comma, which unfortunately is a > lot of them. > hmm ... that's a bit annoying I admit. We can think about something more clever for the future but for now could you get away with some global replace or would it not work for you? a. > Thanks, > > Andrew > > -- > > Andrew Vallejos > Web Developer, Biotechnology and Bioengineering Center > Medical College of Wisconsin > 8701 Watertown Plank Road > Milwaukee, WI, USA > Phone: (414) 955-4104 > Email: [EMAIL PROTECTED] > > ------------------------------------------------------------------------ ------- 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 ------------------------------------------------------------------------ -------
