Filtering results

Filter results

Select all the people/ persons

S=>(@p Person:*); RETURN p.name AS name, p.fullname AS FullName

+----------+-----------------------+
|name      | FullName              |
+----------+-----------------------+
|tom       | Tom Hanks             |
+----------+-----------------------+
|keanu     | Keanu Reeves          |
+----------+-----------------------+
|robert    | Robert Zemeckis       |
+----------+-----------------------+

S=>(@p Person:*); RETURN COUNT(*) AS People

{
   "count" : 3
}

Select movie title “The Matrix”

S=>(Movie:* {title="The Matrix"})

{
   "num_items" : 1,
   "nodes" : [
      "{\"title\":\"The Matrix\",\"released\":1997,\"label\":\"Movie\",\"name\":\"matrix\",\"_pk\":\"889565392:7007891359330926487\",\"_v\":1}
   ]
}

BangDB allows conditions to be also defined for filtering data, such that movie released > 2000

S=>(@p Person:*)-[@r ACTED_IN]->(@m Movie:* {released> 2000}); RETURN p.fullname AS FullName, r.roles AS Roles, m.title AS Title

+-------------+----------------+----------------+
| FullName    |  Roles         |   Title        |
+-------------+----------------+----------------+
| Tom Hanks   | ["Zachry"]     |   Cloud Atlas  |
+-------------+----------------+----------------+

Or in json

{
   "rows" : [
       {
         "Title" : "Cloud Atlas",
         "Roles" : "[\"Zachry\"]",
         "FullName" : "Tom Hanks"
      }
   ]
}