Filter with lessOrEqual for String attributes does not work, bug or feature?

[thulium3]

We use a custom OData service that provides account numbers as String from an SAP S/4HANA backend.
When calling the service directly we can filter the result using account le '1234'. The filter works as expected.

In the generated OData clients from Cloud SDK the method lessOrEqual is not available (because it is not a numeric value I think). So as a workaround I have to execute a raw request.

Do you think the OData service is badly designed and it is working as expected that lessOrEqual is not available or should it be possible to use this filter also in the generated clients because in SAP fields like Account number or Order number are often stored as String?

[jjtang1985]

Hi @thulium3 ,

Thanks for reaching out.
The OData doc says:

The six comparison operators can be used with all primitive values except Edm.Binary, Edm.Stream, and the Edm.Geo types. Edm.Binary, Edm.Stream, and the Edm.Geo types can only be compared to the null value using the eq and ne operators.

I would say Edm.String should also be a valid type with lessOrEqual.

Unfortunately, the current SDK does not support it.
I'll create a ticket for this feature request. @artemkovalyov .

Best regards,
Junjie

[ZhongpinWang]

Hi @thulium3 ,

Thanks again for the feedback. This feature is now implemented in #2519 and you can use all six comparison operators for all primitive EDM types. The change should be included in the next (canary) release.

Best regards,
Zhongpin