[Discover] Display the queried part of the field in the document table

[TimBosman]

Describe the feature:

I would like to see the part of the field that matches my query. Right now, we highlight the matching parts. Furthermore, we can specify the number of lines or view the full field, but it would be nice to see the surrounding of the matching part.

Describe a specific use case for the feature:

If you have a field with very big values, you either see the beginning of the field, or the full field. I would like to see the places where the documents match my query

[elasticmachine]

Pinging @elastic/kibana-data-discovery (Team:DataDiscovery)

[davismcphee]

@TimBosman Thanks for contributing the issue. We're curious to learn more about this request. Could you provide some detail about the use case and type of data you're working with? Things like character length of the fields you're working with or potentially a screenshot could be helpful here. Thanks!

[lukasolson]

Related: #159391

[TimBosman]

I am not able to share a screenshot here since this is protected data. However, I'm talking about a field that contains the full text of a scientific article with multiple pages. If we search this field on a certain query, we will always see the beginning of the field, or the full field. However we are only interested in the context of the hit.

[davismcphee]

@TimBosman No problem on the screenshot, and thanks for the additional context 🙂 The #159391 issue @lukasolson linked to touches on this issue at a technical level, and we're reviewing the available options in Elasticsearch to see how we could better support this use case in Discover.

[TimBosman]

Looking deeper into it, it seems that Elasticsearch itself is returning the part of the field that matches the query. Being able to just show this "highlight" response of Elasticsearch instead of the full "Field" response would be enough to help out here.

Screen.Recording.2023-08-24.at.14.19.03.mov