Kibana search limit rows (top 20)

How can I use the Kibana search interface to limit to 20 rows ?

I looked here https://www.elastic.co/guide/en/elasticsearch/reference/5.2/query-dsl-query-string-query.html#query-string-syntax and here https://lucene.apache.org/core/2_9_4/queryparsersyntax.html but I'm not seeing it.

1 Like

@Exocomp are you using the Discover app and looking to limit to 20 rows? You can currently configure this for all of Discover by going to "Management" -> "Advanced Settings" and changing the "discover:sampleSize" setting.

@Brandon_Kobel

What if i was to create a table using the visualize tab, how could I limit the rows ?

You can use the 'Size' input to control the number of results returned:

If you're using the DataTable visualization, you can also control the number of results that are returned per page:

@Brandon_Kobel gotcha, thank you!

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.