Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Code Block
languagejson
{ 
	"kind": "NestedFilter", 
	"path": "fieldpath", 
	"filter": 
		{ filter1 } 
}

...

Excerpt

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

Code Block
languagejson
// LAYER CORPORATE ASSIGNED AND EVENTS TAGGED IN LAYER
{
	"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.

Code Block
languagejson
{ 
	"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

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