Filter Query: Nested Filter for Multi Tagboxes

Layer Corporate assigned, but no events tagged in the Corporate Layer.

JSON

{
	"kind": "AndFilter",
	"filters": [
		{
			"kind": "TermFilter",
			"field": "layerSchemaIds",
			"term": "CorporateLayer"
		},
		{
			"kind": "NestedFilter",
			"path": "corporateLayer.events",
			"filter": {
				"kind":"NotFilter",
				"filter": {
					"kind": "ExistsFilter",
					"field": "corporateLayer.events._refId"
				}
			}
		}
	]
}

Basic Filter

Filter on criteria from nested documents (multi tagboxes, multi relations, multi fieldsets, not translations) e.g. product numbers from a list which is assigned via product information tagbox.

JSON

{ 
	"kind": "NestedFilter", 
	"path": "fieldpath", 
	"filter": 
		{ filter1 } 
}

Properties

kind	string, required, e.g. “NestedFilter”
path	The path pointing to the nested document (i.e. personLayer.nestedAddress). The whole collection of tags (my array).
filter (single)	The filter to be applied for nested documents, basically which value you want to get from the array of nested values.

Layer Assigned and Events Tagged in Layer

JSON

// LAYER CORPORATE ASSIGNED AND EVENTS TAGGED IN LAYER
{
	"kind": "AndFilter",
	"filters": [
		{
			"kind": "TermFilter",
			"field": "layerSchemaIds",
			"term": "CorporateLayer"
		},
		{
			"kind": "NestedFilter",
			"path": "corporateLayer.events",
			"filter": {
				"kind": "ExistsFilter",
				"field": "corporateLayer.events._refId"
			}
		}
	]
}