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

Document ID : KB000051598
Last Modified Date : 14/02/2018
Show Technical Document Details

Description:

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 @SELECT:DIM:USER_DEF:IMPLIED:inv:inv.id:investment_int_id@,@SELECT:DIM_PROP:USER_DEF:IMPLIED:inv:inv.odf_object_code:investment_type@,@SELECT:DIM_PROP:USER_DEF:IMPLIED:inv:inv.code:investment_code@,@SELECT:DIM_PROP:USER_DEF:IMPLIED:inv:inv.name:investment_name@FROM INV_INVESTMENTS invWHERE @FILTER@ 
    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.

Solution:

WORKAROUND:
None.

STATUS/RESOLUTION:
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