How to create link attribute between Idea and Project

Products

• Clarity PPM SaaS

Issue/Introduction

We need to create a link attribute from idea to project properties page. We are trying to find out which project is created from which idea from Idea properties page through link attribute. Is this possible to do?

Environment

Release : 15.8.1

Component : CA PPM SAAS STUDIO

Resolution

To display which projects were converted from a given idea on the idea properties page, there is not an OOTB way of doing, but can still be accomplished via customization.  

The link between projects and ideas are in the inv_investments table and idea_id is what indicates if project was converted from an idea. It is possible to create a parameterized lookup and below is the sample query and not a complete solution but should give an idea of how to proceed.

select id, code project_code, idea_id idea_converted_from from inv_investments
order by idea_id

This lookup returns both project and ideas so an internal id of an idea can be passed so that all projects which were converted from that idea will be listed.

If you want the details of the Idea as well you could use a query like this:

SELECT inv_investments.CODE AS INV_CODE,
  inv_investments.NAME      AS INV_NAME,
  INV_INVESTMENTS1.NAME     AS IDEA_NAME,
  INV_INVESTMENTS1.CODE     AS IDEA_CODE
FROM inv_investments
INNER JOIN INV_INVESTMENTS INV_INVESTMENTS1
ON inv_investments.IDEA_ID = INV_INVESTMENTS1.ID