Gary, I would suggest that you turn on SQL logging (on the ARS server) and trap the SQL that is being issued by the two clients.
We recently (this past weekend) think we have identified a bug in the v7.1 patch 2 Mid-tier with respect to SQL menus using field references. Maybe the bug also extends into "Search" menus too? What we were seeing is that sometimes the field value was used and other times it was blank. The menu actually had the same field value in two places and in a single SQL call to the DB it was substituted in with a value in one place, and as a NULL string (no characters at all) in the second place. However, the User Tool did not behave this way, nor does our v6.3 Mid-Tier. You might want to take a look at that and see if you are seeing the same thing. -- Carey Matthew Black Remedy Skilled Professional (RSP) ARS = Action Request System(Remedy) Love, then teach Solution = People + Process + Tools Fast, Accurate, Cheap.... Pick two. On Tue, Apr 29, 2008 at 3:38 PM, Gary Opela (Corporate) <[EMAIL PROTECTED]> wrote: > ** > > > > Arsystem 7.1, MT 7.1, tomcat 5.5, sql server 2k5, windows 2k3 > > > > I have two menus, one for Department and one for Program. > > > > I have the Program menu set up so that it only shows entries based on what > shows up in Department. So, my qualification on Program is: > > > > ( 'Status' = "Active") AND ( 'Department' = $536900005$) where the > field ID for Department is 5369…05. > > > > In the WUT, it works right. If I choose A for Department, then the programs > for A show up. I can then change it to B for department, and only B's > Programs will show up. > > > > Now, whenever I got to the web tool, if I click on Program before I set a > dept, nothing happens. I then choose a dept, and still, nothing happens. > But, if I select a department first, then click on programs, it shows the > proper programs for that department. Unfortunately, it still breaks because > If I change the department, then the program menu never refreshes, it just > continues to show the programs from the first department I choose (even if > the first department is $NULL$ or ""). > > > It's like the menu isn't refreshing each time I open it, even though I have > the refresh set to On Open. In the WUT, it refreshes each and every time I > open it, in the web tool, however, it appears to be only refreshing the > first time I open it. > > > I tried a work around of putting an active link on the department menu that > would do a change fields -> attach menu and re-attach the Program Menu to > the Program field, but this didn't work. > > > > Have any of you seen this before? Am I doing something wrong? > > > > Menu: > > > > Refresh: On Open > > Menu Type: Search > > Server: Same as parent form > > Form Name: Different form > > No tiers, just a first-level menu > > Qualification: ( 'Status' = "Active") AND ( 'Department' = $536900005$) > > > > > > > Thanks, > > > > Gary Opela, Jr., RSP > > Remedy Engineer > > Leader Communications, Inc. > > http://www.5pointleader.com > > http://www.lcibest.com > > Best Product, Best People, Best PriceTM > > An ISO 9001:2000 Certified, CMMI(R) Level 3 Rated Company > > __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > html___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
