# Array intersection
**URL:** https://discuss.elastic.co/t/array-intersection/167120
**Category:** Elasticsearch
**Created:** [February 5, 2019, 12:33pm UTC](https://discuss.elastic.co/t/array-intersection/167120 "2019-02-05T12:33:02Z")
**Posts on this page:** 4
**Page:** 1
### Author:  [@srikanthkadem](https://discuss.elastic.co/u/srikanthkadem)
#### Post date: [February 5, 2019, 12:33pm UTC](https://discuss.elastic.co/t/array-intersection/167120/1 "2019-02-05T12:33:02Z")
Hi ,
Can some one suggest me query for following scenario.
My search cretiria is list of values [1,2,3,4,5,6,7]
and ES will have data groups column as
in row1--\>groups 1,2
in row2--\>groups 1,2,3
in row3 --\>groups 8,9
so my requirement is to pick row1 and row2 as intersection with inputdata count is equal to groups count in row.
Please suggest
---
### Author:  [@Christian\_Dahlqvist](https://discuss.elastic.co/u/Christian_Dahlqvist)
#### Post date: [February 5, 2019, 12:39pm UTC](https://discuss.elastic.co/t/array-intersection/167120/2 "2019-02-05T12:39:45Z")
Might the [terms set query](https://www.elastic.co/guide/en/elasticsearch/reference/6.6/query-dsl-terms-set-query.html) be an option?
---
### Author:  [@srikanthkadem](https://discuss.elastic.co/u/srikanthkadem)
#### Post date: [February 5, 2019, 12:47pm UTC](https://discuss.elastic.co/t/array-intersection/167120/3 "2019-02-05T12:47:10Z")
Thank you @Christian_Dahlqvist. I will try that.
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [March 5, 2019, 12:59pm UTC](https://discuss.elastic.co/t/array-intersection/167120/4 "2019-03-05T12:59:31Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.