Select query to get values from mongodb array

Question

0.00/5 (No votes)

See more:

Hi All,

I am in a real trouble now !

I have a Json file like below :

{ \"_id\" : ObjectId(\"59b24213d772ea41bc44e017\"), 

\"values\" :
 [
{ \"ProductName\" : \"BH0001  \"QuantityOnHand\" : 55579.0 }, 
{ \"ProductName\" : \"BH0101 \", \"QuantityOnHand\" : 15741.0 }, 
{ \"ProductName\" : \"BH0102 \", \"QuantityOnHand\" : -802.0 }
]
}

How to get the Quantities by sending productName as keyword ?

For example I need to write a query like select QuantityOnHand from this document where productName =BH001

What I have tried:

db.Mycollections.find({'values.ProductName':'BH0001')})

I used like this , but its showing all the values just like simple find query ! :(

Posted 8-Sep-17 0:55am

ali_1

Updated 11-Sep-17 2:21am

v2

Add a Solution

Comments

Richard MacCutchan 8-Sep-17 12:14pm

And what happens when you try it?

ali_1 11-Sep-17 8:23am

db.Mycollections.find({'values.ProductName':'BH0001')})

I tried this but not working Richard!
I am converting the datatable and inserting into mongodb using collection.insertone statement !.. Do i need to use insertMany instead of insertone ?

Richard MacCutchan 11-Sep-17 11:14am

Sorry, I do not understand what you are trying to say.

ali_1 12-Sep-17 7:24am

Simply tell me how to get the Quantity for BH0001

Richard MacCutchan 12-Sep-17 10:43am

How can I when I have no idea what your database table structure is?

ali_1 13-Sep-17 8:53am

Thank you Richard!.. I Fixed it

Inserted separately all these values and its working!
"You don't know How far you can go until you Try"
Thanks Bro!

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)