Channel Filter: Show Items not Triggered in a Fieldset

Goal: Show Content Items which have a fieldset in metadata in which you find a trigger field e.g. a status field like approved, checked, reviewed, completed. Now show the items which are not triggered (not approved, not reviewed etc.)

Picturepark setup

Layer: "Creative Projects"
Fieldset: "Requests"
- with a note field for the task/request, a field that is required and indexed (included in filters)
- with a trigger field which shall be triggered when the request is completed

Channel Filter

{
	"kind": "AndFilter",
	"filters": [
		{
			"kind": "NestedFilter",
			"path": "creativeProjects.requests",
			"filter": {
				"kind": "AndFilter",
				"filters": [
					{
						"kind": "NotFilter",
						"filter": {
							"kind": "ExistsFilter",
							"field": "creativeProjects.requests.completed.triggeredOn"
						}
					},
					{
						"kind": "ExistsFilter",
						"field": "creativeProjects.requests.noteComment"
					}
				]
			}
		},
		{
			"kind": "TermFilter",
			"field": "layerSchemaIds",
			"term": "CreativeProjects"
		}
	]
}