Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Applies to: ✅ Microsoft Fabric ✅ Azure Data Explorer ✅ Azure Monitor ✅ Microsoft Sentinel
A predicate function runs over the records of a table to compare their ingestion time against the database cursor time.
Note
This function can only be invoked on records of a table that has the IngestionTime policy enabled.
Syntax
cursor_before_or_at(RHS)
Learn more about syntax conventions.
Parameters
| Name | Type | Required | Description |
|---|---|---|---|
| RHS | string |
✔️ | Either an empty string literal or a valid database cursor value. |
Returns
Returns a scalar value of type bool that indicates whether the record was ingested
before or at the database cursor RHS (true) or not (false).
Examples
The following example retrieves records ingested before or at a specific database cursor.
MyTable
| where cursor_before_or_at('2024-08-01T12:00:00Z')
Output
The output includes all records from MyTable that were ingested before or at the specified date, August 1, 2024, at 12:00 PM UTC.
This filters 'MyTable' to only include the records ingested before or at the specified cursor time.