ReQL command: contains

Command syntax

sequence.contains([value | predicate_function, ...]) → bool
r.contains(sequence, [value | predicate_function, ...]) → bool

Description

When called with values, returns True if a sequence contains all the specified values. When called with predicate functions, returns True if for each predicate there exists at least one element of the stream where that predicate returns True.

Values and predicates may be mixed freely in the argument list.

Example: Has Iron Man ever fought Superman?

r.table('marvel').get('ironman')['opponents'].contains('superman').run(conn)

Example: Has Iron Man ever defeated Superman in battle?

r.table('marvel').get('ironman')['battles'].contains(lambda battle:
    (battle['winner'] == 'ironman') & (battle['loser'] == 'superman')
).run(conn)

Example: Use contains with a predicate function to simulate an or. Return the Marvel superheroes who live in Detroit, Chicago or Hoboken.

r.table('marvel').filter(
    lambda hero: r.expr(['Detroit', 'Chicago', 'Hoboken']).contains(hero['city'])
).run(conn)

Related commands

• map
• concat_map
• group

Get more help

Couldn't find what you were looking for?

• Ask a question on Stack Overflow
• Chat with us and our community on Slack
• Talk to the team on IRC on #[email protected] — via Webchat
• Ping @rethinkdb on Twitter
• Post an issue on the documentation issue tracker on GitHub