Clarity PPM

Expand all | Collapse all

References of an Attribute within Clarity application

  • 1.  References of an Attribute within Clarity application

    Posted 03-07-2016 05:19 PM

     

    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.



  • 2.  Re: References of an Attribute within Clarity application

    Posted 03-07-2016 06:01 PM

    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'



  • 3.  Re: References of an Attribute within Clarity application

    Posted 03-08-2016 01:11 PM

    Thank you Kathryn



  • 4.  Re: References of an Attribute within Clarity application

    Posted 03-07-2016 11:56 PM

    Also, check this:

    TIP : Documenting your Configuration (via SQL)

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

     

    NJ



  • 5.  Re: References of an Attribute within Clarity application

    Posted 03-08-2016 01:17 PM

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