You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@ofbiz.apache.org by Bejoy Zac <be...@tarangtech.com> on 2007/03/12 10:08:41 UTC

Case Insensitive query option

Hi All,

While fectching the data is there any way to ignore the case?
-- 
View this message in context: http://www.nabble.com/Case-Insensitive-query-option-tf3388012.html#a9430733
Sent from the OFBiz - User mailing list archive at Nabble.com.

Re: Case Insensitive query option

Posted by Jonathon -- Improov <jo...@improov.com>.

Benjoy,

Simply capitalize (convert to upper case) both operands you're comparing.

Eg, ... WHERE UPPER(field) = UPPER(value)

If you're using Java, you could do:

  new EntityFunction.UPPER(new EntityFieldValue(fieldName))

In Minilang, try <condition-expr>, attribute "ignore-case" true.

Jonathon

Bejoy Zac wrote:
> Hi All,
> 
> While fectching the data is there any way to ignore the case?