Issue Filtering Empty Fields in OData Analytical Model Calls

[#1]

Hello,

Over the past few weeks, we have been experiencing issues with OData calls to analytical models when applying filters on empty fields.

We are building the filter, for example, as follows:
ZOFFICE ne ' '

Until recently, this expression worked correctly. However, it is no longer excluding records with empty values (' '). Instead, it returns the full result set, including those records where the field is empty.

Has there been any recent change in how empty values are interpreted or handled in OData filters? We have also tried alternatives such as using null or comparison operators like gt, but none of them have produced the expected behavior.

Thank you,
Jaume

[sravan_aleshwaram]

Hello 

OData now treats empty (`''`) and `null` differently, so use an explicit combined condition,

ZOFFICE ne '' and ZOFFICE ne null

not (ZOFFICE eq '' or ZOFFICE eq null)

length(ZOFFICE) gt 0

This ensures both empty strings and null values are excluded.

Thanks,
Sravan