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:[email protected]] On Behalf Of kiran
> Sent: Wednesday, September 02, 2009 8:15 AM
> To: [email protected]
> 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: [email protected] ARSlist: "Where the Answers
> Are"_
>
> _______________________________________________________________________________
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> Platinum Sponsor:[email protected] 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:[email protected] ARSlist: "Where the Answers Are"
