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___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
