String field in Discover is not sortable, and .keyword field and alias field are both empty

[qub123 (kenneth lam)]

Hi @Larry_Gregory,

Please see the post post, according to @Bargs (Elastic Team memeber), it is common behavior that unchecking "Hide missing field" is a common behavior to see the "keyword" field in Discover. And also it seems like there is bug in alias too, the issue has been raised since august 2018, but until now the error still hasn't been fixed.

Sorting in Discover not working

If you only need nice display names, have you tried using a field formatter? These can be more lightweight performance-wise because the formatting is done in the browser rather than in Elasticsearch. Search will be more performant if done against regular fields vs a script. If a field formatter won't do the job for you, could you open up your browser's dev tools and see if there's an error when filtering on the scripted field? Filter on scripted fields should work, so there must be something f…

Discover doesn't show field aliases · Issue #21705 · elastic/kibana · GitHub ](Discover doesn't show field aliases · Issue #21705 · elastic/kibana · GitHub

Here you can see the field mapping for the activity_type, activity_type.keyword, and the alias Activity_Type. I tried to filter in the activity_type.keyword, and also filter with alias Activity_Type. Both return correct result, but same problem also, the .keyword and alias column have empty value again.

Pic: filter with activity_type.keyword field, return correct result on the activity_type text field

Pic: Filter with alias "Activity_type", return correct result on the activity_type text field.