Mongodb with queries in JSON format

Question

I was trying to solve a query given in an assessment to fetch details from a collection. The assessment was in online editor so I had to follow the base query structure. MONGODB version 4.4

The base query was looking like below.

{
find : "MY_COLLECTION_1"
}

The collection name is "MY_COLLECTION_1", and there is field "FirstName" column in the collections like below.

{

{

"FirstName": "ABC"
}
{

"FirstName": "XYZ"
}
}

I have never seen the below format to fetch the data. Need help with this.

{
find : "MY_COLLECTION_1"
}

I tried to fetch something like below.

{
"find" : "MY_COLLECTION_1",
"FirstName" : "ABC"
}

but it's saying invalid BSON format

Joe · Accepted Answer · 2022-12-19 05:38:13Z

1

The "online editor" appears to be using the find database command, which has the basic structure:

{
      find: <string>,
      filter: <document>,
      sort: <document>,
      projection: <document>,
      hint: <document or string>
}

You will likely need to use the filter field to pass in a query.

answered Dec 19, 2022 at 5:38

Joe

29k4 gold badges25 silver badges50 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Mongodb with queries in JSON format

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related