Clever, Misi.
Anne, you are checking length of any text that might be on the field (ie field
value length), and not the database (max) length of the field, right? If yes,
Misi has got the perfect solution for you.
I was trying to do the latter in a weird AL loop I had set up and remember
struggling with it.
--- On Tue, 3/15/11, Misi Mladoniczky <m...@rrr.se> wrote:
> From: Misi Mladoniczky <m...@rrr.se>
> Subject: Re: Active link to check field size
> To: arslist@ARSLIST.ORG
> Date: Tuesday, March 15, 2011, 3:04 AM
> 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"
>
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
