Gremlin filter one query's output based on another query

Question

I have two gremlin queries. I want to filter out the output of one query based on the results of another query.

For example,

query 1: g.V().hasLabel('Person').values('name') gives the following output - John, Sam, Rocky

query 2: g.V().hasLabel('Friend').values('name') gives the following output - John

So, the final expected output I want is John

I have tried the following:

g.V().hasLabel('Person').where('names', g.V().hasLabel('Friend').values('name'))

But it doesn't seem to be working. Can anyone please help me here?

Kelvin Lawrence · Accepted Answer · 2023-01-08 23:03:36Z

0

I'm curious why you are not using edges to determine a friend type relationship, but one way to re-write this is to just to reverse the parts.

g.V().hasLabel('Friend').values('name')).fold().as('friends').
  V().hasLabel('Person').
      where(within('friends')).by('name').by()

answered Jan 8, 2023 at 21:34

Kelvin Lawrence

14.4k2 gold badges21 silver badges41 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1