AnsweredAssumed Answered

Boolean parameters in NSQL filter?

Question asked by L.Elias Champion on May 20, 2015
Latest reply on May 20, 2015 by L.Elias

I'm trying to create a portlet page that has two portlets side by side:

  1. An NSQL-based Pie Chart portlet. We added a Yes/No boolean attribute to the Project object and this is showing the count of those values in a pie.
  2. Standard Object-based portlet on the Project object that displays some project info, including the attribute used in the chart

 

Invidually, I can add the needed filters (Active yes/no, new attribute yes/no, project phase, etc) to both portlets and it works fine, but I couldn't figure out how to make a boolean parameter for the NSQL one. Instead I was able to just use an integer param and point it to a Yes/No lookup.

 

I then decided to try making a portlet filter to use for the whole page instead of filtering on each portlet separately, but I can't get it to work for the Yes/No fields since on the NSQL portlet its an Integer, but on the object portlet its a Boolean

 

Right now, the paramters are formated as

AND @WHERE:PARAM:USER_DEF:INTEGER:PROJ.is_active:is_active@
AND @WHERE:PARAM:USER_DEF:INTEGER:PROJ.orh_discretion:is_disc@

I tried both BOOLEAN and BOOL but neither would work

AND @WHERE:PARAM:USER_DEF:BOOLEAN:PROJ.is_active:is_active@
AND @WHERE:PARAM:USER_DEF:BOOL:PROJ.orh_discretion:is_disc@

 

Is there a way to make this work?

Outcomes