Has anyone attempted this successfully? If so do you have a whole list of
places where this name might be needed to be changed?
I have noticed that the design of the ITSM application is not very
consistent about where it uses the Request ID (Entry ID or Field 1) or
instanceID or some GUID to relate such data and where it uses something like
Company Name itself to relate data. For e.g. in the SIT:Site Company
Association table, it looks like the Company Name is used in the
relationship, while in some other places either the Company Entry ID or the
instanceId is used.
This could mean that a name change could possibly break a few data
relationships, if the name change doesn't propagate to all the forms that
use the name in the relationship..
Does anyone have a complete list of forms where this relationship might be
broken in the event one needs to change the Company Name? I'm suspecting
there is no OTB workflow, which would propagate this change to all forms
that might need to reflect this change.
A simple SQL search show 737 forms that have data fields that Company in the
field name where the field is a data field.
SQL> select count(*) from aradmin.arschema where schemaid in (select
schemaid from aradmin.field where fieldname = 'Company' and fieldtype = 1)
order by name;
458
SQL>
SQL> select count(*) from aradmin.arschema where schemaid in (select
schemaid from aradmin.field where fieldname like '%Company%' and fieldtype =
1) order by name;
737
Regards
Joe
PS: Does ITSM 8.x handle name change of a company better than 7.6.04??
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"
