How to run a javascript file inside a mongo shell after connection

Question

I have a javascript file and want to run them inside a mongo shell. I know how to load the javascript file during connection from this link: How to execute mongo commands through shell scripts?. But my case is how to run an external js file after the connection already established.

My js file looks like below:

db.getSiblingDB("test")
  .enron_messages.find({
    $or: [{ filename: "111." }, { "headers.From": "test@gmail.com" }]
  })
  .sort({ "headers.To": 1 })
  .limit(10);

and in my mongo shell, I use load('test.js') to load that file but it returns true(see below output). How to execute this file?

> load('test.js')
true

Answer 1

The load() function does in fact execute the javascript file. The problem you are facing is that when the external scripts are executed in "scripted" mode, find() will only return the cursor and not iterate it as the mongo shell does when run in Interactive mode.

This behavior is detailed in the docs in Write Scripts for the Mongo shell. There you will see an example of how you need to iterate the cursor and print the results:

cursor = db.collection.find();
while ( cursor.hasNext() ) {
    printjson( cursor.next() );
}