MongoDB Shell脚本中AND/OR逻辑查询失效问题求助

Hey there! Let's figure out why your $and/$or queries work in the Mongo Shell but fail in your shell script—this is a super common gotcha, and it almost always boils down to how the shell handles special characters. Here are the key fixes:

1. Escape or Quote Shell-Special Characters #

The biggest issue is that your shell (like bash) treats the $ symbol as a variable marker. So when you write $and in your script without protection, the shell tries to replace it with the value of a variable named and (which probably doesn't exist, leaving an empty string).

Fix Options: #

• Wrap the entire query in single quotes: Single quotes prevent the shell from parsing any variables or special characters inside. This is the simplest approach:

  mongo yourDB --eval 'db.yourCollection.find({$and: [{status: "active"}, {score: {$gt: 80}}]})'
  

• Escape $ with backslashes: If you need to use double quotes (for example, to insert shell variables into the query), escape every $ with a \:

  mongo yourDB --eval "db.yourCollection.find({\"\$and\": [{status: \"active\"}, {score: {\"\$gt\": 80}}]})"
  

2. Watch Out for JSON Quoting Consistency #

MongoDB requires double quotes for JSON keys, but mixing quotes incorrectly in your script can break things. For example, if you use double quotes around the entire --eval string, you need to escape the inner double quotes (as shown above) or switch to single quotes for string values inside the JSON.

3. Handle Query Variables Properly #

If you're storing your query in a shell variable, make sure you define it with single quotes to preserve the $ symbols, then use a quote trick to pass it correctly to mongo --eval:

# Define the query with single quotes to protect $
QUERY='{"$and": [{"status": "active"}, {"score": {"$gt": 80}}]}'

# Use combined single/double quotes to inject the variable without parsing $
mongo yourDB --eval 'db.yourCollection.find('"$QUERY"')'

4. Check Tool-Specific Syntax (If Using mongoexport/mongoimport) #

If you're using tools like mongoexport instead of the interactive shell, the --query parameter also needs proper quoting. Always wrap the query in single quotes here too:

mongoexport --db yourDB --collection yourCollection --query '{"$and": [{"status": "active"}, {"score": {"$gt": 80}}]}' --out results.json

Example of a Broken vs. Fixed Script #

Broken (shell parses $ symbols):

# This will fail because $and/$gt are treated as shell variables
mongo myDB --eval "db.myCollection.find({$and: [{status: 'active'}, {score: {$gt: 80}}]})"

Fixed (single quotes protect the query):

# This works because the shell leaves $and/$gt untouched
mongo myDB --eval 'db.myCollection.find({$and: [{status: "active"}, {score: {$gt: 80}}]})'

The core idea is to shield your MongoDB query syntax from the shell's variable parsing. Once you fix the quoting/escaping, those complex $and/$or queries should behave exactly like they do in the Mongo Shell.

内容的提问来源于stack exchange，提问作者Rffonseca