Clarity

Hi,

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 ?

Any ideas?

Cheers,

Hemant Joshi.

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

SELECT v.object_code,

va.attribute_code,

va.widget_type attribute_type,

v.code view_code,

v.view_type,

vs.label view_section_name,

vs.view_id view_section_id,

v.caption view_caption,

v.partition_code,

is_system,

is_customized,

v.CREATED_DATE view_created_date,

v.CREATED_BY view_created_by

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)

https://communities.ca.com/message/241821655#comment-241821655

NJ

Thanks Nav ...  this was really helpful :-)