AnsweredAssumed Answered

Priority as a Range in NSQL Portlet Filter

Question asked by Robert Ensinger on Aug 10, 2017
Latest reply on Aug 11, 2017 by Dave_3.0

My NSQL is getting rusty. I'm certain I've done this before but it's been years ago...


In an NSQL portlet, I need to send in Priority as a parameter in the where clause and I'd like to present a range control to the user in the Portlet UI.



The code below works when the Display Type is set to Text Entry but fails when set to Numeric Range

AND (@where:param:user_def:integer:prj_priority@ IS NULL OR (i.priority = @where:param:user_def:integer:prj_priority@))


It's probable I could split this into two parameters and use a BETWEEN - but for consistency I'd like to keep the Date Range control users are expecting to see. This is a Chart portlet so priority is not available as a Dimension Property.