Re: Custom EOQualifier
Re: Custom EOQualifier
- Subject: Re: Custom EOQualifier
- From: Aaron Rosenzweig via Webobjects-dev <email@hidden>
- Date: Fri, 30 Aug 2024 17:43:17 -0400
I agree with Xavier. Try it and see how it goes. You should be able to use the
existing qualifier and it will work.
Here’s a summary of things to try:
1) QualifierOperatorCaseInsensitiveLike - it should work.
2) Derived attribute - you can do “upper” in a derived attribute and then in
java upper case the string and do an “equals” comparison
3) Create custom collation in the DB for that column so that it is case
insensitive
I ordered them by how easy to implement. First one is the easiest and third one
is hardest but could be more performant in a large table.
> On Aug 30, 2024, at 10:40 AM, Xavier (WO) via Webobjects-dev
> <email@hidden> wrote:
>
> Hi André,
>
> You shouldn’t need to do anything, your String will be called as a variable,
> the EOQualifer will escape the problematic characters for you.
>
> Xavier
>
>
>> On 30 Aug 2024, at 16:17, André Rothe <email@hidden> wrote:
>>
>> Hi Xavier,
>>
>> How I can escape the wildcards, with a backslash? I did not find any
>> information about that.
>>
>> Thank you
>> André
>>
>>
>> Am 30.08.2024 15:24, schrieb Xavier (WO):
>>> Hello André,
>>> Didi you actually try to use the regular
>>> QualifierOperatorCaseInsensitiveLike, I’d say that it would “escape” the
>>> special characters in the Strings so your “*” shouldn’t be an issue.
>>> Xavier
>>>> On 30 Aug 2024, at 15:06, André Rothe via Webobjects-dev
>>>> <email@hidden> wrote:
>>>> Hi,
>>>> I need a custom EOQualifier, which executes for Strings in an Oracle
>>>> database
>>>> WHERE UPPER(table.aStr) = UPPER(bStr)
>>>> (compare both Strings in uppercases). A
>>>> QualifierOperatorCaseInsensitiveLike will not work, because the Strings
>>>> could contain "*", but these should not act as wildcards.
>>>> How I can build such a class?
>>>> Greetings
>>>> André
>>>> _______________________________________________
>>>> Do not post admin requests to the list. They will be ignored.
>>>> Webobjects-dev mailing list (email@hidden)
>>>> Help/Unsubscribe/Update your Subscription:
>>>> This email sent to email@hidden
>>
>
> _______________________________________________
> Do not post admin requests to the list. They will be ignored.
> Webobjects-dev mailing list (email@hidden)
> Help/Unsubscribe/Update your Subscription:
>
> This email sent to email@hidden
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden