search cancel

At times the originating idea attribute on projects does not have a link back to the originating idea field.

book

Article ID: 21521

calendar_today

Updated On:

Products

Clarity PPM SaaS Clarity PPM On Premise

Issue/Introduction

Description:

At times the originating idea attribute on projects, no longer contains a link back to the originating idea field. When this occurs it shows the name of the idea in a read-only string.

Steps to Reproduce:

1. In Admin side open Project Object. Bu sure it has a Partition Model assigned.
2. Go to Object: Project - Views
3. Select Partition: System. Click on Layout:Edit. Go to the Project Summary section and move the Originating Idea from Available to Selected. Click on Save.
4. Run the following query:

select id, view_id, label, link_code from odf_view_attributes where attribute_code = 'idea_name' and
view_id in (select id from odf_views where code = 'projectGeneral')

A record is added into the odf_view_attributes and the field LINK_CODE = 'idea_name'

5. Select a Partition different from System. Click on Layout:Edit. Go to the Project Summary section and move the Originating Idea from Available to Selected. Click on Save

6. Run the query again.

Expected result:
A record is added into the odf_view_attributes and the field LINK_CODE='idea_name'.

Actual Result:
A record is added into the odf_view_attributes but the field LINK_CODE is null.

Solution:

The following queries should help in identifying the issue and resolving it.

Query that will identify the issue.

select * from odf_view_attributes where attribute_code = 'idea_name' and
view_id in (select id from odf_views where code = 'projectGeneral')

 

Results of this query should show a null value in one of the rows for the link code column. If it does not, please contact support.

Query that will update the link code column.

update odf_view_attributes set link_code = 'project.idea' where
attribute_code = 'idea_name' and id = 5XXXXXX (This number is the ID of the row above that had the null value for the link code).

 

It can take some time for the link to show in the Clarity UI. We have seen it take up to a day at times after running the query.

Unable to reproduce the issue in version 15.1. 

 

Keywords: ClarityKB, Clarity12open, Originating Idea, link.

Environment

Release: ESPCLA99000-14.2-Clarity-Extended Support Plus
Component: