Hi Jackson, We had a similar problem. Here's one approach to take care of it: - Create a hidden field called AssignedToGroupID on form(s) containing the records. - Create workflow to populate this field for any future records. - Populate this field for existing records via SQL, an escalation, whatever works best for you. - Create a hidden temp field on the form containing the table, called zTmpGroupIDs. - Populate this field using an SQL query against USER_X (the User form). The groups for a given user are stored as Group IDs at the database level, in the following format: ID1;ID2;ID3;etc; - Change your qualification to: ( (('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 ( ('AssignedToGroupID'=$NULL$) OR ($zTmpGroupIDs$ LIKE (""+'AssignedToGroupID'+";%")) OR ($zTmpGroupIDs$ LIKE ("%;"+'AssignedToGroupID'+";%")) ) OR (($ConsoleViewBy$="Group Unassigned") AND ('Assigned To'=$NULL$)) OR (($ConsoleViewBy$="Date") AND ('Requested Completion Date'<=$zTmpDate1$)) OR ($ConsoleViewBy$ = "Any") )
This takes advantage of the group IDs always having a semicolon after them. So while "1000" would be like "100%", "1000;" would not be like "100%;" Eric Cleereman -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Jack Samson Sent: Friday, October 13, 2006 2:05 PM 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 _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org