I made below change and tested it, but still problem persists.
-Madhavi
On Dec 24, 2007 3:29 PM, Joe D'Souza <[EMAIL PROTECTED]> wrote:
> ** Madhavi,
>
> NOT LIKE is not a operator - NOT and LIKE are two separate independent
> operators. Try separating them in your qualification i.e. NOT('Column'
> LIKE (rest of the qualification))) instead of what you are doing at the
> moment.
>
> I'm not quite sure what you are trying to do, but your qualification
> should have been more like:
> qualString = "\'Approval Status\' = \"Pending\" and *NOT* ((\'Users\' *
> LIKE* \""+UserPIN+"\") OR (\'Users\' *LIKE* \""+UserPIN+",%\") OR
> (\'Users\' *LIKE* \"%,"+UserPIN+"\") OR (\'Users\'
> *LIKE*\"%,"+UserPIN+",%\")");
>
> Let me know if this helps..
>
> Cheers
>
> Joe
>
> -----Original Message-----
> *From:* Action Request System discussion list(ARSList) [mailto:
> [EMAIL PROTECTED] Behalf Of *madhavi d
> *Sent:* Monday, December 24, 2007 3:49 PM
> *To:* [email protected]
> *Subject:* Qualification String in ARS Java API
>
> ** Hi,
>
> I have developed a custom application using ARS Java API 6.3.
> I want to use a qualification in Java API with "NOT LIKE" to check the
> value. But I am getting an error while using NOT LIKE in qualification
> string. Following qualification string works fine with "LIKE" but not with
> "NOT LIKE".
>
> Following is the qualification string that I am using:
>
> qualString = "\'Approval Status\' = \"Pending\" and (\'Users\' *NOT
> LIKE*\""+UserPIN+"\" OR \'Users\'
> *NOT LIKE* \""+UserPIN+",%\" OR \'Users\' *NOT LIKE* \"%,"+UserPIN+"\" OR
> \'Users\' *NOT LIKE* \"%,"+UserPIN+",%\")";
>
> Please advice, how can I check the value in the qualification with "NOT
> LIKE" condition.
>
> Thanks & Regards,
> Madhavi
>
> __20060125_______________________This posting was submitted with HTML in
> it___
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
