Tried using 1, C1 and $Request ID$ and using the field selection menu but $Request ID$ was not recognized. Maybe its time for plan B.
-----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Carey Matthew Black Sent: Thursday, November 15, 2007 10:09 AM To: [email protected] Subject: Re: Is a Case function possible in Remedy? Peter, Unless you have a field with a Database Name of "C1" that would not work. (You likely mean $Request ID$ or $Entry-Id$, or some such field name like that.) -- 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 15, 2007 10:02 AM, Joran, Peter P, CTR, OSD-CIO <[EMAIL PROTECTED]> wrote: <snip> > This does not work > > SELECT C536870937, > CASE > WHEN C536870937 = '1' THEN 'January' > WHEN C536870937 = '2' THEN 'February' > WHEN C536870937 = '3' THEN 'March' > ELSE 'Unknown' > END > Month2 > FROM T689 > WHERE C1 = $C1$ > > Pete _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
smime.p7s
Description: S/MIME cryptographic signature
