Hey, 24 hours in a day; 24 Diet Cokes in a case. Coincidence? I think
not...
Rick
On 11/15/07, Joran, Peter P, CTR, OSD-CIO <[EMAIL PROTECTED]> wrote:
>
> 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: arslist@ARSLIST.ORG
> 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: 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
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
