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