can't fetch data from mongodb and display that into html

Question

model named Field.js

    const mongoose = require('mongoose');
    mongoose.connect('mongodb://localhost:27017/SuperchainV1', { 
    useNewUrlParser: true });
    mongoose.set('useNewUrlParser', true);
    mongoose.set('useFindAndModify', false);
    mongoose.set('useCreateIndex', true);
    const db = mongoose.connection;
    const FieldSchema = mongoose.Schema({

    productID: {
    type: String
    },
    productName:{
    type: String
    },
    fieldLocation: {
    type: String
    },
    farmerName: {
    type: String
    },
    farmerMobile: {
    type: String
    },
    farmerNid: {
    type: String
    },
    date: {
    type: Date,
    default: Date.now
    }
    });


    const Field = mongoose.model('Field', FieldSchema);
    module.exports = Field;

routes index.js

   router.get('/dashboard', ensureAuthenticated, (req, res) => {
   let field = Field.find({})
   .sort({date:'desc'}).exec( (err, field) => {
    res.render('dashboard', field);
        });
     })

dashboard.ejs where i want to display data after fetching

    <div class="jumbotron">
       <p class="lead">
         <% field.productID %>
         <% field.productName %>
         <% field.fieldLocation %>
         <% field.farmerName %>
         <% field.farmerNumber %>
         <% field.farmerNid %>
        </p>
    </div>

errors i get "field is not defined"

I want to fetch data from collections fields and display all the data into a ejs page named dashboard i tried this but always get the error field is not defined.

Field.find({})? why have you passed empty object to find? as it will not return anything and then you are doing sort on it. — random
– random, Commented Mar 23, 2019 at 17:10
as far i know find method will return all the occurrences from Field — Zahid Hasan
– Zahid Hasan, Commented Mar 23, 2019 at 17:16
True - docs.mongodb.com/manual/reference/method/db.collection.find — random
– random, Commented Mar 23, 2019 at 17:20
Can you show us the outcome of console.log(field); right before the res.render? — Lord Elrond
– Lord Elrond, Commented Mar 23, 2019 at 17:24

Manzurul Hoque Rumi · Accepted Answer · 2019-03-23 17:38:00Z

1

You need to use for loop in ejs template

<% for(var i=0; i < field.length; i++) { %>
   <div class="jumbotron">
       <p class="lead">
         <%= field[i].productID %>
         <%= field[i].productName %>
         <%= field[i].fieldLocation %>
         <%= field[i].farmerName %>
         <%= field[i].farmerNumber %>
         <%= field[i].farmerNid %>
        </p>
    </div>
<% } %>

answered Mar 23, 2019 at 17:38

Manzurul Hoque Rumi

3,1144 gold badges25 silver badges47 bronze badges

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

Collectives™ on Stack Overflow

can't fetch data from mongodb and display that into html

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related