Array intersection

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

Might the terms set query be an option?

Thank you @Christian_Dahlqvist. I will try that.

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