Hi All,
I am reading a SharePoint list and filtering the results by VendorType, there are about half a dozen different vendor types, but the vendor type could also be blank. I'm using an ODATA filter asking it to include all vendor types that don't equal 'Vendor Direct', but this should include a vendor type that is blank. I assumed that the condition of not equaling 'Vendor Direct' would produce the result I'm after, but it does not include the records where the vendor type is blank.
I've tried or VendorType eq '' or VendorType eq 'null' or VendorType eq 'blank', it still gives me all the vendor types that do not equal 'Vendor Direct' but it is not giving me the vendor types that are blank.
any help would be much appreciated!
