Document Explorer field sorting

[Anfo (Richard)]

Hello
On a steep learning curve with Elasticsearch and was wondering something about Document Explorer, please. I am noting that only some columns can be sorted A-Z, presumably because they only contain alpha strings not like in attached image.

However, if I want to sort a column that is multi-data, is there another way? I'd really like to work through redundancies by having all values sorted.

Richard

[matw (Matthias Wilhelm)]

Hi and welcome to our community

I'm not sure what you mean by 'only contain alpha strings', could you elaborate. Generally it depends on the mapping of a field, if a field is sortable, and you can also add multi fields to the table

However, it would be helpful if one does not need to pick the right field to sort by when having multifields, there's a related issue for this, have a look:

Sorting text/keyword fields on Document Explorer

Best,
Matthias

[Anfo (Richard)]

Hi Matthias
Thank you for replying. In the screenshot, A-Z sorting is unavailable, and I was wondering if it had anything to do with alpha, numeric or NULL values in the field. For example in user.name, "secret" and 123456 can't be sorted, therefore, greyed out?

[Anfo (Richard)]

Oh I see. If multifield (k), then not sortable. Just out of ignorant curiosity, why?

[matw (Matthias Wilhelm)]

No, it's about mappings. You can use a keyword field to sort by. But this isn't possible with a text field.