I am trying to simply apply a Boolean filter to a Rest API call that is based on a Yes/No
It has been documented in many locations that this functionality is broken for many years. I am unable to find any firm indication that it is indeed broken from Microsoft.
Has anyone been able to successfully achieve this in SharePoint online. I understand it is simple enough to filter the local collection, but this just feels sub-optimal in so many ways.
Examples:-
- items?$filter=YesNoColumn eq 1 - returns nothing
- items?$filter=YesNoColumn ne 0 - return everything
- items?$filter=YesNoColumn gt 0 - return nothing