It can be done if you get rid of the LIKE On Window Loaded, run a guide that loops through either SHR:Assignment or $GROUP$ (whichever is easier for you), and build up a query in a Character field that reads something like this:
'Assigned to Group+' = ""Group A"" OR 'Assigned to Group+' = ""Group B"" OR (etc...) (based on the current user's group list) Then relace the $GROUPS$ LIKE part of your table qual to read: AND EXTERNAL($Character Field$) About 10 minutes development, works a treat, and is a LOT quicker as well. We've been using this on our consoles for years. Cheers, Matt -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Wacholz, Jeanette (Jenni) Sent: Saturday, 14 October 2006 5:59 AM To: arslist@ARSLIST.ORG Subject: Re: Helpdesk 6.0 Support Panel displaying groups I am not a member of. We worked through this same issue recently with tech support and the bottom line answer was "no." We tried a lot of different variations on the query even though BMC said it couldn't be done and eventually I had to admit that I couldn't prove them wrong. Fortunately, we only had 3 group names we had to change. You just have to make sure that no complete group name is a part of any other group name. For example, we couldn't have both 'Production Support' and 'IDX Production Support' because the complete name of one is part of the other. Jenni Wacholz 480-445-2517 Remedy Administrator Coventry Health Care -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Jack Samson Sent: Friday, October 13, 2006 11:05 AM To: arslist@ARSLIST.ORG Subject: Helpdesk 6.0 Support Panel displaying groups I am not a member of. All, I am using ITSM 6.0 Helpdesk. We have created a lot of groups in the system that are very similar. The Remedy Support Panel is now displaying groups that individuals are not a member of due to the LIKE statements. (This happens when I select the Console View: Group) My question is, is their a way to change the qualification so that we don't have to change all of the group names? The qualification is: ((( 'zTmpKeyword' = "MAINHELPDESK" ) AND ( 'Status Integer' < 4)) OR (( 'zTmpKeyword' = "MAINCHANGE" ) AND ( 'Status Integer' < 6)) OR (( 'zTmpKeyword' = "MAINTASK" ) AND ( 'Status Integer' < 4))) AND (( $zTmpShowAssignedReq$ = 'zTmpKeyword') OR ( $zTmpShowAssignedReq$ = "All" )) AND ((( $ConsoleViewBy$ = "Myself") AND ( 'Assigned To' = $USER$)) OR (( $ConsoleViewBy$ = "Group") AND ( 'Assigned To Group+' != $NULL$ ) AND ($GROUPS$ LIKE (( "%" + 'Assigned To Group+') + "%" ))) OR (( $ConsoleViewBy$ = "Group Unassigned") AND ( 'Assigned To' = $NULL$ )) OR (( $ConsoleViewBy$ = "Date") AND ( 'Requested Completion Date' <= $zTmpDate1$)) OR ( $ConsoleViewBy$ = "Any")) Thanks in advance and thank you all for your support in the past. Regards, Jackson Oracle 9 Solaris ARS 6.3 _________________________________________________________________ Share your special moments by uploading 500 photos per month to Windows Live Spaces http://clk.atdmt.com/MSN/go/msnnkwsp0070000001msn/direct/01/?href=http:/ /www.get.live.com/spaces/features ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org "MMS <firsthealth.com>" made the following annotations. ------------------------------------------------------------------------ ------ This message, including any attachments, is intended solely for the use of the named recipient(s) and may contain confidential and/or privileged information. Any unauthorized review, use, disclosure or distribution of this communication(s) is expressly prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy any and all copies of the original message. ======================================================================== ====== ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ********************************************************************** The information in this e-mail is confidential and may be legally privileged. It is intended solely for the addressee. Access to this e-mail by anyone else is unauthorised. If you have received this communication in error, please notify us immediately by return e-mail with the subject heading "Received in error" or telephone +61 2 93357000, then delete the email and destroy any copies of it. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful. Any opinions or advice contained in this e-mail are subject to the terms and conditions expressed in the governing KPMG client engagement letter. Opinions, conclusions and other information in this e-mail and any attachments that do not relate to the official business of the firm are neither given nor endorsed by it. KPMG cannot guarantee that e-mail communications are secure or error-free, as information could be intercepted, corrupted, amended, lost, destroyed, arrive late or incomplete, or contain viruses. KPMG, an Australian partnership, is part of the KPMG International network. KPMG International is a Swiss cooperative that serves as a coordinating entity for a network of independent firms operating under the KPMG name. KPMG International provides no services to clients. Each member firm of KPMG International is a legally distinct and separate entity and each describes itself as such. Liability limited by a scheme approved under Professional Standards Legislation. This footnote also confirms that this e-mail message has been swept by MIMEsweeper for the presence of computer viruses. See www.mimesweeper.com for more information. ********************************************************************** _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org