Rick, I created a table JUST for this query. It hides the original tables fine, it pops up the new table and it populates it, but instead of just the one region selected, it pulls the entire set of open tickets.
________________________________ From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Rick Cook Sent: Wednesday, September 30, 2009 10:53 AM To: arslist@ARSLIST.ORG Subject: Re: SHR:Consolidated and the Support Console HD6 ** 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 <claire.sanf...@memorialhermann.org> 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 claire.sanf...@memorialhermann.org _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"