...
By using an equals operator we will fetch records of the provided value
valueType: custom
If conditions: {valueType: “custom”, periodUnit: days, periodCount: n}
It will return records of the date which comes according to the period count
If conditions: {valueType: “custom”, periodUnit: weeks, periodCount: n}
It will return records of the date which comes according to the period count and period unit
ex. {value: 2023-06-23, periodCount: 3 then it will return records of date 2023-07-14}
If conditions: {valueType: “custom”, periodUnit: months, periodCount: n}
It will return records of the date which comes according to the period count and period unit
ex. {value: 2023-06-23, periodCount: 3 then it will return records of date 2023-09-23}
If conditions: {valueType: “custom”, periodUnit: calQuarter, periodCount: n}
It will return records of the date which comes according to the period count and period unit
ex. {value: 2023-06-23, periodCount: 3 then it will return records of date 2024-02-23}
If conditions: {valueType: “custom”, periodUnit: calYear, periodCount: n}
It will return records of the date which comes according to the period count and period unit
ex. {value: 2023-06-23, periodCount: 3 then it will return records of date 2026-0206-23}
valueType: relative
If conditions: {valueType: “relative”, periodUnit: calQuarter, periodCount: n}
It will return records of the date which comes according to the period count and period unit
ex. {value: “today’s date and time”, periodCount: 3 then it will return records of date “today’s date + periodCount”
GreaterThan
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
...