Hi,
There is another way, and that is to use the like-operator:
('Field' LIKE "__________%")
Ten underscores means that you will match everything that is 10 characters
or over.
I guess you can fit 500 underscores in there ase well.
NOT ('Field' LIKE "__________%") will match 9 characters or lower.
If you do searches like this to the database, it may behave differently,
but if you do it in a FLTR/ACTL run-if-statement, it will not be affected
by the database.
Best Regards - Misi, RRR AB, http://www.rrr.se
Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10):
* RRR|License - Not enough Remedy licenses? Save money by optimizing.
* RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs.
Find these products, and many free tools and utilities, at http://rrr.se.
> Unfortunately that’s how it is designed.. Those functions are not
> available at the Run If level. Functions whose result is not a void but a
> value are used in set field / push field kind of operations..
>
> Only KEYWORDS can be used in Run If qualifications directly to be
> evaluated in an expression..
>
> Cheers
>
> Joe
>
> From: Ramey, Anne
> Sent: Monday, March 14, 2011 10:55 PM
> Newsgroups: public.remedy.arsystem.general
> To: arslist@ARSLIST.ORG
> Subject: Re: Active link to check field size
>
> Bummer. I was hoping it didn’t have to be a 2 step process. Thanks
>
>
>
> Anne Ramey
>
> ***********************************
>
> E-mail correspondence to and from this address may be subject to the North
> Carolina Public Records Law and may be disclosed to third parties only by
> an authorized State Official.
>
>
>
> From: Action Request System discussion list(ARSList)
> [mailto:arslist@ARSLIST.ORG] On Behalf Of Joe Martin D'Souza
> Sent: Monday, March 14, 2011 10:50 PM
> To: arslist@ARSLIST.ORG
> Subject: Re: Active link to check field size
>
>
>
> **
>
> Anne,
>
>
>
> You are close but not quite that close...You can’t use it that way in a
> qualification..
>
>
>
> Those functions are set field functions that can be used only in set or
> push fields actions..
>
>
>
> So create a temp integer field to hold the value of LENGTH(‘Field’) and
> then use that temp field in the qualification in an active link that runs
> in an order after the first active link..
>
>
>
> Hope this helps..
>
>
>
> Cheers
>
>
>
> Joe
>
>
>
> From: Ramey, Anne
>
> Sent: Monday, March 14, 2011 10:18 PM
>
> Newsgroups: public.remedy.arsystem.general
>
> To: arslist@ARSLIST.ORG
>
> Subject: Active link to check field size
>
>
>
> **
>
> I must be being dense, but I’m trying to write an active link that only
> fires if a field is more than a certain length. Can’t figure out how to
> do that. Know how to trim it and set the length, but not check it in the
> qualification. I tried this
>
> LENGTH(‘Field’) > 500
>
> But it didn’t like that.
>
>
>
> Anne Ramey
>
> ***********************************
>
> E-mail correspondence to and from this address may be subject to the North
> Carolina Public Records Law and may be disclosed to third parties only by
> an authorized State Official.
>
> _______________________________________________________________________________
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
>
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
