Collection.or()

Syntax

collection.or(indexOrPrimaryKey)

Parameters

indexOrPrimaryKey: String	Name of an index or primary key registered in Version.stores()

Return Value

WhereClause

Sample

db.friends.where("name")
  .equalsIgnoreCase("david")
  .or("shoeSize")
  .above(40)
  .sortBy("shoeSize")

Limitations

The sort order of the resulting collection will be undefined since the collection works on multiple indexes. To canonicalize the sort order, use the Collection.sortBy() method.

Implementation Details

This is implemented using parallel query execution and duplicate removals. For details, read this article