Cumulocity inventory filter with decimal/float not working

What product/components do you use and which version/fix level?

Cumulocity 10.10

Are you using a free trial or a product with a customer license?

license

What are trying to achieve? Please describe in detail.

Hi,

I’m trying to filter objects with fragment values less than a float number.

This works:
{{url}}/inventory/managedObjects?query=$filter=(c8y_Position.lng gt 10 and c8y_Position.lng lt 17)
returns objects (some of them have lng=16.38)

This doesn’t (returns empty data):
{{url}}/inventory/managedObjects?query=$filter=(c8y_Position.lng gt 10 and c8y_Position.lng lt 16.5)

What am I doing wrong?

Thanks
Peter

Do you get any error messages? Please provide a full error message screenshot and log file.

Hi Peter,

I don’t think you have done anything wrong. I have tested it myself and could reproduce the behaviour and your issue. To me it seems like that this is a bug, as the documentation for the Inventory API mentions that the Query Language should actually support the use of floating point values.

I have created a corresponding support incident to have support and R&D look into this issue.

Thanks for bringing this up. I will keep you updated.

Best regards
Christian

Hi Peter,

the issue has been acknowledged and will be fixed by R&D.

Best regards
Christian