# KQL bar limitation **URL:** \ **Category:** Kibana\ **Created:** [December 16, 2021, 4:30pm UTC](https://discuss.elastic.co/t/kql-bar-limitation/292184 "2021-12-16T16:30:58Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![Michael\_Ubry](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/michael_ubry/32/98104_2.png) [@Michael\_Ubry](https://discuss.elastic.co/u/Michael_Ubry)\ **Post date:** [December 16, 2021, 4:30pm UTC](https://discuss.elastic.co/t/kql-bar-limitation/292184/1 "2021-12-16T16:30:58Z")
Hi, what is the maximum number of values I can use to match in KQL query? I have index which contains milions of rows of names and many columns related to them and I want to filter out lets say 50 names, but to click all of them out in Controls visualization would take me long time. Fortunetally, I have list of them in word separated by comma, so then I can easily do the query in KQL something like `customer.name: Michael,Jacob,George,Danny,Peter.........` how many names I can filter out like that? Thank you Thank you ---
**Author:** ![dosant](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dosant/32/64489_2.png) [@dosant](https://discuss.elastic.co/u/dosant)\ **Post date:** [December 20, 2021, 11:12am UTC](https://discuss.elastic.co/t/kql-bar-limitation/292184/2 "2021-12-20T11:12:33Z")
@Michael_Ubry, I don't think that we have a hard limit for this, I think this should work, only that the UX for this is less than ideal. I'd suggest using a custom filter instead of a query string. You can hide all the complexity inside the filter editor: ![Screen Shot 2021-12-20 at 12.12.17](https://us1.discourse-cdn.com/elastic/original/3X/3/a/3a78831856e00e585a6c675d8450edb586f68717.png) ---
**Author:** ![Michael\_Ubry](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/michael_ubry/32/98104_2.png) [@Michael\_Ubry](https://discuss.elastic.co/u/Michael_Ubry)\ **Post date:** [December 20, 2021, 12:34pm UTC](https://discuss.elastic.co/t/kql-bar-limitation/292184/3 "2021-12-20T12:34:25Z")
Hi @dosant and is there any possibillity to list values in the filter NOT using DSL but just filter bar "Values"? Thats more convenient for the user. Separating by comma doesnt work. Thanks ![image](https://us1.discourse-cdn.com/elastic/original/3X/8/7/878e30c6a8edbaeeb38fa1dbf7499c4ac65e76f3.png) ---
**Author:** ![dosant](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dosant/32/64489_2.png) [@dosant](https://discuss.elastic.co/u/dosant)\ **Post date:** [December 20, 2021, 3:19pm UTC](https://discuss.elastic.co/t/kql-bar-limitation/292184/4 "2021-12-20T15:19:42Z")
Not sure I understood the question correctly, but I assume you've asked if it is possible to copy-paste the list of values into that "values" input so that the list is recognized as multiple terms instead of a single term? I couldn't make it work ☹ ---
**Author:** ![Michael\_Ubry](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/michael_ubry/32/98104_2.png) [@Michael\_Ubry](https://discuss.elastic.co/u/Michael_Ubry)\ **Post date:** [December 20, 2021, 3:33pm UTC](https://discuss.elastic.co/t/kql-bar-limitation/292184/5 "2021-12-20T15:33:00Z")
@dosant Yes thats what I meant. Ok Thank you. ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [January 17, 2022, 3:33pm UTC](https://discuss.elastic.co/t/kql-bar-limitation/292184/6 "2022-01-17T15:33:35Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.