Is it possible to use the parser api directly on any nodes that were returned? i.e., can I do something like this:
Cypher("MATCH (u: User) RETURN u").single(str("u.id"))
The query above results in an exception: "u.id not found, available columns : u"
I tried using "RETURN u.*" but received a cypher syntax exception "Invalid input '*' "
I'm really struggling to get data out of my cypher query - I'm collecting paths .
Here is the query match p=(n:node)-[r:PERMISSION]->(t:node), (o:node{id:$id})-[:PARENT*0..]-(t) return COLLECT(p)
. This returns [[{id: 3}, {}, {id: 1}], [{id:6}, {}, {id: 2}]]
- I got a seq of cypher results row, but I cannot for the life of me get the data out because it keeps failing the typecheck.
Error:(24, 33) could not find implicit value for parameter c: org.anormcypher.Column[_]
List[List[_]]
CypherResultRow('COLLECT(p)':List(List(Map(id -> 3), Map(), Map(id -> 1)), List(Map(id -> 6), Map(), Map(id -> 2))) as String)
Hi everyone, I want to know how to write a parser for data which has type of Map[string,Map[string,string]] like below:
val parser: Map[string,Map[string,string]] =...
val result: List[Map[string,Map[string,string]] ] = SQL"SELECT * FROM table".as(parser.*)
//for three item has relation like: ( item1 -> (item2 -> item3))
thanks.