Adaptive Search Queries: Date Buckets
Adaptive search supports te following data buckets for date-based search.
Date Bucket Name | Mnemonic | Calendar Type | JSON Sample |
---|---|---|---|
Today |
Today |
Day |
"q": { "op": "$eq", "attribute": "CreationDate", "value": "now" } |
Over 2 Years Ago |
Over2YearsAgo |
Year |
|
Last 90 days |
Last90days |
Day |
"q": { "op": "$lt", "attribute": "CreationDate", "value": "now-90d/d" } |
Next Year |
NextYear |
Year |
|
This Year |
ThisYear |
"q": { "op": "$wi", "attribute": "DueDate", "value1":"2019-01-01", "value2": "2019-12-31" } |
|
Next 90 days |
Next90days |
Day |
"q": { "op": "$wi", "attribute":
"DueDate", "value1":"now", "value2":
"now+90d/d" } |
Last Year |
LastYear |
Year |
|
Next 9 Months |
Next9Months |
Month |
"q": { "op": "$lt", "attribute": "CreationDate", "value": "now-9M/M" } |
Last 60 days |
Last60days |
Day |
|
This Month |
ThisMonth |
Month |
|
Last 3 Months |
Last3Months |
Month |
|
Tomorrow |
Tomorrow |
Day |
|
Last 9 Months |
Last9Months |
Month |
|
This Quarter |
ThisQuarter |
Quarter |
|
Over 3 Years Ago |
Over3YearsAgo |
Year |
|
Next Month |
NextMonth |
Month |
|
First Month Of This Quarter |
FirstMonthOfThisQuarter |
Quarter |
|
Next 3 Months |
Next3Months |
Month |
|
This Week |
ThisWeek |
CalendarWeek |
|
In The Future |
InTheFuture |
Day |
|
Last Month |
LastMonth |
Month |
|
Last 30 days |
Last30days |
Day |
|
Over 1 Year Ago |
Over1YearAgo |
Year |
|
Next Quarter |
NextQuarter |
Quarter |
|
Last Week |
LastWeek |
CalendarWeek |
|
Yesterday |
Yesterday |
Day |
|
Next 30 days |
Next30days |
Day |
|
Next 60 days |
Next60days |
Day |
|
Next 6 Months |
Next6Months |
Month |
|
Next Week |
NextWeek |
CalendarWeek |
|
First 2 Months Of This Quarter |
First2MonthsOfThisQuarter |
Quarter |
|
Last Quarter |
LastQuarter |
Quarter |
|
Last 6 Months |
Last6Months |
Month |
|
In The Past |
InThePast |
Day |
|
This Fiscal Quarter |
ThisFiscalQuarter |
Fiscal Quarter |
"q": { "op": "$wi", "attribute": "CreationDate", "value1": "now/fq", "value2": "now/fq+1fq" } |