Peter, The your "Field ID =1" field has been renamed to something else. Find the field in the Admin tool by:opening the form and using the field ID drop down at the top of the form. That should tell you what the field is called.
However, the solution to use the value of $1$ should work too. In that case your using the field's ID (number) instead of the field's database name (string). However the two work interchangeably in this case. (Actually the ID has one advantage that I can think of. If you later change the name of the field you will not need to update the Direct SQL action.) -- 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:17 AM, Joran, Peter P, CTR, OSD-CIO <[EMAIL PROTECTED]> wrote: > 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"
