...
By using the lte operator we will fetch records less than the provided value and the records of the date provided
valueType: custom
If conditions: {valueType: “custom”, periodUnit: days, periodCount: n}
It will return a record of the date which came according to the period count and period unit, and records less than the date
ex. {value: 2023-06-23, periodCount: 3 then it will return records of the date 2023-06-20 and records of a date less than 2023-06-20 }
valueType: relative
If conditions: {valueType: “relative”, periodUnit: calQuarter, periodCount: n}
It will return a record of the date which came according to the period count and period unit, and records less than the date
ex. {value: “today’s date and time”, periodCount: 3 then it will return records of a date “today’s date - periodCount” date and less than that date
Current Operator
By using the current operator it will fetch records according to the period unit
Value type for operator current is alwa
During Operator
During means some time between the beginning and the end of a period
The during operator of the period component query is applicable for the Date and DateTime fields
Relative Literals in
...
During Operator
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
Period Custom 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 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 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 one day
Since the end will return previous records and the start will return the next records according to the given periodUnit and periodCount
startDate and endDate in During Operator
You can set the startDate and endDate conditions in 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
...