Doesn't it start the string with a semi-colon prefixed to it? If not, it sure needs to.
If not, then make sure that the group id is not a sub-set of any of your other group ids, and just do a REPLACE($Group ID$, ";2342;", ";") if the 'Group ID' LIKE "%;1234;%" and have a second escalation to fire to run on if the 'Group ID' LIKE "1234;" that will do a REPLACE($Group ID$, "1234;", "") Something like that, just play with it. -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Axton Sent: Tuesday, September 23, 2008 12:09 PM To: arslist@ARSLIST.ORG Subject: Re: split a field and loop on each piece What of: 1234;1; 1;1234; 1;1234;2 ? Axton Grams On Tue, Sep 23, 2008 at 12:00 PM, Opela, Gary L CTR USAF AFMC 72 CS/SCBAH <[EMAIL PROTECTED]> wrote: > Actually, I think you might want to do a REPLACE($Group List$, ";1234;" > ";") > > This way, ;1;1234;12;23;4; would go to ;1;12;23;4; > > So, the ;1234; would go to ;, so you would still have your proper > delimiter. Test this in a small scale first to make sure you don't screw > up all of your user's groups. I've seen before where junk characters > would get put in this field at the database level, and break the user's > access to anything. > > Gary > > -----Original Message----- > From: Opela, Gary L CTR USAF AFMC 72 CS/SCBAH > Sent: Tuesday, September 23, 2008 10:58 AM > To: arslist@ARSLIST.ORG > Subject: RE: split a field and loop on each piece > > Hey, I got an idea. > > Whenever you are trawling the user table, you can use the REPLACE > function. > > SO, have an escalation hat runs against user, that does the following: > REPLACE($Group List$, ";1234;" ";;") > > You might have to tweak the statement a bit, but that should chop out > the group id that you are getting rid of. > > Have the escalation that adds people back in run about 30 minutes to an > hour later. > > Gary > > -----Original Message----- > From: Action Request System discussion list(ARSList) > [mailto:[EMAIL PROTECTED] On Behalf Of Brien Dieterle > Sent: Tuesday, September 23, 2008 10:45 AM > To: arslist@ARSLIST.ORG > Subject: Re: split a field and loop on each piece > > ** > Yes on trawling User table, I want to remove everyone from this group > every night and then add everyone back from the guide. > > I'll have to think about the trigger some more, but I think I want the > guide to trigger on modify so that if a new user is added to that field > they are added to the group immediately instead of only during the > nightly sync. > > Thanks again for all your help! > > Brien > > > On Tue, Sep 23, 2008 at 4:52 AM, Opela, Gary L CTR USAF AFMC 72 CS/SCBAH > <[EMAIL PROTECTED]> wrote: > > > Yeah, I was wondering if filter phasing would cause you an > issue. Adding > the `! was good. > > For the part on the escalations, why are you trawling the user > table, > looking for the group and removing it? Are you going through > each night > and removing all users from the group, then re-adding only the > users > from the guide? > > As far as having a field to modify to trigger the workflow, I > would > suggest adding a read/only radio button so that your filter that > calls > the guide can explicitly check for that flag being set. This way > you can > lock it down to run exactly only when you want it to. > > > Gary > > -----Original Message----- > From: Action Request System discussion list(ARSList) > [mailto:[EMAIL PROTECTED] On Behalf Of Brien Dieterle > > Sent: Monday, September 22, 2008 6:15 PM > To: arslist@ARSLIST.ORG > Subject: Re: split a field and loop on each piece > > ** > > Gary, brilliant. Works like a champ! > > For posterity, just had to add `! to the filter that actually > does the > group adding,and a tmpgroups field to store the user's other > groups, > because I can't seem to append to a field during a push > operation. > > Now I just need to setup an escalation to "flush" this group > (crawl User > table and do a set fields/string replace on the group I want to > flush?), > and then trigger this filter guide to push everyone back into > the group > (crawl my other table (escalation) and modify a field to trigger > filter > action (modify) to launch the filter guide?. The idea being to > keep a > group list populated with exactly and only the users from the > filter > guide Gary outlined. > > If there is a better way than above, please feel free to let me > know.... > I'll save this for tomorrow. > > Thanks again Gary and everyone else that responded! > > Brien > > > On Mon, Sep 22, 2008 at 12:32 PM, Opela, Gary L CTR USAF AFMC 72 > CS/SCBAH <[EMAIL PROTECTED]> wrote: > > > Good point, you are using usernames. > > Whatever the format in the database is what you should go > by, as > filters > are server-side code, and couldn't care less what the > client > displays. > > Let me know if it works, so I'll feel good and will be > nicer to > my > co-workers :) > > Gary > > > -----Original Message----- > From: Action Request System discussion list(ARSList) > > __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" > > > > __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" > ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
