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"
