Problem sorting data with elasticsearch

Answered

Hi,
I’m having problem to sort data. (attachment)
Version 2.7.7
Datasource: Elasticsearch

Attachments:
sort.gif

1 answer

Public
Dmytro Zvazhii Flexmonster June 19, 2019

Hello Mario,
Thank you for writing to us.
Elasticsearch returns members as strings to Flexmonster. Therefore, they are not sorted as numbers in your sample.
The recommended workaround is to apply your own sorting method: https://www.flexmonster.com/api/sortingmethod/. In such a case, you can parse the input as numbers and sort them in an appropriate way.
Please let us know if the suggested approach works fine for you.
Regards,
Dmytro

Please login or Register to Submit Answer