Table of Contents
Filter Query: Date Range Filter
12. March 2025
Table of Contents
Show content modified in December 2020.
// USING EXACT DATES
{
"kind": "DateRangeFilter",
"field": "audit.modificationDate",
"range": {
"names": {
"fieldId.en":"Dec 2020",
"fieldId.de":"Dez 2020"
},
"from": "2020-12-01T00:00:00.000",
"to": "2020-12-31T00:00:00.000",
}
}Show content with a publish date in the last 30 days.
// USING DAY CALCULATIONS
{
"kind": "DateRangeFilter",
"field": "corporateInformation.publishDate",
"range": {
"names": {
"fieldId.en":"Last 30 days"
"fieldId.de":"Letzte 30 Tage"
},
"from": "now-30D",
"to": "now"
}// USING COMBINATIONS
{
"kind": "DateRangeFilter",
"field": "corporateInformation.embargoDate",
"range": {
"names": {
"fieldId.en":"Last 30 days"
"fieldId.de":"Letzte 30 Tage"
},
"from": "now-30D",
"to": "now"
},
{
"names": {
"fieldId.en":"Last fiscal year"
"fieldId.de":"Last fiscal year"
},
"from": "2019-03-31T01:02:02.000",
"to": "2020-03-31T01:02:02.000"
}
}Picturepark supports
- Y (years), M (month), D (days), H (hours), m (minutes)
- Calculations starting with now e.g. now+30D, now-30D
- Anchor dates and rounding are not supported (e.g. Jun 5th + 30d; now/M for the current month)
Basic Filter
Only content with a date/date-time value in the specified range.
Date Format: YYYY-MM-DDTHH:MM:SS:MMM
- Year-Month-DayTHour-Minute-Second-Millisecond
{
"kind": "DateRangeFilter",
"field": "fieldpath",
"range": {
"names": {
"fieldId.en":"english text shown to the user",
"fieldId.de":"german text shown to the user"
},
"from": "YYYY-MM-DDTHH:MM:SS:MMM",
"to": "YYYY-MM-DDTHH:MM:SS:MMM",
}
}Properties
| kind | Discriminator, string, required |
| field | The field's name to execute the filter on. It is composed of the field ids of the hierarchy joined with "." (i.e. personLayer.address.street), check DateTime field values |
| range | If no range provided, the filter will throw an error "query execution failure" and display it as empty. |
| names | The translations of the ranges are nullable, language-specific range names |
| from | it can be a date-time string or a pattern: now(+-)(int)(YMDHm). |
| to | it can be a date-time string or a pattern: now(+-)(int)(YMDHm). |