CODEWITHSUNDEEP
spring-bootredisspring-data-redisredisearchredis-om-spring
RaymondCarlo
RaymondCarlo

Reputation: 11

Returning only the first 10 record - Redis OM

I’m using Redis OM for spring boot, I am having trouble querying objects because it only returns the first 10 records.

Repository Class:

public interface RedisBillerRepository extends RedisDocumentRepository<Biller, Long> {
  List<Biller> findByClientIds(String clientId);
}

Is there a way to return ALL the objects with the specific clientId? Not the first 10 only.

Upvotes: 1

Views: 1352

Answers (2)

BSB
BSB

Reputation: 1705

I'm the author of the library... @member2 is correct. RediSearch currently has a default for the underlying FT.SEARCH (https://redis.io/commands/ft.search/) method of returning the first 10 records found. To override that, the only way to do so currently is to use the Pagination constructs in Spring.

I will expose a configuration parameter in upcoming versions to set the MAX globally.

Now there are officially two ways:

  1. Use Spring's Pageable class like https://github.com/redis/redis-om-spring/blob/main/redis-om-spring/src/test/java/com/redis/om/spring/annotations/document/fixtures/MyDocRepository.java#L57 then see example of how to use it here https://github.com/redis/redis-om-spring/blob/main/redis-om-spring/src/test/java/com/redis/om/spring/annotations/document/RedisDocumentSearchTest.java#L143
  2. Configure a default LIMIT for all your queries as shown here https://github.com/redis/redis-om-spring/blob/main/redis-om-spring/src/test/resources/application.yaml
redis:
  om:
    spring:
      repository:
        query:
          limit: 20

Upvotes: 1

member2
member2

Reputation: 175

The only way which i found was with the interface Page. For example your Repository would look like this:

public interface RedisBillerRepository extends RedisDocumentRepository<Biller, Long> {
    Page<Biller> findByClientIds(String clientId, Pageable pageable);
}

And your class could look like this

public class BillerService {

@Autowired
RedisBillerRepository redisBillerRepository;


public List<Biller> getAllClientsById(String clientId){
    Pageable pageRequest = PageRequest.of(0, 500000);
    Page<Biller> foundBillers = redisBillerRepository.findByClientIds(clientId, pageRequest);
    List<Biller> billersAsList = foundBillers.getContent();
    return billersAsList;
}

}

You have to set the limit for now.

Upvotes: 3

Related Questions