NSQL Boolean Parameter

[Anon Anon]

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

[Anon Anon]

I recall that you can't get a checkbox associated with a "Filter
only" field (like in your examples), but if you have a "real field"
(i.e. one returned by the SELECT in your underlying query) then you can implement
this as a checkbox in the filter area on the portlet.  For your example
you would thus have to create a pseudo-column returned by the query
(and populated according to whatever rules you are trying to achieve
with the checkbox). Hope that makes sense! DavidMortonCapgemini