How to add values to the table INV_APPLICATIONS

book

Article ID: 194016

calendar_today

Updated On:

Products

Clarity PPM SaaS Clarity PPM On Premise

Issue/Introduction

Need to add a new value, "My New Application", to the lookup SCH_BROWSE_APPLICATION, which is linked to the table INV_APPLICATIONS.

Environment

Clarity PPM 15.x

Resolution

The lookup, sch_browse_application, is system restricted, and can not be modified.

The query fetches the values as stored on the related tables:

***

SELECT @SELECT:INV.ID:[email protected],
                 @SELECT:INV.CODE:[email protected],
                 @SELECT:INV.CODE:[email protected],
                 @SELECT:INV.NAME:[email protected],
     @SELECT:INV.LAST_UPDATED_DATE:[email protected]
                FROM
                 INV_INVESTMENTS INV, INV_APPLICATIONS APP
        WHERE
                 @WHERE:SECURITY:APPLICATION:[email protected]
                  AND INV.ID=APP.ID
                  AND (INV.PURGE_FLAG=0 OR INV.PURGE_FLAG IS NULL)
                  AND @[email protected]
                  @BROWSE-ONLY:AND INV.is_active=1:[email protected]

***

Furthermore, those tables should not be manually populated/modified.
Those tables are populated by filling the details at the application level.

Those should be the steps to add a new application:

Home => Portfolio Management => Applications
http://<clarity_hostname>/niku/nu#action:projmgr.applications

Click new to add a new application.
Add the desired new application: My New Application

This will then be added to the table(s) and fetched by the lookup/query.