Hi, Note that the query will not match fields where ('field' = $NULL$). NULL values are excluded if not addressed specifically.
If the field is "Required" this is not an issue of course. For an "Optional" field the query must be something like: (NOT 'field' LIKE "%value%" OR 'field' = $NULL$) Best Regards - Misi, RRR AB, http://www.rrr.se Products from RRR Scandinavia: * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. * RRR|Translator - Manage and automate your language translations. Find these products, and many free tools and utilities, at http://rrr.se. > You need to say NOT ('field' LIKE "%value%") > > but yes, it works :) > > _____ > > From: Action Request System discussion list(ARSList) > [mailto:arsl...@arslist.org] On Behalf Of kiran > Sent: Wednesday, September 02, 2009 8:15 AM > To: arslist@ARSLIST.ORG > Subject: How to give a query like "NOT LIKE" in remedy > > > ** > Hi, > > Will a query containing NOT LIKE work in remedy 6.3 > > Regards, > Kiran > _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers > Are"_ > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are" > > -- > This message was scanned by ESVA and is believed to be clean. > > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"