I may not have had enough coffee this morning...but this, below, is what it would look like in a piece of Remedy workflow, or a SQL command at the DB level (or both)?
On Wed, 27 Sep 2006 10:36:40 -0700, Thad Esser <[EMAIL PROTECTED]> wrote: >Try: > >REPLACE($Member List$, $Login Name$, "") >followed by >REPLACE($Member List$, ";;", ";") > >(you could combine them into one if you wanted) > >Thad >"Perfection is achieved, not when there is nothing more to add, but when >there is nothing left to take away." - Antoine de Saint-Exupéry > > > >"Rebecca Hammond" <[EMAIL PROTECTED]> >Sent by: "Action Request System discussion list(ARSList)" ><[email protected]> >09/27/2006 10:28 AM >Please respond to >[email protected] > > >To >[email protected] >cc > >Subject >Break out Member List from AP:Role form (Approval Server)? > > > > > > >Hi all! > >I'm going through the process of trying to remove a whole bunch (hundreds) > >of People/User records - these are people who no longer work in my >organization. > >I know if I use the App. Config. Console, this will blow the users out of >places like SHR:Assignment. However, I've found that there can be >problems >if a user is deleted but their login name is still listed as part of a >Member List in the AP:Role form. In there, the login is stored with other > >members of the role, separated by a ; > >Does anyone have any tricks for editing the AP:Role records when a User >account is deleted? > >Thanks! > >___________________________________________________________________________ ____ >UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org > > > >***IMPORTANT NOTICE: This communication, including any attachment, contains information that may be confidential or privileged, and is intended solely for the entity or individual to whom it is addressed. If you are not the intended recipient, you should delete this message and are hereby notified that any disclosure, copying, or distribution of this message is strictly prohibited. Nothing in this email, including any attachment, is intended to be a legally binding signature.*** > >___________________________________________________________________________ ____ >UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
