Right, I am only flipping read-only to floating, and back again... Also, the database looks like:
511;507;508;501;518;521;55598; So, I think I can do a REPLACE($Group List$,"55598;","") and it should be all good after all. Interestingly, Remedy Admin won't even let you save an action that threatens to corrupt the format of this field (for instance, I tried saving it with replace: ";55598" instead of "55598;" and it actually said "Error with one of the field/assignments in the set filter/active link/escalation definition : User (ARERR 168)." I thought I was good to go there, and I just realized that REPLACE($Group List$, "55598;", "") or even using the group's text-name upon saving, gets converted to: REPLACE($Group List$, " 55598;", "") Notice the extra space before the group id? Any other variation seems to trigger the error message referenced above. Weird!! Other than that, I can successfuly *add* a user to a group, and change their license from Read to Floating, and back again. I just can't remove them from the group. Presumably, I can copy the Group List to a tmp field, do the REPLACE() there, and then put that back in the user group field to get around Remedy Admin tool being too "smart"... Thanks for the suggestions!! On Tue, Sep 23, 2008 at 10:17 AM, Opela, Gary L CTR USAF AFMC 72 CS/SCBAH < [EMAIL PROTECTED]> wrote: > I'm not sure of the implications with a floating license of > adding/removing a license, since they are not tied to a user. > > However, with a Fixed License (which is not what you stated you are > using), you can only reassign it 3 times per week before it is locked > for the rest of the seven days. > > Gary > > -----Original Message----- > From: Action Request System discussion list(ARSList) > [mailto:[EMAIL PROTECTED] On Behalf Of Brien Dieterle > Sent: Tuesday, September 23, 2008 11:26 AM > To: arslist@ARSLIST.ORG > Subject: Re: split a field and loop on each piece > > ** > Haha, thanks for the tip-- I was planning to use "" in the replace. I > forgot to add that anyone that I add to this group also needs a floating > license ... and so I'll be changing that license back to read-only as > part of the group "flush". Of course, when I set it back to read-only, > I won't know if that user had previously been givin a floating license > for some other reason... Unless I add another field to the user table, > like a checkbox that says "user had a floating license before I messed > with this". > > This is almost getting silly! :-) > > Brien > > > On Tue, Sep 23, 2008 at 9:00 AM, 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" > > > > __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"
