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" <[EMAIL PROTECTED]> Sent by: "Action Request System discussion list(ARSList)" <[email protected]> 11/13/2007 09:18 AM Please respond to [email protected] To [email protected] cc Subject Re: Is a Case function possible in Remedy? 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: [email protected] > 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.*** _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
