How to find all nodes which linked by edge with exact property in OrientDB?

by

I have several services and would like to see how they linked via requests

So I created edges as class “Http” and added property “request”

All services

I have 4 services

  1. Gateway
  2. ServiceA
  3. ServiceB
  4. ServiceC

I would like to display all services which linked by edge with property equal “get_user_info”

Gateway -> ServiceA -> ServiceC -> ServiceB

What I would like to see

And property equal “delete_user”

Gateway -> ServiceB

What I would like to see

It can be like that “SELECT * FROM Services WHERE edge.request=”get_user_info””

I tried

SELECT * 
FROM Services 
WHERE in('http').request="get_user_info" OR out('http').request="get_user_info"

SELECT expand(in('http')[request="get_user_info"]) FROM Services;

But it does not work

I tried

select * from `Services` WHERE @rid IN (select in from `http` where request="get_user_info") OR @rid IN (select out from `http` where request="get_user_info")

and it works, but I see Link from ServiceB to Gateway
Can I filter that link?

Leave a Comment