• 1.  NSQL Boolean Parameter

    Posted Jul 31, 2008 07:30 AM
    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

  • 2.  Re: NSQL Boolean Parameter

    Posted Aug 15, 2008 04:11 AM
    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