Micronaut 数据 @Query 的计数查询示例 [英] Example count query for Micronaut data @Query

问题描述

有人可以举个例子 countQuery 在使用 Micronaut 数据进行显式查询 (@Query) 时实现分页吗?https://micronaut-projects.github 上没有示例.io/micronaut-data/latest/guide/#explicitQueries

Can someone give an example countQuery to implement pagination while doing explicit query (@Query) using Micronaut data? There is no examples at https://micronaut-projects.github.io/micronaut-data/latest/guide/#explicitQueries

我必须进行如下查询

@Query("From UserRelation where userId = :userId and itemId=:itemId", countQuery = <count query here>)

推荐答案

你可以这样做:

@Query(
  value = "select relation_ from UserRelation relation_ where relation_.userId = :userId and relation_.itemId = :itemId", 
  countQuery = "select count(relation_) from UserRelation relation_ where relation_.userId = :userId and relation_.itemId = :itemId"
)

count 查询将相同，只有一个更改，它是 SELECT 子句中的 count() 函数.

The count query will be the same only with one change and it is the count() function in the SELECT clause.

这篇关于Micronaut 数据 @Query 的计数查询示例的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！