Explore various queries and paths within MongoDB Atlas Search

Question

Explore various queries and paths within MongoDB Atlas Search

I am currently working on developing an API that can return search results based on multiple parameters. So far, I have been able to successfully query one parameter.

For example, here is a sample URL:

http://localhost:3000/api/search?term=javascript&impact=sdg1

My goal is to get search results that meet both the conditions of term=javascript AND impact=sdg1

import Cors from "cors";
import initMiddleware from "../../util/init-middleware";
import { connectToDatabase } from "../../util/mongodb";

const cors = initMiddleware(
  Cors({
    methods: ["GET", "POST", "OPTIONS"],
  })
);

export default async function handler(req, res) {
  await cors(req, res);

  const { db } = await connectToDatabase();

 const data = await db
    .collection("jobs")
    .aggregate([
      {
        $search: {
          search: [
            {
              query: req.query.term,
              path: ["title", "role"],
            },
            {
              query: req.query.impact,
              path: ["impact"],
            },
          ],
        },
      },
    ])
    .sort({ date: -1 })
    .toArray();


  res.json(data);
}

I would like to know if it's feasible to achieve this and if anyone could recommend the appropriate type of query to use?

Thank you in advance

javascript mongodb next.js mongodb-atlas mongodb-atlas-search

Answer 1

Answer №1

To achieve this, utilize the compound operator. Check out the documentation for more information and here is an example implementation in your code:

export default async function handler(req, res) {
  await cors(req, res);

  const { db } = await connectToDatabase();

 const data = await db
    .collection("jobs")
    .aggregate([
      {
        $search: {
          "compound": {
              "must": [{
                  "text": {
                      "query": req.query.term,
                      "path": ["title"", "role"],
                    }
                  }],
               "filter:"[{
                    "text": {
                      "query": req.query.&impact&,
                      "path": ["impact"],
                    }
                }]
           }
        },
      },
    ])
    .sort({ date: -1 })
    .toArray();


  res.json(data);
}

Answer 2

To achieve this, utilize the compound operator. Check out the documentation for more information and here is an example implementation in your code:

export default async function handler(req, res) {
  await cors(req, res);

  const { db } = await connectToDatabase();

 const data = await db
    .collection("jobs")
    .aggregate([
      {
        $search: {
          "compound": {
              "must": [{
                  "text": {
                      "query": req.query.term,
                      "path": ["title"", "role"],
                    }
                  }],
               "filter:"[{
                    "text": {
                      "query": req.query.&impact&,
                      "path": ["impact"],
                    }
                }]
           }
        },
      },
    ])
    .sort({ date: -1 })
    .toArray();


  res.json(data);
}

Explore various queries and paths within MongoDB Atlas Search

Answer №1

Similar questions

Showing the date in AngularJSAngularJS can be used to

capturing the HTML title and storing it in a JavaScript variable

Limiting the usage of a command in Discord.js to one user at a time, rather than all users

Unable to upload photo using Ajax request

Unable to assign a boolean value to a data attribute using jQuery

Automated tool for generating random JSON objects

The regex string parameter in node.js is not functioning properly for matching groups

What is the order of reflection in dynamic classes - are they added to the beginning or

A guide on verifying a username and password via URL using JavaScript

When a row is clicked, retrieve the data specific to that row

Tips on retrieving an input value from a dynamic list

react-vimeo not firing onPause and onPlay events

Utilizing unique layouts for specific views in sails.js and angular.js

The Angular 1.x Ajax request is not triggering the expected update in the view

The JSON response is being overridden by a catch-all URL and ends up being displayed as a 404 error page

Renew Firebase Token

Experiencing the AngularJS [$injector:modulerr] error message despite having flawless code

Initiating an AJAX request to communicate with a Node.js server

Using React to fetch data and then mapping it inside a function

Using JavaScript to retrieve the updated timestamp of a file