Community

Don't GET req.query.name to collection.find in express and MongoDB

Moved General Discussion
  • andrew xoaA

    I take this opportunity to greet everyone I wanted to expose you a problem:
    I can say that I have tried them all, I am about to give up! I also tried with an if else, I tried to change the field, but nothing, it does not take the damn

    let query = req.query.name;

    from:

    http://localhost:3000/search?name=5044

    the funny thing is that it works perfectly well in this way:

    router.get('/search', async (req, res)=> {

if (!req.query.name)
return res.render("search", {
  title: "NodeMongo Search",
  userlist:[],
});

else {
  const url = 'localhost:27017/local'; // Connection URL
  const db = require('monk')(url);
  const collection = db.get('startup_log')
  try{
    
let query = 5044; //assigning the pid directly to the variable query
const userlist = await collection.find({pid:query});
res.render("search",{userlist});
  }catch(e){
  console.log(e);
}}
});

    so assigning 5044 to the query variable run perfectly, but:

    router.get('/search', async (req, res)=> {

if (!req.query.name)
return res.render("search", {
  title: "NodeMongo Search",
  userlist:[],
});

else {
  const url = 'localhost:27017/local'; // Connection URL
  const db = require('monk')(url);
  const collection = db.get('startup_log')
  try{
    
let query = req.query.name;
const userlist = await collection.find({pid:query});
res.render("search",{userlist});
  }catch(e){
  console.log(e);
}}
});

    assigning the query req.query.name he doesn't want to know.

    this below is the search.ejs page:

    <!DOCTYPE html>
<html>
  <head>
    <title>User List</title>
    <link rel='stylesheet' href='/stylesheets/style.css' />
  </head>
  <body>
    <h1>MongoSearch</h1>

    <form action="" method="GET" encType="multipart/form-data">
      <label htmlFor="newNote">New Note:</label>
        <input type="text" name="name"  className="form-control" rows="5" id="name" placeholder="text here"></input>
        <button id="done" type="submit" className="btn btn-primary pull-right">Done</button>
        <button id="cancel" className="btn btn-warning pull-right">Cancel</button>
    </form>


   
    <ul>
      <% for (var i = 0; i < userlist.length; i++) {%>
     
          <li><%= userlist[i].pid %></li>
         
          <li></li>

        
        <%}%>
    </ul>
  </body>
</html>

    advice on how much it would be appreciated ... thanks in advance

    0
  • PitaJP

    Hi, while you're welcome to post here, this is not a general forum for Node. It's the community forum for NodeBB, a Node.js based forum software.

    You'll probably have better luck with your question on StackOverflow or Reddit.

    0

Suggested Topics

  • metaverseM

    What's this plugin name?

    General Discussion
    0 Votes
    5 Posts
    99 Views
    metaverseM

    @phenomlab thank you!

  • S

    How to use different collection in different page in nodeJS

    General Discussion
    0 Votes
    1 Posts
    291 Views
    S

    Hi,

    Brief details of what is required:

    I have index.html page and index.js file under router. I am showing data from one collection say 'x' on page index.html. All the code related to router.get/post is done in index.js file.

    There is a button 'SubText' on index.html, m applying aggregation for search and storing output in new collection. Till here, everything is working fine.

    Now my requirement is when user clicks on 'SubText' button, after new collection, it should take it to different html page and show data from newly created collection.

    Please can anybody suggest/guide how to do this?

    Please find below the coder:

    Index.js

    var createGroups = function (db, callback) { var pipeline = [ { $match: { $text: { $search: "Error" } } }, {

    $project: { _id: 0, procPath: 1, bkgroundInfo: 1, "result": { $cond: { if: { $gte: [{ $indexOfCP: ["$bkgroundInfo", "Error"] }, 0] }, then: { $substrCP: ["$bkgroundInfo", { $indexOfCP: ["$bkgroundInfo", "Error"] }, 140] }, else: "Not Found" } } } }, { "$out": "SKSNodeColl" }

    ]
    db.aggregate(pipeline).toArray(function (err, result) {
    //assert.equal(err, null);
    console.log(result);
    callback(result);
    });
    };

    router.get('/newColl', function (req, res, next) { MongoClient.connect(url, { useNewUrlParser: true }, function (err, client) { if (err) { console.log(err); throw err; } var db = client.db("mydb"); var collection = db.collection("Users"); console.log("Mongo Connection - New Collection"); createGroups(collection, function (err, result) { console.log("newCollection Created"); var userdetails = path.join(__dirname, "/../views/userdetails.html"); console.log(userdetails); client.close();
    res.sendFile(userdetails);
    }); });
    });

    =====================
    Index.html

    <a href="/newColl"><input type="button" id="resultMatch" value="PatternMatchingResult" tabindex="1"></a>

    userdetails.html //page where I want to show data from new collection.(included ptrnSearch.js in this file in head section: )

    <form id="form1" name="form1" method="post" action="/fetch">
    <input type="hidden" name="id" value="" id="id" />
    <table border="1">
    <tbody>
    <tr>
    <th> ID </th>
    <th> Procedure Path </th>
    <th> Background Description </th>
    <th> Error Pattern </th>
    </tr>
    {% if (data.length) %}
    {% for item in data %}
    <tr>
    <td> {{item['_id']}} </td>
    <td> {{item['procPath']}} </td>
    <td> {{item['bkgroundInfo']}} </td>
    <td> {{item['result']}} </td>
    </tr>
    {% endfor %}
    {% endif %}
    </tbody>
    </table>
    </form>

    ptrnSearch.js //added to userdetails.html page

    router.get('/', function (req, res) { MongoClient.connect(url, function (err, client) { if (err) { throw err; } var db = client.db("mydb"); db.collection('SKSNodeColl').find({}).toArray(function (err, docs) { if (err) { throw err; } res.render('userdetails.html', { data: docs }); client.close(); }); }); });

    ==============================
    Many Thanks

  • W

    Animated profiles don’t work!

    General Discussion
    0 Votes
    3 Posts
    808 Views
    julianJ

    Thanks @Whimpers @AOKP -- yes it might actually be a bug, although we don't track it currently as it has not been reported on GitHub yet.

  • medwardsM

    Search - how's ElasticSearch doing?

    General Discussion
    0 Votes
    4 Posts
    1752 Views
    julianJ

    Hey @medwards -- Indeed, that's what we're hoping to do with search. Not everyone wants to use Reds, so I'm actually planning on divorcing Reds from core, and allowing third-party plugins to interface with the routes.

  • julianJ

    King has trademarked the word CANDY (and you're probably infringing)

    General Discussion
    1 Votes
    3 Posts
    990 Views
    W

    Even if you did name it, you wouldn't, sadly, be infringing on any copyright as this isn't a video game and/or article of clothing. BUT HOW DID THEY? WHY? CAPS LOCK CONFUSED MODE INITIATED!

Copyright © 2023 NodeBB | Contributors