AvocadoDB Query Language - Jan Steemann

© 2012 triAGENS GmbH | 2012-04-04 29 FILTER: results filtering  FILTER can be used to model both an SQL ON and an SQL WHERE in one go: FOR u IN users FOR l IN locations FILTER u.active == 1 && u.a == l.b  This is equivalent to the following SQL query: SELECT * FROM users u (INNER) JOIN locations l ON u.a == l.b WHERE u.active = 1