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"
