Another way of doing what amounts to a case function is to have your active links or filters in a guide. Each link or filter has a "Run If" statement, then it takes whatever action you want, and exits the guide. At the very end you can have a default that runs no matter what.
Dwayne Martin James Madison University ---- Original message ---- >Date: Tue, 13 Nov 2007 10:07:37 -0800 >From: Thad K Esser <[EMAIL PROTECTED]> >Subject: Re: Is a Case function possible in Remedy? >To: arslist@ARSLIST.ORG > > ** > Pete, > > As Matt mentions, if you are trying to convert a > number to a specific string, you can have all kinds > of fun just using a single set fields. For example, > if $IntegerField$ is a number from 1-12, you can > convert it to a month with the following set fields > into a string: > RTRIM(SUBSTR( "January February March April > May June July August > SeptemberOctober November December ", > ($IntegerField$ - 1) * 9, (($IntegerField$ - 1) * 9) > + 8)) > > If you really want to go gangbusters with this > approach search the archives for "conversion to > julian date" to see what's possible. > Thad Esser > Remedy Developer > "Argue for your limitations, and sure enough, > they're yours."-- Richard Bach > > "Carey Matthew Black" To arslist@ARSLIST.ORG > <[EMAIL PROTECTED]> cc > Sent by: "Action Subject Re: Is a Case > Request System function possible in > discussion Remedy? > list(ARSList)" > <arslist@ARSLIST.ORG> > > 11/13/2007 09:18 AM > > +---------------------+ > | Please respond to | > | arslist@ARSLIST.ORG | > +---------------------+ > > Peter, > > Another variation on that is to use a filter on Get > Entry and a > Display only field. That way the Set field action > simply returns the > 'Display Only' field and the filters in effect do > the "Case" operation > to map a value of 1 to "January" from the record > that is being > returned. > > Or... > If the integer value is actually a Selection field > then I think that > field can do the map to an English string by simply > returning the > value to a Char field instead of an Integer field. > > However those solutions make some assumptions about > how you are using > the case statement too. (maybe they apply maybe they > do not.) > > -- > Carey Matthew Black > Remedy Skilled Professional (RSP) > ARS = Action Request System(Remedy) > > Love, then teach > Solution = People + Process + Tools > Fast, Accurate, Cheap.... Pick two. > > On Nov 13, 2007 11:45 AM, Eric Cleereman (IT) > <[EMAIL PROTECTED]> wrote: > > Hi Pete, > > > > Here are a couple options: > > > > 1. If your DB supports Case, you can do a set > fields using SQL. > > 2. You can store the values in a separate form, > then set the values from > > that. > > > > We use the second option, as it seems a lot easier > to maintain. We've > > got a form which stores the month in 4 fields. M > is 1-12, MM is 01-12, > > MMM is Jan-Dec, and MMMM is January-December. > This allows easy > > conversions between any of these formats. > > > > Eric Cleereman > > > > > > -----Original Message----- > > From: Action Request System discussion > list(ARSList) > > [mailto:[EMAIL PROTECTED] On Behalf Of Joran, > Peter P, CTR, OSD-CIO > > Sent: Tuesday, November 13, 2007 11:30 AM > > To: arslist@ARSLIST.ORG > > Subject: Is a Case function possible in Remedy? > > > > All > > Is there a way to do a case function, or something > like it, in remedy > > for a set fields action? > > > > For example: > > If 1 than January > > If 2 than February... > > > > Thanks > > Pete > > ARS 6.3 > > SQL Server 2000 > > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at > www.arslist.org > Platinum Sponsor: www.rmsportal.com ARSlist: "Where > the Answers Are" > > ***IMPORTANT NOTICE: This communication, including > any attachment, contains information that may be > confidential or privileged, and is intended solely > for the entity or individual to whom it is > addressed. If you are not the intended recipient, > you should delete this message and are hereby > notified that any disclosure, copying, or > distribution of this message is strictly prohibited. > Nothing in this email, including any attachment, is > intended to be a legally binding signature.*** > > __20060125_______________________This posting was > submitted with HTML in it___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"