Unable to apply skip, limit and order clauses in Neo4j using rest cypher -
i using neo4j 2.1.5 using dependency neo4j-rest-graphdb:2.0.1
in grails , query db using
restapi restapi = new restapifacade("http://localhost:7474/db/data") restcypherqueryengine rcqer=new restcypherqueryengine(restapi)
i created parameter list
map<string, string> paramval = new hashmap<>(); paramval.put('limit', 10); paramval.put('skip', 0); paramval.put('order', 'name');
my query looks this
string query = "match (c:mylabel) return id(c) id, c.name name skip ${param}.skip limit ${param}.limit;
execute query this
result = rcqer.query(query,org.neo4j.helpers.collection.maputil.map("param",paramval))"
this shows error invalid input '.': expected whitespace, limit, load csv,.....
works perfect when parameters used in where
clause. result not in order while using order by
clause, , works without error.
please let me know missing or if there limitation there. in advance.
i don't use particular part of library expect not need reference param
directly {}
syntax (no dollar), make query:
string query = "match (c:mylabel) return id(c) id, c.name name skip {skip} limit {limit}
Comments
Post a Comment