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?
Release : 15.8.1
Component : CA PPM SAAS STUDIO
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
INNER JOIN INV_INVESTMENTS INV_INVESTMENTS1
ON inv_investments.IDEA_ID = INV_INVESTMENTS1.ID