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

Document ID : KB000021521
Last Modified Date : 14/02/2018
Show Technical Document Details

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.