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"
