Hi,
Why not do it without Direct SQL?
Action 1:
Set-Fields: From: CHG:Association_ID02Join
('Request ID01'>= $Incident Number$ AND 'RequestID02_Status >= "Completed")
Integer Field = $LASTCOUNT$ + LEFT($1$, 0)
If you have a lot of matches, and do the count often, using this method might
have a slight performance impact.
Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011)
Ask the Remedy Licensing Experts (Best R.O.I. Award at WWRUG10/11/12/13):
* RRR|License - Not enough Remedy licenses? Save money by optimizing.
* RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs.
Find these products, and many free tools and utilities, at http://rrr.se.
> Hi Pamela,
>
> You need to replace the double quotes with single quotes for this to work.
>
> Regards,
>
> Chris
>
>
> -----Original Message-----
> From: Action Request System discussion list(ARSList)
> [mailto:arslist@ARSLIST.ORG] On Behalf Of Pamela Morales
> Sent: 19 June 2015 21:32
> To: arslist@ARSLIST.ORG
> Subject: Re: Count CRQ related an INC in status=<"Completed"
>
> Hi Bruce,
>
> I tried what you recommend, but I got an error: Invalid column name
> 'INC2014000903'. (SQL Server 207) (ARERR 552). I'm trying to do this SQL
> Sentence:
>
>
> SELECT COUNT (*) FROM dbo.CHG_Association_ID02Join WHERE (Request_ID01
> ="$Incident Number$" AND RequestID02_Status>=10)
>
> I will be grateful with your help
>
> Thanks
>
> Pamela
>
> _______________________________________________________________________________
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers
> Are, and have been for 20 years"
>
> _______________________________________________________________________________
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> "Where the Answers Are, and have been for 20 years"
>
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"
