Numbers are sorted in a wrong way.

[albert39]

I use CRM Community Ed. 5.5.

A list with a number-column (x, x+1) will be sorted in 1,10,11,12.....2,21,....
Is there a possibility to sort it in 1, 2, 3, ... 9, 10, 11, ..... ?


Many thanks für your help.

Albert

[andopes]

Hi Albert

It happens because this field on database is not a int, but a varchar instead.
You should need to modify the vardefs accordingly and Repair database.

Cheers

[albert39]

Thank you.

But I am a newbie, therefore the question:

You should need to modify the vardefs accordingly and Repair database.

Where do I find the vardefs? In the field it is called LBL_MITGLIEDSNUMMER. The field-settings give no possibility for setting it "integer".

Greetings

Albert