Content Comparison

...

• 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-06-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

• By using greaterThan operator we will fetch records greater than the provided value

• valueType: custom

  • If conditions: {valueType: “custom”, periodUnit: days, periodCount: n}

    • It will return records of dates greater than the date which came according to the period count and period unit

      • ex. {value: 2023-06-23, periodCount: 3 then it will return records greater than the date 2023-06-26}

• valueType: relative

  • If conditions: {valueType: “relative”, periodUnit: calQuarter, periodCount: n}

    • It will return records of dates greater than the date which came according to the period count and period unit

      • ex. {value: “today’s date and time”, periodCount: 3 then it will return records of a date greater than “today’s date + periodCount” date

GreaterThanEqual

• By using the gte operator we will fetch records greater than the provided value and the records of 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 greater than the date

      • ex. {value: 2023-06-23, periodCount: 3 then it will return records of the date 2023-06-26 and records of a date greater than 2023-06-26 }

• 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 greater 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 greater than that date

LessThan

• By using the lt operator we will fetch records less than the provided value

• valueType: custom

  • If conditions: {valueType: “custom”, periodUnit: days, periodCount: n}

    • It will return records of the date less than the date which came according to the period count and period unit

      • ex. {value: 2023-06-23, periodCount: 3 then it will return records less than the date 2023-06-20}

• valueType: relative

  • If conditions: {valueType: “relative”, periodUnit: calQuarter, periodCount: n}

    • It will return records of the date less than the date which came according to the period count and period unit

      • ex. {value: “today’s date and time”, periodCount: 3 then it will return records of the date less than “today’s date - periodCount” date

LessThanEquals

• 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

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

...