I’m trying to filter a collection in mongo and then copy the result to a new collection. Working in the navigator UI’s mongo shell I tried:
db.test2.aggregate( [ { $match: {'Property Type': {pattern: 'Land',options: ''}} }, { $out: "test3" } ])
test2 is the source, I have created test3 in the ‘local’ db, as well
What am I doing wrong?