Dynamic View: Content of Last Month by User X

This solution shows how to configure a filter in the field “Dynamic View” based on the creation date.

Real-world use case:

• Show a summary of content marketing created in the last month.

• Show a summary of all content created by agency A in the last month.

• Show a summary of all content created by photographer B in the last week.

Instructions

1. You add the Dynamic View field

2. You add the filter for the creation date:

   JSON

   {
   	"kind": "DateRangeFilter",
   	"field": "audit.creationDate",
   	"range": {
   		"names": {},
   		"from": "now-1M/d",
   		"to": "now"
   	}
   }

   1. This filter will relate all Content Items with a creation date in the last month from now, so all content was created within the last month.

3. You add the filter for the creation date and one user:

   JSON

   {
   	"kind": "AndFilter",
   	"filters": [
   		{
   			"kind": "DateRangeFilter",
   			"field": "audit.creationDate",
   			"range": {
   				"names": {},
   				"from": "now-1M/d",
   				"to": "now"
   			}
   		},
   		{
   			"kind": "TermFilter",
   			"field": "audit.createdByUser",
   			"term": "a5e981834f4f47aaa5f5c88fe1dad915"
   		}
   	]
   }

   1. This filter will relate all Content Items with a creation date in the last month from now created by a specific user, so all content created within the last month by the user with id “a5e981834f4f47aaa5f5c88fe1dad915”.

4. You add the filter for the creation date and multiple users (aka marketing) :

   JSON

   {
   	"kind": "AndFilter",
   	"filters": [
   		{
   			"kind": "DateRangeFilter",
   			"field": "audit.creationDate",
   			"range": {
   				"names": {},
   				"from": "now-1M/d",
   				"to": "now"
   			}
   		},
   		{
   			"kind": "TermsFilter",
   			"field": "audit.createdByUser",
   			"terms": [
   				"a55684734f4f47aaa5f5c88fe1dad915",
   				"a5e981834f4f47aaa556848fe1dad915",
   				"568481834f4f47aaa5f5c88fe1dad915",
   				"a5e981834f4f47aaa5f5c88fe1da5684",
   			]
   		}
   	]
   }

   1. This filter will relate all Content Items created within the last month by user 1, 2, 3, or 4

This filter will always include the original content item (the base). If you want to remove the original, you exclude the id from the dynamic view:

• JSON

  {
  	"kind": "NotFilter",
  	"filter": {
  		"kind": "TermFilter",
  		"field": "id",
  		"term": "{{id}}"
  	}
  }

Related articles