AnsweredAssumed Answered

NSQL Boolean Parameter

Question asked by DeclanKenny on Jul 31, 2008
Latest reply on Aug 15, 2008 by Dave
AllI am trying to add a parameter to a NSQL query and I would like it to appear as a checkbox in the filter section of the portlet. In order to do this I believe I need to set the datatype of the parameter to a BOOLEAN.When I try this I get an error, "NPT-0109: The construct @WHERE:PARAM:USER_DEF:BOOLEAN:DIR_ONLY@ cannot be interpreted." The parameter is only in the WHERE clause, not in the SELECT. The parameter will work as an INTEGER, but that would then need an associated lookup and a dropdown in the filter section, which is not as elegant as a checkbox. So@WHERE:PARAM:USER_DEF:INTEGER:DIR_ONLY@  - works but isn't what I want@WHERE:PARAM:USER_DEF:BOOLEAN:DIR_ONLY@ - doesn't work but is what I want Any ideas would be appreciated. ThanksDeclan