Your problem may be just a little more complex than just touching this data in the foundation layer. You might have too look at other application areas too where that data was set. And that might be the more difficult part as in some of those areas, you might not have the Group ID stored on that form to relate it to make that change. Unless off course correcting that information in your application data forms is not important to you given the way you use your systems.
If that data is important to you AND if you have an EXACT record of the EXACT changes you have made to the group names, to create a temporary external table in the AR System tablespace, that has 3 columns, Group ID, Old Group Name, New Group Name. And then use this table as the lookup table to write a script to make your corrections. If you do not have an exact record of these changes, I would leave it as is instead of attempting to correct it as you might mess it up even more for those groups that you do not know the exact previous names Joe _____ From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Thad Esser Sent: Monday, April 27, 2015 6:30 PM To: [email protected] Subject: Re: CTM:Support Group Relationship to AR Group Form ** 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" _ARSlist: "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"
