Changing it code wise is a PAIN. Went through it a bit ago because my company wanted to use the EXACT name for our groups inside of Remedy. After a bit of trial and error and streamlining I did the following. Added field on SHR:ConsolidatedList for GroupID for each Group field on there (we have a few). Filter fires on Submit/Modify to get the matching GroupID for the group name (One for each Group). Added the ID fields (and hid them) to the table on the console Modified the qualification to use GROUPIDS instead of GROUPS Data would be so much easier if it's allowed :) -------------
Dylan Wheeler Production Control Analyst Principal IT Operations Downey Savings & Loan Association, F.A. Email: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Rick Cook Sent: Wednesday, February 06, 2008 1:48 PM To: [email protected] Subject: Re: Group names and substrings ** Well, you can fix it with code, or you can fix it with data. Which do you prefer? The data way would be to replace the spaces with underscores, but I know that doesn't look nice to the users. So the code way would be to do a lookup of the exact name string and then use the corresponding Group ID, which would be used for all comparisons. Not sure if that would work with row level access - it may depend on your ARS version. Rick On Feb 6, 2008 1:25 PM, Chapin, John <[EMAIL PROTECTED]> wrote: ** Sometimes we get HelpDesk users complaining that they can see tickets assigned to an other group, a group to which they themselves do not belong. Upon investigation, we see that the user might belong to a group name like "Long Group Name", but they're seeing a ticket that is assigned to a group named "Group". Note that "Group" is a substring of "Long Group Name". I could see how this might happen, given the space-delimited GroupList field in the User table, and the fact that "Long Group Name" contains spaces, but the reason I'm puzzled is that it seems like it really should be happening MORE OFTEN, given all the group names we've got which are sub-strings of other group names. Does anyone know of a way to fix this, without having to rename a bunch of our bloomin groups...? thanks -- John ----------------------------------------- The information contained in this transmission may be privileged and confidential and is intended only for the use of the person(s) named above. If you are not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, any review, dissemination, distribution or duplication of this communication is strictly prohibited. If you are not the intended recipient, please contact the sender immediately by reply e-mail and destroy all copies of the original message. Please note that we do not accept account orders and/or instructions by e-mail, and therefore will not be responsible for carrying out such orders and/or instructions. If you, as the intended recipient of this message, the purpose of which is to inform and update our clients, prospects and consultants of developments relating to our services and products, would not like to receive further e-mail correspondence from the sender, please "reply" to the sender indicating your wishes. In the U.S.: 1345 Avenue of the Americas, New York, NY 10105. __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ This message and any attachments are for the intended recipient(s) only and may contain privileged, confidential and/or proprietary information about Downey Savings or its customers, which Downey Savings does not intend to disclose to the public. If you received this message by mistake, please notify the sender by reply e-mail and delete the message and attachments. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
