Claire, are you sure you're looking at the same table in User that you're modifying in Admin? Remember that there are a few different ones that are stacked in HD 6.
Rick On Wed, Sep 30, 2009 at 8:49 AM, Sanford, Claire < [email protected]> wrote: > 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]<sponsor%[email protected]>ARSlist: > "Where the Answers Are" > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
