On 18 Jul 2007, at 17:06, Vallejos, Andrew wrote:
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.
do you mean update on 0.4 changes 'ike' to '='?
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.
yes, there is in 0.4 (set to 200 as far as I remember) .This has now
been removed in 0.6
We can point you to the bit of code in MEditor 0.4 which does the
check, you can comment
this out if you want
a.
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
-----------------------------------------------------------------------
-
-------
------------------------------------------------------------------------
-------
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
------------------------------------------------------------------------
-------
