Skip to main contentList records created prior to the current UTC DateTime.
1
2
3
4
5
6
7
8
9
10
{
"pageIndex": 0,
"pageSize": 25,
"where": [
{
"field": "sys.version.created",
"lessThan": "now()"
}
]
}
List records created in the last 24 hours (day element inferred).
1
2
3
4
5
6
7
8
9
10
{
"pageIndex": 0,
"pageSize": 25,
"where": [
{
"field": "sys.version.created",
"greaterThanOrEqualTo": "now(-1)"
}
]
}
List records created since the start of today.
1
2
3
4
5
6
7
8
9
10
{
"pageIndex": 0,
"pageSize": 25,
"where": [
{
"field": "sys.version.created",
"greaterThanOrEqualTo": "startOfDay()"
}
]
}
List records created since the start of this day last week.
1
2
3
4
5
6
7
8
9
10
{
"pageIndex": 0,
"pageSize": 25,
"where": [
{
"field": "sys.version.created",
"greaterThanOrEqualTo": "startOfDay(-1w)"
}
]
}
List records created yesterday.
1
2
3
4
5
6
7
8
9
10
11
12
13
14
{
"pageIndex": 0,
"pageSize": 25,
"where": [
{
"field": "sys.version.created",
"greaterThanOrEqualTo": "startOfDay(-1d)"
},
{
"field": "sys.version.created",
"lessThanOrEqualTo": "endOfDay(-1d)"
}
]
}
List Records created prior to the start of the current week.
1
2
3
4
5
6
7
8
9
10
{
"pageIndex": 0,
"pageSize": 25,
"where": [
{
"field": "sys.version.created",
"lessThan": "startOfWeek()"
}
]
}
List records created last week (week element inferred).
1
2
3
4
5
6
7
8
9
10
11
12
13
14
{
"pageIndex": 0,
"pageSize": 25,
"where": [
{
"field": "sys.version.created",
"greaterThanOrEqualTo": "startOfWeek(-1)"
},
{
"field": "sys.version.created",
"lessThanOrEqualTo": "endOfWeek(-1)"
}
]
}
List records created since the start of the current month.
1
2
3
4
5
6
7
8
9
10
{
"pageIndex": 0,
"pageSize": 25,
"where": [
{
"field": "sys.version.created",
"greaterThanOrEqualTo": "startOfMonth()"
}
]
}
List records created in this month last year.
1
2
3
4
5
6
7
8
9
10
11
12
13
14
{
"pageIndex": 0,
"pageSize": 25,
"where": [
{
"field": "sys.version.created",
"greaterThanOrEqualTo": "startOfMonth(-1y)"
},
{
"field": "sys.version.created",
"lessThanOrEqualTo": "endOfMonth(-1y)"
}
]
}
List records created so far this year.
1
2
3
4
5
6
7
8
9
10
{
"pageIndex": 0,
"pageSize": 25,
"where": [
{
"field": "sys.version.created",
"greaterThanOrEqualTo": "startOfYear()"
}
]
}
List records created last year (year element inferred in "lessThanOrEqualTo" operator).
1
2
3
4
5
6
7
8
9
10
11
12
13
14
{
"pageIndex": 0,
"pageSize": 25,
"where": [
{
"field": "sys.version.created",
"greaterThanOrEqualTo": "startOfYear(-1y)"
},
{
"field": "sys.version.created",
"lessThanOrEqualTo": "endOfYear(-1)"
}
]
}