I am trying to create a portlet where we need to have one of the boolean fields in the Filter. However, after writing the NSQL Query, the field data type is numeric. I am able to change it to a lookup but that does not serve the purpose. I want to be able to make it a checkbox in the filter, for Yes and No values.
Instead of using "IMPLIED", use "BOOLEAN" for the datatype in your NSQL statement.
Here is an example of using BOOLEAN data type in the NSQL statement.
FROM SRM_PROJECTS P,