CosmosRepository Pagination with native query @Query

[rannoune]

We are using the following springboot starter dependency:

com.azure.spring
azure-spring-boot-starter-cosmos
3.1.0

We are able to write native queries in the CosmosRepository, but not with pagination. For example:
This is working:

@Query(value = "SELECT * FROM c WHERE ....")
 List<MyDocument> getMyDocumentByTimestamp(...);

This is not working:

@Query(value = "SELECT * FROM c WHERE ....")
 org.springframework.data.domain.Page<MyDocument> getMyDocumentByTimestamp(..., Pageable page);
or 
 org.springframework.data.domain.Page<MyDocument> getMyDocumentByTimestamp(..., CosmosPageRequest page);

Is there a way to achieve this?

[yiliuTo]

Hi, @kushagraThapar and @mbhaskar and could you help with issue? Thanks again.

[ramosa1]

any update on this issue? We are still not able to write native queries with org.springframework.data.domain.Page return type. Can you please help?

[zhichengliu12581]

Hello @ramosa1
Can you please try to upgrade the azure-spring-boot-starter-cosmos version:

    <dependency>
      <groupId>com.azure.spring</groupId>
      <artifactId>azure-spring-boot-starter-cosmos</artifactId>
      <version>3.4.0</version>
    </dependency>

And use the supported spring boot version

  <parent>
    <groupId>org.springframework.boot</groupId>
    <artifactId>spring-boot-starter-parent</artifactId>
    <version>2.4.3</version>
  </parent>

And, here is my sample, I hope it will be helpful to you.