Using an outer Boolean variable inside a mongodb aggregation pipe line logical operator $or

Question

I have to check a Boolean flag and base on its condition return different data result. for example I have a collection of books and their prices, normal result of query is prices matching 10, BUT IF showAll flag is true, it needs to return all the records.

let showAll=true;

result= await db.aggregate([{$match:{$or:[showAll,{$eq:{"price":10}}]}}])

the problem is, mongo doesn't accept none object variable inside its logical operators!

I ended up with this error:

$or/$and/$nor entries need to be full objects.

based on the description and of $or operator from mongodb aggregation it seems to be ok.

https://www.mongodb.com/docs/manual/reference/operator/aggregation/or/

I can fix the problem with using an if clause to check the variable and perform a different query, but it looks jerky and disappointing to repeat a same thing again!

You need $expr. db.aggregate([{ $match:{ $expr: { $or: [showAll,{$eq:{"price":10}}] } } }]) — Yong Shun
– Yong Shun, Commented Jul 8, 2024 at 6:50
This question is similar to: MongoDB aggregation - Match input parameter if provided else do not match. If you believe it’s different, please edit the question, make it clear how it’s different and/or how the answers on that question are not helpful for your problem. — ray
– ray, Commented Jul 9, 2024 at 11:55

BadPiggie · Accepted Answer · 2024-07-08 07:32:10Z

1

Why not execute a query based on the conditions like,

let showAll = true;

result = showAll ?
    await db.aggregate([]): // no stage will return all
    await db.aggregate([{$match:{ price: 10 }}]);

answered Jul 8, 2024 at 7:32

BadPiggie

6,4391 gold badge17 silver badges37 bronze badges

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

Comments

jQueeny · Accepted Answer · 2024-07-08 16:24:50Z

0

You should use your programming language to handle this kind of thing with a query builder approach, pushing each pipeline stage into a variable conditionally:

const pipeline = [];
const showAll = true;
const supressId = true;

if(!showAll){ //< Only if showAll == false
   pipeline.push({ $match: { price: 10 }})
}

if(supressId){ //< Some other condition etc etc
   pipeline.push({ $project: { _id: 0 } })
}

const result= await db.aggregate(pipeline);

edited Jul 8, 2024 at 16:24

answered Jul 8, 2024 at 16:17

jQueeny

8,9453 gold badges8 silver badges29 bronze badges

Collectives™ on Stack Overflow

Using an outer Boolean variable inside a mongodb aggregation pipe line logical operator $or

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related