Re: qualifier with NOT
Re: qualifier with NOT
- Subject: Re: qualifier with NOT
- From: Johann Werner <email@hidden>
- Date: Tue, 20 Sep 2011 00:39:21 +0200
Am 19.09.2011 um 22:52 schrieb Theodore Petrosky:
> Great thanks, but how to add the wildcard character?
>
> _grossBillingList = jobinv.fetchJobInvs(theEC, jobinv.GLPER.eq(glPeriod). and (ERXQ.not(jobinv.JOBNUM.likeInsensitive("SP%"))), null);
I think you should use '*' instead of '%' in those qualifiers -> ERXQ.not(jobinv.JOBNUM.likeInsensitive("SP*"))
>
> this query works great:
> select SUM(invamt) "InvTotal" from job_inv where glper = '201108' and jobnum not like 'SP%';
>
> I must be missing some escaping of the character.
>
> Ted
>
>
> --- On Mon, 9/19/11, Kieran Kelleher <email@hidden> wrote:
>
>> From: Kieran Kelleher <email@hidden>
>> Subject: Re: qualifier with NOT
>> To: "Theodore Petrosky" <email@hidden>
>> Cc: email@hidden
>> Date: Monday, September 19, 2011, 1:47 PM
>> One (of probably multiple) way(s)
>> is:
>>
>> jobinv.GLPER.eq(glPeriod). and ( ERXQ.not(
>> jobinv.JOBNUM.ilike("SP Conv") ) )
>>
>> On Sep 19, 2011, at 12:21 PM, Theodore Petrosky wrote:
>>
>>> OK.. I am giving up and asking
>>>
>>> I need to .not() part of a qualifier
>>>
>>> jobinv.GLPER.eq(glPeriod). and
>> (jobinv.JOBNUM.ilike("SP Conv"))
>>>
>>> but I want isNOTlike
>>>
>>> in testing the SQL I used:
>>>
>>> SELECT clcode, invamt "InvTotal", jobnum, jobinvnum
>> FROM job_inv WHERE glper = '201108' AND jobnum NOT LIKE 'SP
>> CONV%'
>>>
>>> I don't understand how to use not() in the above
>> qualifier.
>>>
>>> Ted
>>> _______________________________________________
>>> 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