Imporing data manually with GUI MongoDB causes ReferenceError: collection is not defined?

Question

I'm getting this error on an existing collection when I tried to aggregate to join two collections

show dbs

Bankerise 172 kB admin 102 kB config 73.7 kB local 73.7 kB

use Bankerise

switched to db Bankerise

show collections

usedData UserApp


db.usedData.aggregate( [    { 
     $lookup : {
                 from: UserApp,
                localField:"id",
                   foreignField: "id", as:"same_id"       
                }   
     }])

ReferenceError: UserApp is not defined

And I thing it raises from the fact that I have imported the data Manually using GUI.

I'm missing something here ?

@prasad_ No it is not a syntax error because I tried to create the collection with the command db.createCollection(" coll ") and inserted data with db.coll.insertMany() with the same syntax it works . — sabri mahmoud, Mar 23 '22 at 16:35
@prasad_ the problem occurs only when importing the data manually — sabri mahmoud, Mar 23 '22 at 16:36
I'm sorry you are right about it it was missing " " for UserApp — sabri mahmoud, Mar 23 '22 at 16:50

score 0 · Accepted Answer · answered Mar 23 '22 at 16:52

0

As Mr prasad_ wrote in comments it is a syntax error it was missing " " on UserApp

answered Mar 23 '22 at 16:52

sabri mahmoud

55
9

Imporing data manually with GUI MongoDB causes ReferenceError: collection is not defined?

1 Answers1