Source_filtering by value not field

Elastic Stack Elasticsearch
1

My documents contains a nested array of Ids.

I want to filter on these IDs (eg return only those documents where one of the IDs is 6489354).

There might be thousands of IDs, so I only want to return the the source where those IDs are equal to certain values (eg.1,6,or 9)

So lets say I had these two documents:

{
	{Name:Document1}
	Nested IDs
	[
		{ID:1}
		{ID:5}
		{ID:9}
		{ID:6489354}
	]
}

{
	{Name:Document2}
	Nested IDs
	[
		{ID:1}
		{ID:5}
		{ID:9}
	]
}

Only document1 should be returned, and it's source should be:

{
	{Name:Document1}
	Nested IDs
	[
		{ID:1}
		{ID:9}
	]
}

Currently sourceFiltering does not work on values, only fields. Is there some other way around this?

Thanks

2

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