Its all good Rabi :-) Caffeine is friend to many developers, myself included. However, I don't come close to a buddy that puts down 3 2 Litre bottles a day.
Have a great day! Pete -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Rabi Tripathi Sent: Thursday, November 15, 2007 1:10 PM To: [email protected] Subject: Re: Is a Case function possible in Remedy? I should have addressed previous post to Pete. And please ignore this sentence that I just left hanging because it doesn't make any difference: If you use "MM" instead of "mm", you will get I need to take some time off, but for now drinking some caffeine will have to do. --- Rabi Tripathi <[EMAIL PROTECTED]> wrote: > 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: [email protected] > > 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: [email protected] > > 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: [email protected] > > 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: [email protected] > > 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: [email protected] > > 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: [email protected] > > 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 > === message truncated === ____________________________________________________________________________________ Be a better pen pal. Text or chat with friends inside Yahoo! Mail. See how. http://overview.mail.yahoo.com/ _______________________________________________________________________________ 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
