Need to add a new value, "My New Application", to the lookup SCH_BROWSE_APPLICATION, which is linked to the table INV_APPLICATIONS.
Clarity PPM 15.x
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],
INV_INVESTMENTS INV, INV_APPLICATIONS APP
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
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.