how to fetch both isActive true and false

Question

Whats wrong with my code? I want to get both isActive:true and isActive: false in just 1 api

This is my controller course.js

const Course = require ("../models/Course")

    module.exports.getAllCourses = () => {
        return Course.find({isActive: true, :false}).then(resultsFromFindActive => resultsFromFindActive)
    }

This is my routes course.js

const express = require("express")
const router = express.Router()
const auth = require("../auth")
const CourseController = require("../controllers/course")

    router.get('/active', (req, res) => {
        CourseController.getAllCourses().then(resultsFromFindActive => res.send(resultsFromFindActive))
    })

Are you by any chance trying to get all courses where isActive is not null? — Ian, Dec 30 '20 at 14:10
Even i changed it to !null.. the data that being fetch are all that isActive:true — FoxcyLoxcy, Dec 30 '20 at 14:20
I guess you are using mongoose (mongoDB) and **Course** is a schema. If so, you can change the find method as `.find({})`. — Engincan Veske, Dec 30 '20 at 14:20
@FoxcyLoxcy Are you sure you have some records with `isActive: false`? :) — Sebastian Kaczmarek, Dec 30 '20 at 14:21
So why filter on isActive? Remove it to find all the records. — epascarello, Dec 30 '20 at 14:25

score 1 · Accepted Answer · answered Dec 30 '20 at 14:36

1

{isActive: true, :false} is not a valid JavaScript syntax

Use $or operator

Course.find({ $or: [{ isActive: true }, { isActive: false }] })

Or $exists operator

Course.find({ isActive: { $exists: true } })

answered Dec 30 '20 at 14:36

laruiss

3,780
1
18
29

score 0 · Answer 2 · answered Dec 30 '20 at 14:40

0

You can follow the answer here: How do you query for "is not null" in Mongo?

Course.find({ isActive: { $ne: null } })

In this case you'll query for non-null values in isActive

answered Dec 30 '20 at 14:40

lucaskds

1

how to fetch both isActive true and false

2 Answers2