It looks like your last ) is outside the string. I'm thinking it should be +",%\"))"; Try building the string in the Advanced Search bar as a test. Fred
________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of madhavi d Sent: Wednesday, December 26, 2007 9:52 AM To: [email protected] Subject: Re: Qualification String in ARS Java API ** 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___ __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"
