Spring Data Scrolling (Window<>) with specification filtering

[wdsouza-mn]

This is related to the query on stack overflow - https://stackoverflow.com/questions/78372812/spring-data-scrolling-window-with-specification-filtering

How do we implement specification based filtering and scrollable api implementation together using findAll()

From Stack overflow:
Spring Data 3.1 introduced the Scrollable API, which allows us to Iterate over data. The documentation describes this only for defined methods within the repository. Example from the Documentation

Window<User> findFirst10ByLastnameOrderByFirstname(String lastname, OffsetScrollPosition position);
In order to be more flexible and support more filter, I would like to query by Specification. Something like

Window<User> findAll(Specification<User> specification, ScrollPosition position, Limit limit, Sort sort );

But this won't even start.

Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'userRepository' defined in io.d4e.graphql.domain.repository.UserRepository defined in @EnableJpaRepositories declared on JpaRepositoriesRegistrar.EnableJpaRepositoriesConfiguration: Could not create query for public abstract org.springframework.data.domain.Window io.d4e.graphql.domain.repository.UserRepository.findAll(org.springframework.data.jpa.domain.Specification,org.springframework.data.domain.ScrollPosition,org.springframework.data.domain.Limit,org.springframework.data.domain.Sort); Reason: Failed to create query for method public abstract org.springframework.data.domain.Window io.d4e.graphql.domain.repository.UserRepository.findAll(org.springframework.data.jpa.domain.Specification,org.springframework.data.domain.ScrollPosition,org.springframework.data.domain.Limit,org.springframework.data.domain.Sort); No property 'findAll' found for type 'User'
   at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1786) ~[spring-beans-6.1.4.jar:6.1.4]
   at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:600) ~[spring-beans-6.1.4.jar:6.1.4]
   at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:522) ~[spring-beans-6.1.4.jar:6.1.4]
   at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:325) ~[spring-beans-6.1.4.jar:6.1.4]
   at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234) ~[spring-beans-6.1.4.jar:6.1.4]
   at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:323) ~[spring-beans-6.1.4.jar:6.1.4]
   at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:199) ~[spring-beans-6.1.4.jar:6.1.4]
   at org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:254) ~[spring-beans-6.1.4.jar:6.1.4]
   at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1443) ~[spring-beans-6.1.4.jar:6.1.4]
   at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1353) ~[spring-beans-6.1.4.jar:6.1.4]
   at org.springframework.beans.factory.support.ConstructorResolver.resolveAutowiredArgument(ConstructorResolver.java:907) ~[spring-beans-6.1.4.jar:6.1.4]
   at org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:785) ~[spring-beans-6.1.4.jar:6.1.4]
   ... 19 common frames omitted
Caused by: org.springframework.data.repository.query.QueryCreationException: Could not create query for public abstract org.springframework.data.domain.Window io.d4e.graphql.domain.repository.UserRepository.findAll(org.springframework.data.jpa.domain.Specification,org.springframework.data.domain.ScrollPosition,org.springframework.data.domain.Limit,org.springframework.data.domain.Sort); Reason: Failed to create query for method public abstract org.springframework.data.domain.Window io.d4e.graphql.domain.repository.UserRepository.findAll(org.springframework.data.jpa.domain.Specification,org.springframework.data.domain.ScrollPosition,org.springframework.data.domain.Limit,org.springframework.data.domain.Sort); No property 'findAll' found for type 'User'
   at org.springframework.data.repository.query.QueryCreationException.create(QueryCreationException.java:101) ~[spring-data-commons-3.2.3.jar:3.2.3]
   at org.springframework.data.repository.core.support.QueryExecutorMethodInterceptor.lookupQuery(QueryExecutorMethodInterceptor.java:115) ~[spring-data-commons-3.2.3.jar:3.2.3]
   at org.springframework.data.repository.core.support.QueryExecutorMethodInterceptor.mapMethodsToQuery(QueryExecutorMethodInterceptor.java:99) ~[spring-data-commons-3.2.3.jar:3.2.3]
   at org.springframework.data.repository.core.support.QueryExecutorMethodInterceptor.lambda$new$0(QueryExecutorMethodInterceptor.java:88) ~[spring-data-commons-3.2.3.jar:3.2.3]
   at java.base/java.util.Optional.map(Optional.java:260) ~[na:na]
   at org.springframework.data.repository.core.support.QueryExecutorMethodInterceptor.<init>(QueryExecutorMethodInterceptor.java:88) ~[spring-data-commons-3.2.3.jar:3.2.3]
   at org.springframework.data.repository.core.support.RepositoryFactorySupport.getRepository(RepositoryFactorySupport.java:357) ~[spring-data-commons-3.2.3.jar:3.2.3]
   at org.springframework.data.repository.core.support.RepositoryFactoryBeanSupport.lambda$afterPropertiesSet$5(RepositoryFactoryBeanSupport.java:279) ~[spring-data-commons-3.2.3.jar:3.2.3]
   at org.springframework.data.util.Lazy.getNullable(Lazy.java:135) ~[spring-data-commons-3.2.3.jar:3.2.3]
   at org.springframework.data.util.Lazy.get(Lazy.java:113) ~[spring-data-commons-3.2.3.jar:3.2.3]
   at org.springframework.data.repository.core.support.RepositoryFactoryBeanSupport.afterPropertiesSet(RepositoryFactoryBeanSupport.java:285) ~[spring-data-commons-3.2.3.jar:3.2.3]
   at org.springframework.data.jpa.repository.support.JpaRepositoryFactoryBean.afterPropertiesSet(JpaRepositoryFactoryBean.java:132) ~[spring-data-jpa-3.2.3.jar:3.2.3]
   at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1833) ~[spring-beans-6.1.4.jar:6.1.4]
   at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1782) ~[spring-beans-6.1.4.jar:6.1.4]
   ... 30 common frames omitted
Caused by: java.lang.IllegalArgumentException: Failed to create query for method public abstract org.springframework.data.domain.Window io.d4e.graphql.domain.repository.UserRepository.findAll(org.springframework.data.jpa.domain.Specification,org.springframework.data.domain.ScrollPosition,org.springframework.data.domain.Limit,org.springframework.data.domain.Sort); No property 'findAll' found for type 'UserEntity'
   at org.springframework.data.jpa.repository.query.PartTreeJpaQuery.<init>(PartTreeJpaQuery.java:106) ~[spring-data-jpa-3.2.3.jar:3.2.3]
   at org.springframework.data.jpa.repository.query.JpaQueryLookupStrategy$CreateQueryLookupStrategy.resolveQuery(JpaQueryLookupStrategy.java:124) ~[spring-data-jpa-3.2.3.jar:3.2.3]
   at org.springframework.data.jpa.repository.query.JpaQueryLookupStrategy$Create

[mp911de]

Specifications can only be evaluated from JpaSpecificationExecutor, query derivation doesn't support specification objects.

You call would look like:

UserRepository extends Repository<User, Long>, JpaSpecificationExecutor<User> { … }

repo.findBy(spec, query -> query.limit(…).sortBy(…).scroll(…));