Re: Using in an External () query

2012-08-09 Thread patchsk 
For the internal double quotes I think you need to use four quotes 
like  as below

NOT ('Project Status' =  +  +  Completed +  +  OR 'Project 
Status' =  +   +  Cancelled + . 

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

Re: Using in an External () query

2012-08-09 Thread Grooms, Frederick W 
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

Re: Using in an External () query

2012-08-09 Thread patchsk 
Sorry for the typo. I meant two double quotes(not four single quotes).
  You need to double it as the other post.

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 + . 

 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

Re: Using in an External () query

2012-08-09 Thread Grooms, Frederick W 
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:arslist@ARSLIST.ORG] On Behalf Of patchsk
Sent: Thursday, August 09, 2012 2:15 PM
To: arslist@ARSLIST.ORG
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:arslist@ARSLIST.ORG] On Behalf Of Grooms, Frederick W
Sent: Thursday, August 09, 2012 2:02 PM
To: arslist@ARSLIST.ORG
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