Announcement Announcement Module
No announcement yet.
[Neo4j] Cypher query: Skip and limit parameters: Parameter not found Page Title Module
Move Remove Collapse
Conversation Detail Module
  • Filter
  • Time
  • Show
Clear All
new posts

  • [Neo4j] Cypher query: Skip and limit parameters: Parameter not found

    I'm trying to execute this query in a SDN repository:

    @Query(value="start g=node:groups(\"name:*\") " +
    "match u-[b?:belongs]->g<-[c?:contains*0..8]-p<-[n?:contains]-h " +
    "where ((u.login AND u.login=~ {query}) " +
    "OR {query}) " +
    "and n is null " +
    "return distinct p " +
    "order by skip {from} limit {total}" )
    Iterable<Group> rootGroupsByQuery(
    @Param( "query" ) String query,
    @Param( "from" ) int from,
    @Param( "total" ) int total );

    When the query produces results, I get a parameter not found exception asking for "from".
    Debugging as far as I can I have arrived at SlicePipe where I can see that it has the params "from", "to", "query" but it tries to convert the parameter "from" to int in an "universe" where only the results from the query exist ("p").
    My version is 1.6.M02.
    Is this a problem of the skip and limit parameterized in this version? Which is the right way of passing these kind of parameters?
    Many thanks in advance!!

  • #2
    Yes there was a problem back then, which was fixed later, I don't recall the exact version. But you could try to upgrade to 1.6.2

    to see if it is working there (or to SDN 2.1.0.RC1 and Neo4j 1.7)