Jamie, Take a look at the "CTM:SYS-Access Permission Grps" form. The "Permission Group ID" field has the AR Group form id. The "Support Group ID" field has, well, the support group id (SGP00000000xxxx).
Thad P.S. arinside is a handy (and free) tool for helping trace through workflow. http://arinside.org/ On Mon, Apr 27, 2015 at 1:36 PM, Jamie <[email protected]> wrote: > Hey everyone, > > I"m looking for a way to relate support group entries to the AR Group > entries. Over the past many years, we have been renaming support groups > via the Data Wizard, without realizing that the AR Group form is not > updated. We have a few hundred instances where the Long Name on the AR > Group form does not match the CTM:Support Group Hierarchy. I'm looking for > a way to tie the support group and ar group entry together. I was able to > identify all of the support group entries that exist that to not line up > with an AR group entry based on Long Name, but that only gives me a picture > of how big of a mess I have: > > select SP.COMPANY, > SP.SUPPORT_ORGANIZATION, > SP.SUPPORT_GROUP_NAME > from ctm_support_group sp > where SP.STATUS = 1 > AND (SP.COMPANY || '->' || SP.SUPPORT_ORGANIZATION || '->' || > SP.SUPPORT_GROUP_NAME) > not in > (select G.LONG_GROUP_NAME from group_x g) > order by SP.COMPANY asc, SP.SUPPORT_ORGANIZATION asc, > SP.SUPPORT_GROUP_NAME asc > > > I now need the ability to have a 1 to 1 entry relationship between the > CTM:Support Group and Group form so I know which group entry to update for > the associated Support Group. I've been banging my head around for a while > now, and figured I would reach out to the community in parallel for help. > > Thanks! > Jamie > > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > "Where the Answers Are, and have been for 20 years" > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
