Querying arrays and sub documents

[David_44057 (David Thompson)]

I am really frustrated. First in an introductory course… Why would you make a lab that

1. Is written wrong. There is no West of -74 latitude…Latitude runs north and south.

2. There is no explanation on how to query a negative number… So… Entering this querry string in atlas returns 0. I used atlas so I could perfect the query, then I was going to use the terminal so I could use the .count() function.

<deleted, reason: potential answer>

This returns 0… But if you remove the - sign, it returns a value.

Tried to google mongo documentation on how to querry a negative number… Cannot find anything on it. Below is the lab write up.

Also in the atlas, the fields are 0 and 1… WHY would you name a field 0 and 1 in a .json based document??? It just makes it more confusing. Wouldn’t it be better to properly label your fields?

Please give feedback on this so I can complete the lab.

[Kushagra_Kesav]

Hi @David_44057,

Apologize for the inconvenience caused to you while learning MongoDB. We are constantly working towards improving the course content and making the learner’s experience more interactive.

Now

@David_44057

I am really frustrated. First in an introductory course… Why would you make a lab that

1. Is written wrong. There is no West of -74 latitude…Latitude runs north and south.

We have already fixed this issue a couple of weeks ago, so in upcoming offerings, changes will surely reflect. Moreover thanks for highlighting. We appreciate your efforts.

@David_44057

2. There is no explanation on how to query a negative number… So… Entering this query string in the atlas returns 0. I used atlas so I could perfect the query, then I was going to use the terminal so I could use the .count() function.

{“starting station location.coordinates.1”: {"$lte": -74}}

Here, we consider these as integers (either negative or positive) and you can surely write a query as normal using -1.

Here you have entered 1 after coordinates, I think that is creating issues for you.

But moreover here you have to answer the numbers of results you are getting. [As per question]

If you still have any further questions regarding this, feel free to mention them down here.

Thanks, Kushagra

[David_44057 (David Thompson)]

Thanks for listening… I got it with the following query.

db.trips.find({“start station location.coordinates.0”: {"$lte": -74 }}).count()

I am finding that I need to watch my field labels, as well as my spelling. Thank you for your patience.