Fred: Here's another option. You are trying to do a CASE function, but this one happens to be a special kind that ARS can do its own way.
Do a set field: DATENAME("mm","1 January 2007" + $Field With Month As A Number$ * 28) You will get January, February etc If you use "MM" instead of "mm", you will get If your field $Field With Month As A Number$ is not an integer, you will have to play around to get this to work. Thad's idea is a supertb one for general CASE functions, when you are dealing with values other than months. Very clever. --- "Joran, Peter P, CTR, OSD-CIO" <[EMAIL PROTECTED]> wrote: > I thought I tried that, but evidently not. It > works!! > > Many Thanks Fred! > > Pete > > -----Original Message----- > From: Action Request System discussion list(ARSList) > [mailto:[EMAIL PROTECTED] On Behalf Of Grooms, > Frederick W > Sent: Thursday, November 15, 2007 10:26 AM > To: arslist@ARSLIST.ORG > Subject: Re: Is a Case function possible in Remedy? > > Oops ... It should have been WHERE C1 = '$1$' > > Or WHERE C1 = '$Request ID$' > > Since it is a character string it must be enclosed > in single quotes > > > -----Original Message----- > From: Action Request System discussion list(ARSList) > [mailto:[EMAIL PROTECTED] On Behalf Of Joran, > Peter P, CTR, OSD-CIO > Sent: Thursday, November 15, 2007 9:21 AM > To: arslist@ARSLIST.ORG > Subject: Re: Is a Case function possible in Remedy? > > Tried that too Fred. > > Thanks for the thought > > Pete > > -----Original Message----- > From: Action Request System discussion list(ARSList) > [mailto:[EMAIL PROTECTED] On Behalf Of Grooms, > Frederick W > Sent: Thursday, November 15, 2007 10:11 AM > To: arslist@ARSLIST.ORG > Subject: Re: Is a Case function possible in Remedy? > > Make your Where clause > > WHERE C1 = '$C1$' > > Fred > > -----Original Message----- > From: Action Request System discussion list(ARSList) > [mailto:[EMAIL PROTECTED] On Behalf Of Joran, > Peter P, CTR, OSD-CIO > Sent: Thursday, November 15, 2007 9:03 AM > To: arslist@ARSLIST.ORG > Subject: Re: Is a Case function possible in Remedy? > > All > Interesting responses and many thanks for the input. > The list never lets > me down and for that I'm very grateful!! > > I was hoping to use a simple single AL. Direct SQL > was my first choice > and it works great IF... I put a WHERE clause at the > end of the > statement with a specific request ID. Any ideas on > how to make a direct > SQL call look at the 'CURRENT TRANSACTION'? > > > This works > > 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 = '000000000000006' > > 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 > > -----Original Message----- > From: Action Request System discussion list(ARSList) > [mailto:[EMAIL PROTECTED] On Behalf Of Rick Cook > Sent: Tuesday, November 13, 2007 8:42 PM > To: arslist@ARSLIST.ORG > Subject: Re: Is a Case function possible in Remedy? > > I think I would use a Guide structure to emulate the > Case. That way, > you would drop out of the guide when a condition > that was present in the > Run If quals of all of the Als/Filters in the Guide > was met, and it > would only be set when it ran the matching WF > object. > > Rick > > -----Original Message----- > From: Action Request System discussion list(ARSList) > [mailto:[EMAIL PROTECTED] On Behalf Of Michiel > Beijen > Sent: Tuesday, November 13, 2007 1:19 PM > To: arslist@ARSLIST.ORG > Subject: Re: Is a Case function possible in Remedy? > > If your example is really as simple as " if 1 then > January..." try this: > * create a drop-down field with values 1 - 12 and > add the months > * set the integer to this field - it will display > your textual value. > If you would do another set fields from your drop > down field to a char > field; you'll have the textual value in the char > field. > > Regards, > > Michiel > > On Nov 13, 2007 8:26 PM, Dwayne Martin > <[EMAIL PROTECTED]> wrote: > > 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? > === message truncated === ____________________________________________________________________________________ Be a better sports nut! Let your teams follow you with Yahoo Mobile. Try it now. http://mobile.yahoo.com/sports;_ylt=At9_qDKvtAbMuh1G1SQtBI7ntAcJ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"