Use order by on the `HighWaterMarkChangeDetectionPolicy` field with the search service API

Hello,

I'm currently work on solution of azure cognitive search with multiple cosmos db indexers.

I use .NET SDK to configure my indexes and indexers.

I set up the HighWaterMarkChangeDetectionPolicy on the _ts filed of my cosmos documents.

I set up the assumeOrderByHighWaterMarkColumn configuration to true like described in this section.

https://learn.microsoft.com/en-us/azure/search/search-howto-index-cosmosdb#incremental-indexing-and-custom-queries

But it remains an incomprehension on the finality. In this section give an example with a SQL like query but in my case I would like to use the search service API with a post request with the body:

{
    "count":true,
    "filter":"type eq 'collection'",
    "queryType":"full",
    "orderby":"_ts",
    "select":"id,collectionName,coverThumbnailURL,type,artists",
    "skip":0,
    "top":10
}

I specify the orderby property with _ts field, but this call gives me this error:

{
    "error": {
        "code": "",
        "message": "Invalid expression: Could not find a property named '_ts' on type 'search.document'.\r\nParameter name: $orderby"
    }
}

I didn't understand how to use order by on the HighWaterMarkChangeDetectionPolicy field with the search service API.

Thanks in advance for your help.

Regards.

Document Details

⚠ Do not edit this section. It is required for learn.microsoft.com ➟ GitHub issue linking.

ID: e1c2c641-bd55-a7aa-b747-bfb75671a7cc
Version Independent ID: 616f0123-6306-f0b3-806b-30c1fbfe702a
Content: Simple query syntax - Azure Cognitive Search
Content Source: articles/search/query-simple-syntax.md
Service: cognitive-search
GitHub Login: @BevLoh
Microsoft Alias: beloh

MicrosoftDocs / azure-docs

Use order by on the `HighWaterMarkChangeDetectionPolicy` field with the search service API #107420

Document Details