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
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.516 / Virus Database: 269.17.8/1195 - Release Date: 12/24/2007
11:19 AM
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
