Mongodb storing file into .txt

Working with Data Drivers
,
1

I have loaded a json file in mongo then i have performed some operation on that data and i have to save the query result into a textfile but when i am runing that query in mongo shell it is working fine and showing me data as per the condition but when i come out of mongo shell and try to store my query data into txt file it is showing syntax error. I am using eco

2

What error are you getting and how are you trying to extract the data? Redirect console output from a shell or using mongoexpprt or something else?

3

Redirecting consol output from shell .

4

And whats the error? Whats the command you are running?

5

(echo “use survey”; echo “db.details.find({age:{$gt:60}})”) | mongo > medical.txt

6

In medical.txt file its showing syntax error

7

Can you paste the error exactly you’re getting?

Try doing:

JSON.stringify(db.getSiblingDB('survey').getCollection('details').find({age:{$gt:60}}).toArray())

Or something similar.

8

16888504222266399485284943071269
168885042222663994852849430712691920×886 321 KB

Attaching image of the error accuring. Please let me know if you find the image

9

16888510178875519185119606761873
168885101788755191851196067618731920×886 257 KB

This is the command i am using

10

I could not get that working like that either on a command line, however this does work:

mongosh --quiet --eval "db.getSiblingDB('survey').getCollection('details').find()"

I’d recommend swapping to the new mongosh as opposed to the legacy mongo shell, for a start the quiet option now works so doing this results in output that does not have extra text.

You could also use mongoexport:

With the filtering options.

11

in bash script ‘$’ has a functionality so you have to use the escape sequce before it ''

try
(echo “use survey”; echo “db.details.find({age:{$gt:60}})”) | mongo > medical.txt