mongodb - mongo $ne query with an array not working as expected -


i'm trying run following queries data inserted follows. whatever reason $ne 0 in value doesn't seem work. tried on both linux , mac using v2.0.4. ran these using mongo shell.

anybody have ideas? bug or i'm misunderstanding?

db.associated.insert({     "diskinfo" : {             "physical" : [                     {"merror_count" : "count: 0"},                     {"merror_count" : "count: 0"},                     {"merror_count" : "count: 0"},                     {"merror_count" : "count: 509"}             ]     }})  db.associated.insert({     "diskinfo" : {             "physical" : [                     {"merror_count" : "count: 0"},                     {"merror_count" : "count: 5"},                     {"merror_count" : "count: 0"}             ]     }})  db.associated.insert({     "diskinfo" : {             "physical" : [                     {"merror_count" : "count: 0"},                     {"merror_count" : "count: 0"},                     {"merror_count" : "count: 0"}             ]     }})

ran these queries on mongo shell. , got results in comments

 db.associated.find( { "diskinfo.physical.merror_count" : { $ne : 'count: 0'}}).count() //  result: 0, expected: 2 db.associated.find( { "diskinfo.physical.merror_count" : { $ne : 'count: 509'}}).count() // result: 2, expected: 2 db.associated.find( { "diskinfo.physical.merror_count" : { $ne : 'count: 5'}}).count() // result: 2, expected: 2

these results correct.

your expectation may based on number of elements in embedded array match predicate. however, it's number of documents satisfy query getting back.

in first case query documents don't have diskinfo.physical.merror_count equal 'count: 0'. every document has diskinfo.physical.merror_count that's 'count: 0' 0.

look @ way, every document in collection has diskinfo.physical.merror_count value that's other 'count: 0'. if queried equality instead of inequality three.

are trying find documents have only entries 'count: 0'?

there doesn't seem straight forward way this, 1 query be:

db.associated.find( { "diskinfo.physical.merror_count" : { $gt : 'count: 0'}}).count()

at least solution if counts integers - happens work strings because "1">"0", etc.


Comments

Post a Comment

Popular posts from this blog

jquery - Invalid Assignment Left-Hand Side -

i trying assign class tag via jquery, resulting in error through firebug says "invalid assignment left-hand side" on fourth line below. <cfoutput> $('.pngfix a').each(function(index) { var hreflink = $(this).attr("href"); if (hreflink.tolowercase() = '../audio.cfm') { $(this).addclass('audioimg'); } }); </cfoutput> looking around online, looks syntax problem, don't seem see it... any tips? thanks if (hreflink.tolowercase() = '../audio.cfm') that attempts assign value, rather check equality. change = operator == .
Read more

java - Play! framework 2.0: How to display multiple image? -

i need display gallery of photos. here template: @(photos: list[photo]) @title = { <bold>gallery</bold> } @main(title,"photo"){ <ul class="thumbnails"> @for(photo <- photos) { <li class="span3"> <a href="#" class="thumbnail"> <img src="@photo.path" alt=""> </a> </li> } </ul> } and here controller method: public static result getphotos() { return ok(views.html.photo.gallery.render(photo.get())); } and here photo bean : @entity public class photo extends model { @id public long id; @required public string label; public string path; public photo(string path, string label) { this.path = path; this.label = label; } private static finder<long, photo> find = new finder<long, photo>( long.class, photo.class); public static list<phot...
Read more

gmail - Is there any documentation for read-only access to the Google Contacts API? -

i want read-only access user's google contacts. there stackoverflow member wanted this, , received following answer : yes, there is, use https://www.googleapis.com/auth/contacts.readonly scope , "view contacts". this exchange reference read-only access google contacts can find using google. simply using access token obtained attempt read usual google contacts api (i.e. https://www.google.com/m8/feeds ) fails insufficient permissions. similarly, using google contacts api on new target fails 404 errors (for example https://www.googleapis.com/auth/contacts.readonly/default/full ). is there documentation anywhere on how use api, or permissible way access google contacts api full read-write access?
Read more