how to write orientdbSQL query equivalent to the cypher query bellow?
"START me=node:users_index(name={user})
MATCH
skills<-[:has]-me-[:lives_in]->city<-[:in_location]-job-[:requires]->requirements
WHERE me-[:has]->()<-[:requires]-job"
where I have the following vertices and edges:
Vertex vertex = graph.addVertex("class:Users", "name", name);
Vertex vertex = graph.addVertex("class:Skills", "name", name);
Vertex vertex = graph.addVertex("class:Jobs", "name", name);
Vertex vertex = graph.addVertex("class:Cities", "name", name);
graph.addEdge(null, user, v, "lives_in"); in city
graph.addEdge(null, user, v, "has"); has skills
graph.addEdge(null, jobs, v, "in_location"); in city
graph.addEdge(null, jobs, v, "requires"); skills
I want to know all the matches between jobs and users, that is : all
users and jobs that matches city an skill
thanks
--
---
You received this message because you are subscribed to the Google Groups
"OrientDB" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
