I am working on creating a custom portlet to display high level information about programs and I can't seem to get a boolean filter to work. I am returning an "is_active" flag as a number so that I can display it as an icon in my grid. When I put the "is_active" flag in the filter and make it a dropdown, it appears as I would expect (a dropdown with the options for "All", "Yes", and "No") but when I try to filter on any option other than "All" my grid doesn't display any data.
I have tried returning a yes or no and then casting that as a boolean but when I do that I was unable to display that as an icon in my grid. I've looked at the way the Active filter is set up on the projects list page and it appears to be a number return type cast as a boolean so I have tried that and it doesn't work for me either.
Does anyone have any ideas about how I might be able to fix this?