I'm trying to create a portlet page that has two portlets side by side:
- 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.
- 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?