...
Yesterday
If condition{ period: ”yesterday”}
It will return the previous day's record from the current day
If condition{ period: ”tomorrow”}
It will return the next day's record from the current day
If condition{ period: ”today”}
It will return the current day record
If condition{ period: ”next7Days”}
It will return the next 7 day's records from the current day
If condition{ period: ”next30Days”}
It will return the next 30 day's records from the current day
If condition{ period: ”next60Days”}
It will return the next 60 day's records from the current day
If condition{ period: ”next90Days”}
It will return the next 90 day's records from the current day
If condition{ period: ”next180Days”}
It will return the next 180 day's records from the current day
If condition{ period: ”previous7Days”}
It will return the previous 7 day's records from the current day
If condition{ period: ”previous30Days”}
It will return the previous 30 day's records from the current day
If condition{ period: ”previous60Days”}
It will return the previous 60 day's records from the current day
If condition{ period: ”previous90Days”}
It will return the previous 90 day's records from the current day
If condition{ period: ”previous180Days”}
It will return the previous 180 day's records from the current day
If condition{period: “currentWeek”}
It will return the current week records
If condition {period: “nextWeek”}
It will return the next week records from the current week
If condition {period: “previousWeek}
It will return the previous week records from the current week
If condition {period: “currentAndNextWeek”}
It will return the next week and the current week records
If condition {period: “currentAndPreviousWeek}
It will return the previous week and the current week's’s records
If condition{period: “currentMonth”}
It will return the current month records
If condition {period: “nextMonth”}
It will return the next month records from the current month
If condition {period: “previousMonth}
It will return the previous month records from the current month
If condition {period: “currentAndNextMonth”}
It will return the next month and the current month records
If condition {period: “currentAndPreviousMonth}
It will return the previous month and the current month records
If condition{period: “currentCalendarQuarter”}
It will return the current calendar quarter records
If condition {period: “nextCalendarQuarter”}
It will return the next calendar quarter records from the current calendar quarter
If condition {period: “previousCalendarQuarter}
It will return the previous calendar quarter records from the current calendar quarter
If condition {period: “currentAndNextCalendarQuarter”}
It will return the next calendar quarter and the current calendar quarter records
If condition {period: “currentAndPreviousCalendarQuarter}
It will return the previous calendar quarter and the current calendar quarter records
If condition{period: “currentCalendarYear”}
It will return the current calendar year records
If condition {period: “nextCalendarYear”}
It will return the next calendar year records from the current calendar year
If condition {period: “previousCalendarYear}
It will return the previous calendar year records from the current calendar year
If condition {period: “currentAndNextCalendarYear”}
It will return the next calendar year and the current calendar year records
If condition {period: “currentAndPreviousCalendarYear}
It will return the previous calendar year and the current calendar year records
If condition{period: “currentFiscalQuarter”}
It will return the current fiscal quarter records
If condition {period: “nextFiscalQuarter”}
It will return the next fiscal quarter records from the current fiscal quarter
If condition {period: “previousFiscalQuarter}
It will return the previous fiscal quarter records from the current fiscal quarter
If condition {period: “currentAndNextFiscalQuarter”}
It will return the next fiscal quarter and the current fiscal quarter records
If condition {period: “currentAndPreviousFiscalQuarter”}
It will return the previous fiscal quarter and the current fiscal quarter records
If condition{period: “currentFiscalYear”}
It will return the current fiscal year records
If condition {period: “nextFiscalYear”}
It will return the next fiscal year records from the current fiscal year
If condition {period: “previousFiscalYear”}
It will return the previous fiscal year records from the current fiscal year
If condition {period: “currentAndNextFiscalYear”}
It will return the next fiscal year and the current fiscal year records
If condition {period: “currentAndPreviousFiscalYear”}
It will return the previous fiscal year and the current fiscal year records
...
Custom period in During Operator
If the period is custom, then rangeFlow, startDate, and endDate should be required
rangeFlow
You can set rangFlow in two ways start and end
If you can set rangeFlow as a : start then the start date should be is required
For Example: {periodUnit: days, periodCount: 1, rangeFlow: “start”, startDate: 2023-06-22}
It will return the record which starts from 2023-06-22 and ends after one day
If you can set rangeFlow as a : end then the end date should be is required
For Example: {periodUnit: days, periodCount: 1, rangeFlow: “end”, endDate: 2023-06-22}
It will return the record which starts from 2023-06-22 and ends before prior one day
Since the end End will return previous records and the start will return the next records according to the given periodUnit and periodCount
...
You can set the startDate and endDate conditions in for during operator
For Example: condition: startDate: "2023-06-02" and endDate: "2023-06-19"}
It will return the records from 2023-06-02 to 2023-06-19.
The start date is always less than the end date
...