Versions Compared

Key

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

...

  • By using the current operator it will fetch records according to the period unit from beginning to end

  • The value type for operator current is always relative

    • If conditions: {periodUnit: days}

      • It will return all records of the current day}

    • If conditions: {periodUnit: weeks}

      • It will return all records of the current week from Sunday to Saturday

    • If conditions: {periodUnit: months}

      • It will return all records of the current month from 1st day of the current month to the last day of the current month

...

next Operator

  • If conditions: {periodUnit: days, periodCount: n}

    • It will return records between the next day and the period count day

      ex. {periodCount: 3}

      “today + periodCount” day

  • If conditions: {periodUnit: weeks, periodCount: n}

    • It will return records between the next week and the “today + periodCount” week

currentAndNext Operator

  • If conditions: {periodUnit: days, periodCount: n}

    • It will return records between the current day and the “today + periodCount” day

  • If conditions: {periodUnit: weeks, periodCount: n}

    • It will return records between the current week and the “today + periodCount” week

previous Operator

  • If conditions: {periodUnit: days, periodCount: n}

    • It will return records between the prior day of the current day and the “today - periodCount” day

  • If conditions: {periodUnit: weeks, periodCount: n}

    • It will return records between the prior week of the current week and the “today - periodCount” week

currentAndPrevious Operator

  • It will return records between the current day and the “today - periodCount” day

  • If conditions: {periodUnit: days, periodCount: n}

    • It will return records between the current day and the “today - periodCount” day

  • If conditions: {periodUnit: weeks, periodCount: n}

    • It will return records between the current week and the “today + periodCount” week

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

...