Hello

I have a request fix a bug.

Even if it is a numeric type, it will be sorted like a text type.

In Database > Search, I imagined that sorting by a field set to a numeric type would increase in order from 1.

For example, 1,2,3,4 ,,,, 100. I thought it would work the same as when sorting in Excel. (Please see: sort_04_expect.png)

However, in Acoustic Campaign, it seems that they are sorted in order from the leftmost place.

For example, 1,10,120,130,200 ,,,91,99,,. (please see: sort_02_numeric.png)

I tried sorting by both text and number fields, and the results were the same. (please see: sort_03_text.png, sort_01_field.png)

Also, when sorting the results in the value report, this issue occurs, so it is very difficult to use as a report.

In the support case, I've heard that it's due to Acoustic Campaign storing all the data as "varchar2" when storing it in the database.

However, it is an internal specification and it should not affect the AC user side. (I think it's a bug) Please fix it.

Kind Regards,

sort_04_expect.png

sort_02_numeric...

sort_03_text.png

sort_01_field.png

Attachments Open full size