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.