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:

   { "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:

   { "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) :

   { "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

Related articles