AnsweredAssumed Answered

NSQL Parameter in portlet not filtering

Question asked by marlon on Apr 11, 2010
Latest reply on Apr 12, 2010 by marlon
I have NSQL used in a portlet with a parameter (date format) defined but when this attribute is defined as a "Date Range" in the Portlet filter definition, it does not return any rows. If I change the attribute definition to Date only (a single entry field), it works fine for that one date. I need the parameter to be able to be a date range, but cannot figure out why it returns no rows. Is this a bug? Or am I doing something wrong? In the NSQL, here is the parameter in the Where clause: and ( (s.slice_date = @WHERE:PARAM:USER_DEF:DATE:TIMESHEET_DATE@ or @WHERE:PARAM:USER_DEF:DATE:TIMESHEET_DATE@ IS NULL) )

Outcomes