RethinkDB notes (Data Explorer)

notes.js

// filter entries with empty 'field1' 
r.db('db_name')
  .table('test')
  .filter(function(search){ return search.hasFields('field1').not() })
  .count();
  
// return only rows that have 'field1' presesent
r.db('db_name')
  .table('test')
  .hasFields('field1')
  .count();

// join two tables (test1 + test2) based on field equality (field1 is present on both tables)
r.db('db_name')
  .table('test1')
  .eqJoin('field1', r.db('db_name').table('test2'), {index: 'field1'})
  .zip()
  .pluck('field1', 'other_interesting_fields')