Now that 9.3.0 is out, I notice this added (and very useful) ES|QL feature:
Support extra field (
outputField) in TOP function.Values of
outputFieldwill be returned instead of values offield, as discussed here and there
In that first link, I suggested adding keyword fields to the list of possibilities for the outputField. Because effectively what we can now now answer in ES|QL:
"Give me list of employees sorted by their salaries"
if by "employee" we mean a numeric employee_id. I think often I'd more often rather answer in ES|QL:
"Give me list of my employees names, sorted by their salaries"
where the employee name is a keyword field ?
Am I overlooking some other ES|QL way to achieve same?
If not, how to "nudge" the development team to add the keywork type to OutputField in 9.4+ ?