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"
