Sorting a keyword field alphabetically on Elasticsearch

Asked Dec 05 '19 at 04:37

Active Dec 05 '19 at 04:37

Viewed 102 times

While applying sort on a keyword type field, it goes lexicographical and for the given data:

AAAAAAAAAAA
AAAAaaaa
Aaaaaa
jjjjjaaa
jjjjjAAA
JJJJJJjjjj
aaaJJJJJjjjj

After sort becomes:

AAAAAAAAAAA
AAAAaaaa
Aaaaaa
JJJJJJjjjj
aaaJJJJJjjjj
jjjjjAAA
jjjjjaaa

Expected: Is it possible to get a sort based on alphabetical order?

aaaJJJJJjjjj
Aaaaaa
AAAAaaaa
AAAAAAAAAAA
jjjjjaaa
jjjjjAAA
JJJJJJjjjj

Please not that, I have already tried the lowercase filter option and got the below result which is not my requirement:

Aaaaaa
AAAAaaaa
AAAAAAAAAAA
aaaJJJJJjjjj
jjjjjaaa
jjjjjAAA
JJJJJJjjjj

asked Dec 05 '19 at 04:37

James Jithin

So you basically want lowercase words to appear before uppercased ones, i.e. `a` before `A`, then `b` before `B`, etc? – Val Dec 05 '19 at 04:39
That's right @Val – James Jithin Dec 05 '19 at 04:54

0 Answers0