Your method is also valid and is used when you are trying to build the string
using dynamic data
i.e.:
"NOT ('Project Status' = " + """" + $MyField1$ + """" + " OR 'Project Status' =
" + """" + $MyField2$ + """" + ")"
Or
"NOT ('Project Status' = """ + $MyField1$ + """ OR 'Project Status' = """ +
$MyField2$ + """)"
Fred
-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:[email protected]] On Behalf Of patchsk
Sent: Thursday, August 09, 2012 2:15 PM
To: [email protected]
Subject: Re: Using " in an External () query
** Sorry for the typo. I meant two double quotes(not four single quotes).
You need to double it as the other post.
-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:[email protected]] On Behalf Of Grooms, Frederick W
Sent: Thursday, August 09, 2012 2:02 PM
To: [email protected]
Subject: Re: Using " in an External () query
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-----
On Thursday, August 9, 2012 11:41:12 AM UTC-7, patchsk wrote:
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 won't 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"
