To get double quotes inside a string you have to double them up and use 2
double quotes
"NOT ('Project Status' = ""Completed"" OR 'Project Status' = ""Cancelled"" OR
'Project Status' = ""Rejected"" OR 'Project Status' = ""Closed"" OR 'Project
Status' = ""Failed"")"
-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of patchsk
Sent: Thursday, August 09, 2012 1:41 PM
To: arslist@ARSLIST.ORG
Subject: Re: Using " in an External () query
** For the internal double quotes I think you need to use four quotes like """"
as below
"NOT ('Project Status' =" + """" + "Completed" + """" + " OR 'Project Status'
= " + """" + "Cancelled" + .....
-----Original Message-----
On Thursday, August 9, 2012 11:17:28 AM UTC-7, Vimal wrote:
Hi all,
Please assist,
I'm trying to set a query string into a field, using an Active Link, which i
want to use in an External qualification.
eg:
"NOT ('Project Status' = "Completed" OR 'Project Status' = "Cancelled" OR
'Project Status' = "Rejected" OR 'Project Status' = "Closed" OR 'Project
Status' = "Failed")"
Remedy wont let me save, get an error message (Unexpected Character) when i
modify the Action on the Active Link.
Any idea how I can get this to work?
Regards,
Vimal
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
