Retrieve Distinct Values

1
import { MongoClient } from "mongodb";
2
3
// Replace the uri string with your MongoDB deployment's connection string.
4
const uri = "<connection string uri>";
5
6
const client = new MongoClient(uri);
7
8
async function run() {
9
  try {
10
    
11
    // Get the database and collection on which to run the operation
12
    const database = client.db("sample_mflix");
13
    const movies = database.collection("movies");
14
15
    // Specify the document field to find distinct values for
16
    const fieldName = "year";
17
18
    // Specify an optional query document to narrow results
19
    const query = { directors: "Barbra Streisand" };
20
21
    // Execute the distinct operation
22
    const distinctValues = await movies.distinct(fieldName, query);
23
24
    // Print the result
25
    console.log(distinctValues);
26
  } finally {
27
    await client.close();
28
  }
29
}
30
run().catch(console.dir);

1
import { MongoClient } from "mongodb";
2
3
// Replace the uri string with your MongoDB deployment's connection string.
4
const uri = "<connection string uri>";
5
6
const client = new MongoClient(uri);
7
8
interface Movie {
9
  directors: string;
10
  year: number;
11
}
12
13
async function run() {
14
  try {
15
    // define a database and collection on which to run the method
16
    const database = client.db("sample_mflix");
17
    const movies = database.collection<Movie>("movies");
18
19
    const distinctValues = await movies.distinct("year", {
20
      directors: "Barbra Streisand",
21
    });
22
23
    console.log(distinctValues);
24
  } finally {
25
    await client.close();
26
  }
27
}
28
run().catch(console.dir);