Matt/Alan, So building on the advice below, I've created a filter in which I also on new/modify of a people record, I want to push an entry into CTM:People Permission Group. What I would like to do update the access restrictions for any new/existing record to a specific Company by using a filter instead of manually selecting Update Access Restrictions from the People form. When I do use the manual method, a new entry is created in CTM:People Permission Groups that has the following unique fields:
Permission Group: 1000000006 Permission Group ID: 1000000006 Company: Forest Permission Group Type: Data Access The rest of the fields are just values from the people form. What I've done is pretty much mimicked the push fields action from the filter you referenced below except for setting the unique fields mentioned above. However, when I kick off the filter, I get the following error: ARERR [313] Data types are not appropriate for relational operation What I did notice is on the CTM: PPG form, the drop down for Permission Group does not have 1000000006 listed so I'm thinking there is some translation going on but not sure what. I hope this isn't too confusing to follow and can offer some assistance. Thanks in advance. Tauf Chowdhury | Forest Laboratories, Inc. Sr. Analyst Office: 631.858.7765 ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Matthew Perrault Sent: Friday, November 21, 2008 10:55 AM To: [email protected] Subject: Re: CTM:People Permission Group synchronization with 'Group List' Alan/Jonathan, Alan is exactly correct. When you create the People record you should push to the people permission group record and the z1D Action field should get a value of "START" pushed to it along with the other values that are needed. See filter: CTM:PPL:SetUnrestrictedAccess_600_PPPG as an example The way it works is that filter fires: and pushes to the CTM:People Permission Groups form This will in turn cause the filters: CTM:PPG:UpdateGroupList_190_Add1 to CTM:PPG:UpdateGroupList_200_Add5 to execute. These filters in turn push to the USER record. There is also a push to SYS:Action form in this process as well. See filter: CTM:PPL:UpdateGroupList_550_PACT That filter pushes to SYS:Action a value of Action = PPLUPDATEGROUPLIST And Request ID01 = $Person ID$ This will create a record in the SYS:Action form. What happens from here is a delete is issued against that record. Most of the filters in this form fire on delete. There are some filters that fire on delete that build some back end associations such as people work logs, asset etc. HTH Matt P. From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Alan West Sent: Thursday, November 20, 2008 2:53 PM To: [email protected] Subject: Re: CTM:People Permission Group synchronization with 'Group List' ** I have seen something similar before I think you will need to populate the z1D_Action field with "START" (Might be that not, not sure though as I am not on site) this then pushes fires the workflow that populates the User form. I think this might do it. Kind Regards Alan D West -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Jones, Jonathan Clark Sent: Thursday, November 20, 2008 2:43 PM To: [email protected] Subject: CTM:People Permission Group synchronization with 'Group List' ARS 7.1.0 patch 5 ITSM 7.00.03 patch008 Windows Oracle - Remote DB I'm building a people management integration to ITSM 7. I don't want to touch any of the OOTB workflow if I can help it. I have a staging form where the external HR system deposits "people" data. On create/modify in the staging table, a series of filters fire that preps the "person" record and pushes it to CTM:People. I want give the people some default application permissions so I'm also pushing records to 'CTM:People Permission Group' to give them a minimal level of application permission (Incident Submitter, Infrastructure Change Submitter, tenant company, etc.) All that works fine. However, the 'Group List' value on the related User record is only getting the tenant group # and 'General Access'. If I manually create a CTM:People record and add the permissions and tenants one at a time, they all show in the 'Group List' on the 'User' record. I'm 99% sure that this issue occurs because of filter phasing in the OOTB workflow. So now my question...does anyone out there know of a way to re-push a series of 'CTM:People Permission Group' to the User record's 'Group List'? A sort of "refresh permissions" command or something? Or do you have any other suggestions on how I might synchronize the two entities? Thanks, Jonathan Jones Southern Company Services 205-257-4799 ________________________________________________________________________ _______ 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___ ********************************************************************** This e-mail and its attachments may contain Forest Laboratories, Inc. proprietary information that is privileged, confidential or subject to copyright belonging to Forest Laboratories, Inc. This e-mail is intended solely for the use of the individual or entity to which it is addressed. If you are not the intended recipient of this e-mail, or the employee or agent responsible for delivering this e-mail to the intended recipient, you are hereby notified that any dissemination, distribution, copying or action taken in relation to the contents of and attachments to this e-mail is strictly prohibited and may be unlawful. If you have received this e-mail in error, please notify the sender immediately and permanently delete the original and any copy of this e-mail and any printout. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
