MongoDB .limit() ignoring .sort()? -

-

on mongodb 2.6.5 using mongo shell run queries

the problem: .limit() seems ignore .sort().

is regular behavior? don't think it's suppose i'm not sure. if not, there way make work sorting , limiting rather limiting sorting.

i'm running following query

db.post.find({categories: {$in: ["101"]}, location: {$near: [1.310000, 103.700000], $maxdistance: 0.449964}, dateexpire: {$gte: isodate("2014-11-27t00:00:00z")}, defunctind: null}, {_id: 1, datecreated: 1}).sort({datecreated: -1}).limit(5);

and result (the dates not in order of sorted list below)

{ "_id" : objectid("5473df733a0da831248b4567"), "datecreated" : isodate("2014-11-25t01:46:26.059z")}
{ "_id" : objectid("546ea9f63a0da8725b8b4725"), "datecreated" : isodate("2014-11-21t02:56:51.143z")}
{ "_id" : objectid("546da7503a0da856058b4633"), "datecreated" : isodate("2014-11-20t08:33:18.504z")}
{ "_id" : objectid("546da6943a0da8725b8b469a"), "datecreated" : isodate("2014-11-20t08:30:10.779z")}
{ "_id" : objectid("546da5c53a0da8725b8b4667"), "datecreated" : isodate("2014-11-20t08:26:42.299z")}

when run above query without limit

db.post.find({categories: {$in: ["101"]}, location: {$near: [1.310000, 103.700000], $maxdistance: 0.449964}, dateexpire: {$gte: isodate("2014-11-27t00:00:00z")}, defunctind: null}, {_id: 1, datecreated: 1}).sort({datecreated: -1})

this result

{ "_id" : objectid("5476accd3a0da8681d8b4596"), "datecreated" : isodate("2014-11-27t04:47:07.078z")}
{ "_id" : objectid("5476ac783a0da8a91d8b4577"), "datecreated" : isodate("2014-11-27t04:45:41.940z")}
{ "_id" : objectid("5476aaba3a0da8681b8b45b7"), "datecreated" : isodate("2014-11-27t04:38:15.751z")}
{ "_id" : objectid("5476a9e63a0da8751d8b4567"), "datecreated" : isodate("2014-11-27t04:34:42.835z")}
{ "_id" : objectid("5473df733a0da831248b4567"), "datecreated" : isodate("2014-11-25t01:46:26.059z")}
{ "_id" : objectid("5472f78f3a0da808608b47b8"), "datecreated" : isodate("2014-11-24t09:17:01.723z")}
{ "_id" : objectid("5472cc0c3a0da8725b8b4765"), "datecreated" : isodate("2014-11-24t06:11:22.772z")}
{ "_id" : objectid("547278bb3a0da8705b8b47b2"), "datecreated" : isodate("2014-11-24t00:15:53.478z")}
{ "_id" : objectid("547012413a0da8705b8b4780"), "datecreated" : isodate("2014-11-22t04:34:07.992z")}
{ "_id" : objectid("5470110a3a0da8705b8b477f"), "datecreated" : isodate("2014-11-22t04:28:55.778z")}
{ "_id" : objectid("546ea9f63a0da8725b8b4725"), "datecreated" : isodate("2014-11-21t02:56:51.143z")}
{ "_id" : objectid("546def203a0da8565b8b464a"), "datecreated" : isodate("2014-11-20t13:39:43.413z")}
{ "_id" : objectid("546deb693a0da856058b4649"), "datecreated" : isodate("2014-11-20t13:23:50.985z")}
{ "_id" : objectid("546da9cc3a0da856058b4647"), "datecreated" : isodate("2014-11-20t08:43:54.626z")}
{ "_id" : objectid("546da8733a0da808608b46ec"), "datecreated" : isodate("2014-11-20t08:38:09.092z")}

thanks

figured out problem.

$near not work $sort. reason why $sort being ignored when placed $limit unless $limit big enough encompass results. sort $near goes nearest distance.

the solution use $geowithin. http://docs.mongodb.org/manual/reference/operator/query/geowithin/#op._s_geowithin

this works $sort. in case of circle, replacement code location: {$geowithin: {$center: [[1.310000, 103.700000], 0.449964]} }


Comments

Post a Comment

Popular posts from this blog

matlab - "Contour not rendered for non-finite ZData" -

-
i'm trying plot frequency characteristic equation using ezplot, matlab gives following warning, "contour not rendered non-finite zdata". have used command plot frequency equations warning , plot display empty , not change axis range well. can please help. appreciated. here's code i'm using. % transfer matrix case-i, thin rotor clear all; clc; ei = 1626; l = 0.15; m = 0.44108; = 2.178*10^-4; i_p = 2.205*10^-5; itr = 0.24; i_pr = 0.479; syms p n; f = [1 l*1i l^2/(2*ei)*1i l^3/(6*ei); 0 1 l/ei -l^2/(2*ei)*1i; 0 0 1 -l*1i; 0 0 0 l]; p = [ 1 0 0 0; 0 1 0 0; 0 -it*p^2+i_p*n*p 1 0; -m*p^2 0 0 1]; p_r = [1 0 0 0; 0 1 0 0; 0 -itr*p^2+i_pr*n*p 1 0; -m*p^2 0 0 1]; = f*p*f*p*f*p*f; b = p_r*f*p*f*p*f; r = a(1,2)/a(1,4); a12_p = 0; a22_p = a(2,2)-r*a(2,4); a32_p = a(3,2)-r*a(3,4); a42_p = a(4,2)-r*a(4,4); ap(2,2) = a22_p; ap(3,2) = a32_p; ap(4,2) = a42_p; ap(4,4) = 1; c = b*ap; m = [c(3,2) c(3,4); c(4,2) c(4,...
Read more

delphi - Indy UDP Read Contents of Adata -

-
i using indy udp server read string of data. however, not know how work adata parameter. can around converting binary using bytetobin function below , convert hex using bintohex1 . feel stupid , works slow. know how can directly results without 2 conversions? thanks!! here codes: procedure tform1.idudpserver1udpread(athread: tidudplistenerthread; const adata: tidbytes; abinding: tidsockethandle); var buf: tidbytes; buffer: string; data_received: string; begin if bytestostring(adata) <> 'hello' begin buffer := hextostring('00'); setlength(buf, length(buffer)); copytidstring(buffer, buf, 0); abinding.sendto(abinding.peerip, abinding.peerport, buf); data_received := bintohex1(bytetobin(adata[1]) + bytetobin(adata[2]) + bytetobin(adata[3]) + bytetobin(adata[4]) + bytetobin(adata[5]) + bytetobin(adata[6]) + bytetobin(adata[7]) + bytetobin(adata[8]) + bytetobin(adata[9]) + bytetobin(adata[10]) + bytetobin(adata[11...
Read more

javascript - Any ideas when Firefox is likely to implement lengthAdjust and textLength? -

-
any ideas when firefox implement lengthadjust andtextlength?..... working svg application. lengthadjust , textlength working fine in chrome not working in fire fox . <svg viewbox = "0 0 500 300" version = "1.1"> <defs> <path id="s3" d="m 10,90 q 100,15 200,70" /> </defs> <g> <text font-size = "20"> <textpath xlink:href="#s3" textlength="205"> short text</textpath> </text> <use xlink:href="#s3" fill="none" stroke="black" stroke-width="1"/> </g> </svg> this implemented in firefox text elements (not textpath or tspan) in case that's ok though can move attribute text element. <svg viewbox = "0 0 500 300" version = "1.1"> <defs> ...
Read more