cursor_before_or_at()

Learn how to use the cursor_before_or_at() function to compare the ingestion time of the records of a table against the database cursor time.

A predicate function runs over the records of a table to compare their ingestion time against the database cursor time.

IngestionTime policy enabled.

Syntax

cursor_before_or_at(RHS)

Parameters

NameTypeRequiredDescription
RHSstring✔️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.

Related content