Did you run the query against the form in User, to see if it works that way?
Rick On Wed, Sep 30, 2009 at 9:01 AM, Sanford, Claire < [email protected]> wrote: > ** 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: > [email protected]] *On Behalf Of *Rick Cook > *Sent:* Wednesday, September 30, 2009 10:53 AM > *To:* [email protected] > *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 < > [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] >> > _Platinum 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"
