As long as an entry doesn't have a gid of 155598, then your replace should work fine. I can't suggest strongly enough that you seek an alternate route, as string manipulation breaks under a lot of circumstances, depending on your assumptions.
Axton Grams On Tue, Sep 23, 2008 at 2:17 PM, Brien Dieterle <[EMAIL PROTECTED]> wrote: > ** > 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: [email protected] >> 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: [email protected] >> >> 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: [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" >> >> >> >> __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"
