Clarity

  • 1.  Drill down portlet is failing until params are passed

    Posted Jun 21, 2017 12:51 PM

    Hi,

    I have a set of two portlets, a pie chart that drills down into a list. These portlets both reside on a tab in a portlet page with tabs. When I go to the tab for the first time in a session, the list portlet shows an error (blank error, no messaging).

    I believe this is because the query that the portlet is based on is expecting the four link parameters, but those parameters are blank, since I have not clicked on anything yet.

    Is there a way, either in the query or in the portlet, to have the list portlet just show up as blank if the parameters are not set? That is the desired behavior.



  • 2.  Re: Drill down portlet is failing until params are passed

    Posted Jun 21, 2017 01:04 PM

    In the NSQL that drives your list portlet, just "code for" any missing link parameters - stick a @NVL@ around the parameters in the NSQL and code it so it does whatever you want it to do when its "blank".

     

    (I would normally have any drill-downs on a different page, so I never navigate to that page without parameters, but thats just me)