Generate a custom query using user inputs

Question

Generate a custom query using user inputs

Let's say I am conducting a search in the database:

router.post('/searchLoads', ensureAuthenticated, async (req, res) => {
var{ agentCode, loadNumber, pickupNumber, pickupDate } = req.body});

The user does not have to complete all fields. How can I construct a query using if statements? I attempted something like this:

result = 'await Load.find({';
    if (agentCode !== undefined){
        result += "agentCode: agentCode, ";
    }
    if(loadNumber !== undefined){
        result += "loadNumber: loadNumber, ";
    }
    if(pickupNumber !== undefined){
        result += "pickupNumber: pickupNumber, ";
    }
    if(pickupDate !== undefined){
        result += "pickupDate: pickupDate, ";
    }
    result += "})";

After creating the query, I'm unsure how to execute the code. Is there a simpler way to accomplish this?

javascript express mongoose

Answer 1

Answer №1

Instead of making a string, consider creating an object instead.

If we are working with ES6 or newer, we can use agentCode in place of agentCode: agentCode when setting up fields.

var options = {
    agentCode,
    loadNumber,
    pickupNumber,
    pickupDate,
};

result = await Load.find(options);

The need for !== undefined checks is eliminated, as any undefined fields will be automatically discarded.

Answer 2

Instead of making a string, consider creating an object instead.

If we are working with ES6 or newer, we can use agentCode in place of agentCode: agentCode when setting up fields.

var options = {
    agentCode,
    loadNumber,
    pickupNumber,
    pickupDate,
};

result = await Load.find(options);

The need for !== undefined checks is eliminated, as any undefined fields will be automatically discarded.

Generate a custom query using user inputs

Answer №1

Similar questions

What is the best way to add a dynamic parameter to the URL?

Steps for sending data to a modal window

The camera steadily advances in WebVR Cardboard using three.js technology, never stopping its forward movement

Retrieving PHP form values using JQuery

JavaScript Class experiencing issues with returning NAN when using the Multiplication method

Having trouble making axios a global instance in my Vue project

Tips on positioning content beneath a fixed header or navigation bar when viewed in a web browser

Uncover the structure of a regular expression pattern to discover the quantity of tokens and the size of the anticipated matches

Slice or eliminate the PlaneGeometry using XY coordinates

What methods can be used to manage keyup events?

Automatically clear select2 inputs after form submission in Laravel using Livewire

What is the best way to asynchronously load an external javascript file in a popup.html file?

What is the best way to deploy a user interface update to a JavaScript frontend?

Converting Database Information to JSON Format for Mobile Authentication Form

Encountered a login issue when attempting to access the localStorage

Visit localhost:3000 to view the contents of localhost/myproject/index.html

In React, the entire component refreshes every time the modal is opened

Which is better for a jQuery/Ajax Login Box: JSONP or CORS?

What is the best way to reset a CSS background GIF after hovering over it?

Using a minus sign to denote negative values and leading zeroes to indicate positive values in regular expressions