Querying with code

Obviously, you'll want to access the data in your collections using your programming language of choice. The syntax is very similar to what you've just seen.

js

const query = { title: /godfather/i };
const options = { projection: { title: 1, runtime: 1}, sort: { year: -1 } };
const movies = collection.find(query, options).toArray();

csharp

var query = Builders<BsonDocument>.Filter.Regex("title", new BsonRegularExpression("godfather", "i"));
var options = new FindOptions<BsonDocument, BsonDocument> { Projection = "{ title: 1, runtime: 1 }", Sort = "{ year: -1 }" };
var movies = collection.Find(query, options).ToList();

java

BsonRegularExpression regex = new BsonRegularExpression("godfather", "i");
BsonDocument query = new BsonDocument("title", regex);
BsonDocument projection = new BsonDocument("title", 1).append("runtime", 1);
BsonDocument sort = new BsonDocument("year", -1);
FindOptions<BsonDocument> options = new FindOptions<BsonDocument>().projection(projection).sort(sort);
List<BsonDocument> movies = collection.find(query).into(new ArrayList<>());

py

query = { "title": re.compile("godfather", re.IGNORECASE) }
options = { "projection": { "title": 1, "runtime": 1}, "sort": { "year": -1 } }
movies = list(collection.find(query, options))

php

$query = [ "title" => new MongoDB\BSON\Regex("godfather", "i") ];
$options = [ "projection" => [ "title" => 1, "runtime" => 1], "sort" => [ "year" => -1 ] ];
$movies = $collection->find($query, $options)->toArray();

ruby

query = { "title" => /godfather/i }
options = { "projection" => { "title" => 1, "runtime" => 1}, "sort" => { "year" => -1 } }
movies = collection.find(query, options).to_a