How to make an array of all the values inside a collection with mongodb (node.js)

Question

I keep getting promise pending.

var MongoClient = require('mongodb').MongoClient;
var url = "mongodb://localhost:27017/";

MongoClient.connect(url, { useNewUrlParser: true } , function(err, db) {
    if (err) throw err;

    var dbo = db.db("mydb");
    var gr = dbo.collection("collectionname").distinct("name");

    // var everyrecord = dbo.collection("collectionname").find({}).toArray();

    console.log(gr);

    db.close();
});

xsh.7 · Accepted Answer · 2018-10-06 09:03:28Z

1

If you make the function async, you can just await the result:

MongoClient.connect(url, { useNewUrlParser: true } , async function(err, db) {
    // ...

    var gr = await dbo.collection("collectionname").distinct("name");
    console.log(gr);

    // ...
});

answered Oct 6, 2018 at 9:03

xsh.7

6,2701 gold badge25 silver badges26 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

xsh.7 Over a year ago

@f.pythonlover Any reason the other (non working) answer is marked as solution?

LogaKrishnan · Accepted Answer · 2018-10-06 08:44:21Z

0

var MongoClient = require('mongodb').MongoClient;
var url = "mongodb://localhost:27017/";

MongoClient.connect(url, { useNewUrlParser: true } , function(err, db) {

if (err) throw err;

var dbo = db.db("mydb");

 var gr = dbo.collection("collectionname").distinct("name");
 gr = gr.toArray();

// var everyrecord = dbo.collection("collectionname").find({}).toArray();

  console.log(gr);

  db.close();
});

answered Oct 6, 2018 at 8:44

LogaKrishnan

5012 gold badges9 silver badges25 bronze badges

1 Comment

xsh.7 Over a year ago

There is no toArray method on Promises. Check out stackoverflow.com/questions/20858299/…

Usira · Accepted Answer · 2018-10-06 08:52:19Z

0

You can achive this by using .toArray(),

    var MongoClient = require('mongodb').MongoClient;
    var url = "mongodb://localhost:27017/mydb";

    MongoClient.connect(url, { useNewUrlParser: true } , function(err, db) {

      if (err) throw err;

      db.collection("collectionname").distinct("name").toArray(function (error, response) {
         console.log(error);
         console.log(response);
      });
    });

edited Oct 6, 2018 at 8:52

answered Oct 6, 2018 at 8:26

Usira

1481 silver badge12 bronze badges

3 Comments

f.pythonlover Over a year ago

MongoClient.connect(url, { useNewUrlParser: true } , function(err, db) { if (err) throw err; var dbo = db.db("mydb"); dbo.collection("collectionname").distinct("name").toArray(function (error, response) { console.log(error); console.log(response); }); }); this didn t work? what am i missing?

f.pythonlover Over a year ago

it says that toarray is not a function

xsh.7 Over a year ago

You're not missing anything. There is no toArray method for promises. Have a look at my async/await suggestion - assuming your node version supports it.

Collectives™ on Stack Overflow

How to make an array of all the values inside a collection with mongodb (node.js)

3 Answers 3

1 Comment

1 Comment

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

1 Comment

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related