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"
