Fetching the values from mongodb collection using java

Question

These are 2 different collections in a database.I am not able to figure out how to dynamically fetch the values from the collections using java .

I want to fetch the values through java program but without using the hardcoded values like "VerifyEmail.LicenseKey" & "wsf:status.arg0.age" as mentioned above in the java code.Is there a way to fetch the values without hardcoding in java.

Collection 1:

{
"_id" : ObjectId("583567ac6c85e71adc1f8bae"),
"wsf:status" : {
    "arg0" : {
        "name" : "James",
        "phonenum" : NumberLong(9848222338),
        "age" : 18
        "status" : "N" 
       }
   },
 }

Query 1: Here I am using the hardcoded values to fetch the desired result from the collection 1.

db.xmlcoll1.find({"wsf:status.arg0.age":18})

Collection 2:

{
"_id" : ObjectId("582446686c85e73a70696666"),

"VerifyEmail" : {
    "xmlns" : "http://ws.cdyne.com/",
    "email" : "[email protected]",
    "LicenseKey" : 123
} }

Query 2:

Here I am using the hardcoded value of the element "VerifyEmail" to fetch the values.

db.xmlcoll.find({"VerifyEmail.LicenseKey":123});

marc_s · Accepted Answer · 2016-11-28 17:08:56Z

1

You can try to use Morphia if performance is not critical for you. And use such constructions for queries:

underpaid = datastore.createQuery(Employee.class)
                 .field("age").lessThanOrEq(18)
                 .asList();

edited Nov 28, 2016 at 17:08

marc_s

760k186 gold badges1.4k silver badges1.5k bronze badges

answered Nov 24, 2016 at 4:50

RocketRaccoon

2,6091 gold badge23 silver badges30 bronze badges

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

4 Comments

RocketRaccoon Over a year ago

How would look your expected query?

prasanth vaidya Over a year ago

BasicDBObject query = new BasicDBObject(); query.put("wsf:status.arg0.status", "N"); DBObject result = collection.findOne(query); this is the query.But I am not able to figure out how to fetch "wsf:status.arg0" from the collection without making it static.

RocketRaccoon Over a year ago

so... you want quirey document, get it's structure and use it without declaring manually in code for following quireies, am I right?

prasanth vaidya Over a year ago

Yeah is that possible ?

Collectives™ on Stack Overflow

Fetching the values from mongodb collection using java

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related