Claire,
For what you are trying to achieve I think your brackets are in the wrong
place.. I would try..
('Region' = $Region$) AND ((('zTmpKeyword' = "MAINHELPDESK") AND ('Status
Integer' < 4)) OR (('zTmpKeyword' = "MAINCHANGE") AND ('Status Integer' < 6))
OR (('zTmpKeyword' = "MAINTASK") AND ('Status Integer' < 4)))
Or if you want to use $ConsoleViewReadOnlyField$ if that holds the appropriate
value for what you are comparing, then the statement would be:
($ConsoleViewReadOnlyField$ = 'Region') AND ((('zTmpKeyword' = "MAINHELPDESK")
AND ('Status Integer' < 4)) OR (('zTmpKeyword' = "MAINCHANGE") AND ('Status
Integer' < 6)) OR (('zTmpKeyword' = "MAINTASK") AND ('Status Integer' < 4)))
The bottomline is keep the Region comparison outside of the other part ie
(Region) AND ( (Main Helpdesk Stuff) OR (Change Stuff) OR (Task Stuff))
Joe
________________________________
From: "Sanford, Claire" <[email protected]>
To: [email protected]
Sent: Wednesday, September 30, 2009 11:49:08 AM
Subject: SHR:Consolidated and the Support Console HD6
I am running Helpdesk 6.0 and ARS 6.3 and need to add a view on the
Support Console that is any open ticket by a specific Region.
I know this is easy and I've done it before, but for some reason I am
just not getting it this time.
I have an AL that sets the ConsoleViewReadOnly to the contents of the
Region field.
My qualifications to pull the table are:
(( 'Region' = $Region$) AND ( 'zTmpKeyword' = "MAINHELPDESK" ) AND (
'Status Integer' < 4)) OR (( 'zTmpKeyword' = "MAINCHANGE" ) AND (
'Status Integer' < 6)) OR (( 'zTmpKeyword' = "MAINTASK" ) AND ( 'Status
Integer' < 4))
It is pulling ALL open tickets regardless of the Region.
I also tried:
(( $ConsoleViewReadOnlyField$ = 'Region') AND ( 'zTmpKeyword' =
"MAINHELPDESK" ) AND ( 'Status Integer' < 4)) OR (( 'zTmpKeyword' =
"MAINCHANGE" ) AND ( 'Status Integer' < 6)) OR (( 'zTmpKeyword' =
"MAINTASK" ) AND ( 'Status Integer' < 4))
ARS 6.3 Patch 22
HD 6.0
Oracle 10.2.0.4.0 w/9 libraries
Oracle lives on a remote server
Windows 2003 4 gig on app server and 8 gig on DB server
Claire Sanford
Information Systems Division
Memorial Hermann Healthcare System
Phone: 713 448 6035
[email protected]
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
