Clarity: Investment Properties link always links to Porfolio List when using an NSQL query.
search cancel

Clarity: Investment Properties link always links to Porfolio List when using an NSQL query.


Article ID: 51598


Updated On:


Clarity PPM SaaS Clarity PPM On Premise



Created an NSQL query, then a portlet built upon the query. When I link a result row to the "Investment Properties" link, it always sends me to the portfolio list.

Steps to Reproduce:

  1. Admin Tool > Studio: Queries > Click 'New' button > ID='myQuery' > Enter the NSQL Statement:
    SELECT[email protected],@SELECT:DIM_PROP:USER_DEF:IMPLIED:inv:inv.odf_object_code:[email protected],@SELECT:DIM_PROP:USER_DEF:IMPLIED:inv:inv.code:[email protected],[email protected] INV_INVESTMENTS invWHERE @[email protected] 
    Click 'Save and Continue' button.

  • Create a 'Linking' definition on this query:
      Action = "Investment Properties"  Investment Code = "investment_type"  Investment Object Id = 'investment_int_id"
    Click 'Submit' button.

  • Create a portlet from the query and set one of the fields to the link created in previous step Portlets > New : Grid Portlet
     Data Source = 'myQuery'
    Click 'Save' > 'Finish and Open'.
    Add all the fields to the Layout.
    Go to Fields > click 'properties' icon for the 'Investment Name' field.
    Configure the Link on this field to use the link created above.
    Click 'Submit' button.

  • Add the portlet to a Portlet Page.

  • Navigate to the Portlet Page.

  • Within this portlet, click on the Investment Name Link.
Expected Result: Go to the properties page for the selected investment.
Actual Result: Go to Portfolio List View.



This issue has been documented as CLRT-18800and is assigned to development for review. If you are experiencing this problem and the workaround above does not significantly help, please contact CA Clarity Technical Support.

Keywords: CLARITYKB, CLRT-18800, clarity12open, studio


Component: STUDIO