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
> 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: [email protected]
> > >
> > > **
> > > 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
> [email protected]
> > > <[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"
