Are Spring Data Neo4j Rest’s pagination and sorting capabilities compatible with custo

public interface StudentRepository extends GraphRepository { <div class="snippet-c

<a class="user-mention notranslate" data-hovercard-type="user" data-hovercard-url="/us

spring-data-neo4j-rest pagination and sorting with custom @Query? about sdn-university HOT 3 CLOSED

neo4j-examples commented on August 27, 2024

spring-data-neo4j-rest pagination and sorting with custom @Query?

from sdn-university.

Comments (3)

espiegelberg commented on August 27, 2024

public interface StudentRepository extends GraphRepository {

Page<Student> findByName(@Param("name") String name, Pageable pageable);

@Query("match (s1:Student)-[r:BUDDY]-(sb:StudyBuddy)-[r2:BUDDY]-(s2:Student) where id(s1) = {studentId} return s2")
Set<Student> findStudyBuddyStudents_no_paginiation(@Param("studentId") Long studentId);

@Query("match (s1:Student)-[r:BUDDY]-(sb:StudyBuddy)-[r2:BUDDY]-(s2:Student) where id(s1) = {studentId} return s2 order by s2.name {placeholder} ")
Set<Student> findStudyBuddyStudents_no_paginiation_custom_sort(@Param("studentId") Long studentId, @Param("placeholder") String placeholder);

@Query("match (s1:Student)-[r:BUDDY]-(sb:StudyBuddy)-[r2:BUDDY]-(s2:Student) where id(s1) = {studentId} return s2")
Page<Student> findStudyBuddyStudents_with_paginiation(@Param("studentId") Long studentId, Pageable pageable);

}

from sdn-university.

luanne commented on August 27, 2024

@espiegelberg paging, sorting and custom depths are not yet supported on custom queries (@query) or derived finders in SDN. There's a JIRA issue to track this: https://jira.spring.io/browse/DATAGRAPH-653
and the documentation stating that this is not yet supported has already been improved (available in the next release).

from sdn-university.