How to add values to the table INV_APPLICATIONS

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:ID@,
                 @SELECT:INV.CODE:CODE@,
                 @SELECT:INV.CODE:UNIQUE_CODE@,
                 @SELECT:INV.NAME:NAME@,
     @SELECT:INV.LAST_UPDATED_DATE:LAST_UPDATED_DATE@
                FROM
                 INV_INVESTMENTS INV, INV_APPLICATIONS APP
        WHERE
                 @WHERE:SECURITY:APPLICATION:INV.ID@
                  AND INV.ID=APP.ID
                  AND (INV.PURGE_FLAG=0 OR INV.PURGE_FLAG IS NULL)
                  AND @FILTER@
                  @BROWSE-ONLY:AND INV.is_active=1:BROWSE-ONLY@

***

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.