Content Comparison

...

• Number of the records to be queried at once

  • e.g. if there are 200 records of an object and you set a limit of 100 then it will query the first 100 records and show them on the List View

• The default limit is 200 or as per the page size if the records needs need to be displayed on the table or listview

...

• To filter the records of an object for a particular duration e.g. for days, weeks, months, years, financial years, etc.

• Period types are as follows:

  • days: n

    • If conditions: { createdOn: "days:n"}

      • It will return the records which are created between the current date to 'n' days

    • If conditions: { createdOn: "days:-n"}

      • It will return the records which are created from the 'n' days prior to the current date till the current date

  • weeks: n

    • If conditions: { createdOn: "weeks:n"}

      • It will return the records which are created between the current week to 'n' weeks

    • If conditions: { createdOn: "weeks:-n"}

      • It will return the records which are created from the 'n' weeks prior to the current week till the current week

  • months: n

    • If conditions: { createdOn: "weeks:n"}

      • It will return the records which are created between the current month to 'n' months

    • If conditions: { createdOn: "weeks:-n"}

      • It will return the records which are created from the 'n' months prior to the current month till the current month

  • calQuarters: n (calendar quarter)

    • If conditions: { createdOn: "calQuarters:n"}

      • It will return the records which are created between the current calendar quarter to 'n' calendar quarters

    • If conditions: { createdOn: "calQuarters:n"}

      • It will return the records which are created from the 'n' calendar quarter prior to the current calendar quarter till the current calendar quarter

  • fYQuarters: n (financial quatrer)

    • If conditions: { createdOn: "fYQuarters:n"}

      • It will return the records which are created between the current financial quarter to 'n' financial quarters

    • If conditions: { createdOn: "fYQuarters:n"}

      • It will return the records which are created from the 'n' financial quarter prior to the current financial quarter till the current financial quarter

  • calYears: n (current calendar year)

    • If conditions: { createdOn: "calYears:n"}

      • It will return the records which are created between the current calendar year to 'n' calendar years

    • If conditions: { createdOn: "calYears:n"}

      • It will return the records which are created from the 'n' calendar year prior to the current calendar year till the current calendar year

  • fYYears: n (current financial year)

    • If conditions: { createdOn: "fYYears:n"}

      • It will return the records which are created between the current financial year to 'n' financial years

    • If conditions: { createdOn: "fYYears:n"}

      • It will return the records which are created from the 'n' financial year prior to the current financial year till the current financial year

...