Log file Viewer
#mongodb logs for Monday the 24th of December, 2012
[02:58:12] <jeremy-> Can anybody see the error in this php mongocollection query: $SearchOrParams = array( '$or' => array( array("dwf" => array( '$in' => $wla_array)), array("dwl" => array( '$in' => $wlf_array)), array("dwa" => array( '$in' => $wll_array))));
[02:58:35] <jeremy-> produces json_encode output {"$or":[{"dwf":{"$in":["bluray","store"]}},{"dwl":{"$in":["sci-fi","game"]}},{"dwa":{"$in":["3d","funny","trailer","online"]}}]}
[02:58:56] <jeremy-> Is it something to do with using $or and then $in not working? Seems unlikely, im assuming the nested syntax is confusing me
[03:07:07] <joe_p> trying to aggregate my shard chunks to look at distribution by ns, shard and the sort isnt working- db.chunks.aggregate( { $group : { _id : { ns : "$ns" , shard : "$shard"} , chunks : {$sum : 1} }, { $sort : {"_id.ns" : 1, _"id.shard" : 1 } } } )
[03:07:32] <joe_p> mongos> db.chunks.aggregate( { $group : { _id : { ns : "$ns" , shard : "$shard"} , chunks : {$sum : 1} }, { $sort : {"_id.ns" : 1, "_id.shard" : 1 } } } )
[06:49:27] <salentinux> hi guys, to do subqueries I use to save intermediate results in an array and then use it with $in operator. The question is, how much data can an array have?
[18:52:54] <silverfix> what is the best query? 1) db.col.find().sort('field':-1) or db.col.find({'$exists':'field'}).sort('field':-1) ?
[18:56:26] <Goopyo> find({'exists'…) means from all records give me the ones that have this field set
[18:58:28] <Goopyo> 1) Retrieves all records, sorts by field, those without field fall the the bottom or top
[21:07:36] <USvER> Hi, i have an array of subdocuments. How can i query items containing subdocument with specified fileds and can contain other fields.
[21:13:49] <USvER> So if i have collection with two documents: {subDocs:[{a:'1',b:'2'},{a:'2',b:'2'}]} and {subDocs:[{a:'1',b:'2'},{a:'2',b:'1'}]}. How can i query for documents that contain subdocument with {a:'2',b:'2'} i this case only first document... and {a:'2',b:'1'} wich will be only second....
[21:15:18] <USvER> Fon now if i test for {subDocs.a:'2', subDocs.b:'2'} i will get both documents...
[21:17:38] <USvER> i nead some sort of DotNotation mixed with subdocument query... wich will test for EXACT match....
[21:19:20] <USvER> I mean i don't need that "EXACT" match thing.... i just need to test subdocument for multiple fields...
[21:24:52] <USvER> This is something like "Array contains object with fields a equals to '2' and b equals to '2' but can contain other fields"
[21:38:36] <USvER> I really need this... and if there is no answer i would need to go relational way... for me this is like startover
[21:40:03] <fommil> is there a function which will sanitise a (Java) String – intended for literal matching in an aggregate – so that it can't contain any malicious characters?
[21:41:54] <USvER> Zelest, i'm newbie too... and i guess this one requires more experience in mongo... Thank you for your help....
[21:44:04] <Zelest> Hmms, might be me who's retarded, but I thought that $elemMatch was the right tool here..
[21:46:40] <USvER> Matching arrays must have at least one element that matches all specified criteria
[21:47:19] <USvER> I nead this: "Matching arrays must have at least one element that matches all specified criteria"
[21:48:09] <USvER> "Array contains object with fields a equals to '2' and b equals to '2' but can contain other fields