Matt, I have done something similar wherein a Role is used to define a set of individuals (only one has to approve) who need to provide approvals on a request. The tricky part was getting the name of the approver against the signature line created. To do this I had to add a field on the AP:Signature form called 'Approver Group/Individual'. Make sure you use a field id that is not in the reserved range.
Add this field to the AP:Detail-Signature and the join form that holds the approval signature lines for your application. You then need to define filters on the AP:Signature form to populate the approvers full name field. The first filter should check if the Approvers field has a match in your user form or LDAP based on the login name as this is what is populated in the 'Approvers' field. If a match is found set the 'Approver Group/Individual' to the full name. If no match found then set this to NULL. The second filter checks if the 'Approver Group/Individual' is null and the 'Original Approvers' field is not null and sets the 'Approver Group/Individual' field with the value of the 'Original Approvers' field. This will set the 'Approver Group/Individual' to the Role name which in this case could be the Change Manager group. This way you have one signature line for the group of individuals that belong to the role. Note that you have to create the relevant roles in the approval server. This works perfectly if you need one signature line for a group of approvers and any one of them can approve the request. I have linked the approval server to a custom app so am not sure if you will have any additional steps involved for Change 7. Good luck! Saby --- Matt Willis <[EMAIL PROTECTED]> wrote: > Hi all, > > I've been pulling my hair out on this requirement, > and haven't come up with any simple solutions. If > anyone has done anything similar to this, or has an > idea on how I might achieve this, I would appreciate > your feedback. > > We're running version 7 server and apps... > > The requirement is to create multiple approval > signature lines on a change request, one line per > approver group, and all at the same approval level > (i.e. 0). Groups are pre-determined by such things > as: > > 1 - Change manager group > 2 - CI's changed by the change (relationships) - > support group managing the CI > 3 - CI's impacted by the change (relationships) - > support group managing the CI > > and so on and so on. I've been able to find the > support group, and therefore approvers within those > support groups, using sql. Just to give you an idea > on the sql, here is one example (ignore if you're > not interested in this bit): > > select fr.Login_ID > from > chg_associations ca, > bmc_core_bmc_baseelement be, > ast_assetpeople ap, > ctm_supportgroupfuncrolelookup fr > where > ca.Request_ID02 = '$Infrastructure Change ID$' > and ca.Association_Type01 = 71000 > and ca.Request_ID01 = be.ReconciliationIdentity > and ca.Request_ID01 = ap.AssetInstanceId > and ap.PeopleGroup_Form_Entry_ID = > fr.Support_Group_ID > and ap.PersonRole = 39000 > and fr.FunctionalRoleAlias = 7000 > > This works a treat. However, I need each approval > rule (i.e. change manager, CI's changed, CI's > impacted, etc.) to generate a separate approval > signature line. > > The process definition allows me to set 'If Multiple > Approvers' to "One must sign" or "All must sign". If > I use "One must sign", all approvers from all groups > go onto one signature line. If I use "All must > sign", each individual gets his/her own signature > line, i.e. groups are lost. > > So, is it possible to do the above? Or have we gone > beyond the limits of approval server 7? > > Sorry for taking up so much space, but hopefully you > get what we're trying to do. If you have any good > ideas, I'd be grateful for them. > > > Regards, > Matt Willis > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at > www.arslist.org ARSlist:"Where the Answers Are" > ____________________________________________________________________________________ Bored stiff? Loosen up... Download and play hundreds of games for free on Yahoo! Games. http://games.yahoo.com/games/front _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
