Versions Compared

Version Old Version 23 New Version 24
Changes made by

Products Admin

Products Admin

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  • By using an equals operator we will fetch records of the provided value

  • valueType: custom

    During means some time between the beginning

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

      • It will return records of the date which comes according to the period count day date

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

      • It will return records of the date which comes according to the period count

      week date

During Operator

      • 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 period component query

  • Yesterday

    • If condition{ period: ”yesterday”

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

      • 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 the current day record

      If condition{ period: ”next7Days”

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

      • 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-02-23}

  • valueType: relative

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

      • 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 dayrecords 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”

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 period component query

  • Yesterday

    • If condition{ period: ”next180Days””yesterday”}

      • It will return the next 180 previous day's records record from the current day

    • If condition{ period: ”previous7Days””tomorrow”}

      • It will return the previous 7 next day's records record from the current day

    • If condition{ period: ”previous30Days””today”}

      • It will return the previous 30 day's records from the current day record

    • If condition{ period: ”previous60Days””next7Days”}

      • It will return the previous 60 next 7 day's records from the current day

    • If condition{ period: ”previous90Days””next30Days”}

      • It will return the previous 90 next 30 day's records from the current day

    • If condition{ period: ”previous180Days””next60Days”}

      • It will return the previous 180 next 60 day's records from the current day

    • If condition{ period: “currentWeek””next90Days”}

      • It will return the current week records next 90 day's records from the current day

    • If condition{ period: “nextWeek””next180Days”}

      • It will return the next week 180 day's records from the current weekday

    • If condition{ period: “previousWeek”previous7Days”}

      • It will return the previous week 7 day's records from the current weekday

    • If condition{ period: “currentAndNextWeek””previous30Days”}

      • It will return the next week and previous 30 day's records from the current week recordsday

    • If condition{ period: “currentAndPreviousWeek”previous60Days”}

      • It will return the previous week and 60 day's records from the current week's’s recordsday

    • If condition{ period: “currentMonth””previous90Days”}

      • It will return the current month records previous 90 day's records from the current day

    • If condition{ period: “nextMonth””previous180Days”}

      • It will return the next month previous 180 day's records from the current month day

    • If condition{period: “previousMonth“currentWeek”}

      • It will return the previous month records from the current month current week records

    • If condition {period: “currentAndNextMonth”“nextWeek”}

      • It will return the next month and week records from the current month recordsweek

    • If condition {period: “currentAndPreviousMonth“previousWeek}

      • It will return the previous month and week records from the current month recordsweek

    • If condition {period: “currentCalendarQuarter”“currentAndNextWeek”}

      • It will return the current calendar quarter next week and the current week records

    • If condition {period: “nextCalendarQuarter”“currentAndPreviousWeek}

      • It will return the next calendar quarter records from the current calendar quarterprevious week and the current week's’s records

    • If condition{period: “previousCalendarQuarter“currentMonth”}

      • It will return the previous calendar quarter records from the current calendar quartercurrent month records

    • If condition {period: “currentAndNextCalendarQuarter”“nextMonth”}

      • It will return the next calendar quarter and month records from the current calendar quarter recordsmonth

    • If condition {period: “currentAndPreviousCalendarQuarter“previousMonth}

      • It will return the previous calendar quarter and month records from the current calendar quarter recordsmonth

    • If condition {period: “currentCalendarYear”“currentAndNextMonth”}

      • It will return the current calendar year next month and the current month records

    • If condition {period: “nextCalendarYear”“currentAndPreviousMonth}

      • It will return the next calendar year records from previous month and the current calendar year month records

    • If condition{period: “previousCalendarYear“currentCalendarQuarter”}

      • It will return the previous current calendar year quarter records from the current calendar year

    • If condition {period: “currentAndNextCalendarYear”“nextCalendarQuarter”}

      • It will return the next calendar year and quarter records from the current calendar year recordsquarter

    • If condition {period: “currentAndPreviousCalendarYear“previousCalendarQuarter}

      • It will return the previous calendar year and quarter records from the current calendar year recordsquarter

    • If condition {period: “currentFiscalQuarter”“currentAndNextCalendarQuarter”}

      • It will return the next calendar quarter and the current fiscal calendar quarter records

    • If condition {period: “nextFiscalQuarter”“currentAndPreviousCalendarQuarter}

      • It will return the next fiscal quarter records from previous calendar quarter and the current fiscal calendar quarter records

    • If condition{period: “previousFiscalQuarter“currentCalendarYear”}

      • It will return the previous fiscal quarter records from the current fiscal quartercurrent calendar year records

    • If condition {period: “currentAndNextFiscalQuarter”“nextCalendarYear”}

      • It will return the next fiscal quarter and calendar year records from the current fiscal quarter recordscalendar year

    • If condition {period: “currentAndPreviousFiscalQuarter”“previousCalendarYear}

      • It will return the previous fiscal quarter and calendar year records from the current fiscal quarter recordscalendar year

    • If condition {period: “currentFiscalYear”“currentAndNextCalendarYear”}

      • It will return the next calendar year and the current fiscal calendar year records

    • If condition {period: “nextFiscalYear”“currentAndPreviousCalendarYear}

      • It will return the next fiscal year records from previous calendar year and the current calendar year records

    • If condition{period: “currentFiscalQuarter”}

      • It will return the current fiscal year quarter records

    • If condition {period: “previousFiscalYear”“nextFiscalQuarter”}

      • It will return the previous next fiscal year quarter records from the current fiscal year quarter

    • If condition {period: “currentAndNextFiscalYear”: “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 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

        next fiscal year and the current fiscal year records
      If condition {period: “currentAndPreviousFiscalYear”

    If the period is custom then you can set the range flow

    • rangeFlow:

          • 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

        previous fiscal year and the current fiscal year records

Period Custom During Operator

          • 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