12

I want to query my TITAN 0.4 graph, based on two filter conditions with "OR" logical operator (return vertices if either of conditions is true).

I searched this on http://sql2gremlin.com/, but only "AND" operator is given,

My requirement is something as given below:

SELECT *
  FROM Products
 WHERE Discontinued = 1
   OR UnitsInStock = 0

g.V('type','product').has('discontinued', true) "OR"
                     .has('unitsInStock', 0)

Please help

cybersam
  • 63,203
  • 6
  • 53
  • 76
Remis Haroon - رامز
  • 3,304
  • 4
  • 34
  • 62

1 Answers1

25

You could do:

g.V('type','product').or(_().has('discontinued', true), _().has('unitsInStock', 0))

See the or step in GremlinDocs.

thomaux
  • 19,133
  • 10
  • 76
  • 103
stephen mallette
  • 45,298
  • 5
  • 67
  • 135