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: [email protected]
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
