There is a relationship that is most likely a hidden field. Do you have a
compelling reason for determining which AR Group is tied to the Support Group.
-----Original Message-----
From: Jamie <jamie.bo...@transamerica.com>
To: arslist <arslist@ARSLIST.ORG>
Sent: Mon, Apr 27, 2015 4:36 pm
Subject: CTM:Support Group Relationship to AR Group Form
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"
