I have an attribute "DUMMY_ATTRIBUTE" which exist in the Project Object. The Attribute_type of this is LOOKUP.
Now, the lookup "DUMMY_LOOKUP" is referencing this attribute, which is a static list lookup, containing 6-7 values.
My intention is to know which all pages/places in CA Clarity application is this attribute "DUMMY_ATTRIBUTE" holds references to.
If I am changing the associated lookup or deleting the same, I should be able to do impact-analysis of this deletion, on all the pages where this attribute holds reference.
Is there some documentation on the same or probably a query to pull out all the references of attribute/lookup ?
Here is a sample query that can help you out. In my query I am looking which property subpage the 'assigned_to' attribute is configured
FROM odf_view_attributes va, odf_views v, odf_view_sections vs
WHERE va.view_id = v.id
AND v.id = vs.view_id
--AND OBJECT_CODE = 'project'
AND va.attribute_code = 'assigned_to'
AND v.view_type = 'property'
Thank you Kathryn
Also, check this:
TIP : Documenting your Configuration (via SQL)
Thanks Nav ... this was really helpful :-)