sort seems to work fine. the following code works both under the current
1.0.2 and next 1.1 release
/**
* @ignore
*/
exports.shouldCorrectlySortDates = function (test) {
var collection = client.collection('shouldCorrectlySortDates');
var numberOfInserts = 5;
var id = setInterval(function() {
numberOfInserts--;
collection.insert({username:1, date:new Date()});
if(numberOfInserts == 0) {
clearInterval(id);
// Query
collection.find({username:1}).sort([['date',
'desc']]).toArray(function(err, items) {
console.log("----------------------------------------------------------")
console.dir(err)
console.dir(items)
test.done()
});
}
}, 500);
}
On Sunday, July 15, 2012 10:57:35 PM UTC+2, John wrote:
>
> On 07/15/2012 07:41 AM, Daniel Rinehart wrote:
> > One thing to try would be to startup mongosniff and see what command
> > the driver is sending to Mongo.
> >
> > http://www.mongodb.org/display/DOCS/mongosniff
>
> thks but running out of time to spend on this - now looking at work
> arounds
>
>
> >
> > -- Daniel R.<[email protected]> [http://danielr.neophi.com/]
> >
> >
> > On Sat, Jul 14, 2012 at 8:41 PM, john.tiger<[email protected]>
> wrote:
> >> this driver is not sorting this correctly - or maybe the sort just
> doesn't
> >> work with toArray - I can get the desired sort to work directly from
> the
> >> Mongo command line. I'll try the sort with cursor and then loop thru
> and
> >> push to an array to see if that works any better.
> >>
> >>
> >>
> >> On 07/14/2012 05:11 AM, Dan Milon wrote:
> >>> Actually first parameter is query, second is fields to fetch
> (optional,
> >>> and 3rd is options.
> >>> For sorting you can either do:
> >>>
> >>> coll.find({ username: username }, { sort: { date: -1 } })
> >>> or
> >>> coll.find({ username: username }).sort({ date: -1 })
> >>> and variants with arrays, but havent tested any of this.
> >>>
> >>> Dan Milon.
> >>>
> >>> On 07/13/2012 11:20 PM, Jeremy Darling wrote:
> >>>> try:
> >>>>
> >>>> col.find({username:username}, {}, {sort: {date: -1}}, function(err,
> >>>> records){
> >>>> console.log(records);
> >>>> });
> >>>>
> >>>> 1st param is the query, 2nd param is options object, sort is an
> object
> >>>> under the options object as entered in the Mongo CLI. In your
> examples your
> >>>> using arrays instead of objects.
> >>>>
> >>>> - Jeremy
> >>>>
> >>>> On Fri, Jul 13, 2012 at 3:03 PM, john.tiger<
> [email protected]
> >>>> <mailto:[email protected]>> wrote:
> >>>>
> >>>> have tried various syntax but nothing seems to be working - and
> >>>> which is right docs vs examples vs tests (I would think tests -
> >>>> some show "desc" some show "-1"
> >>>>
> >>>> here's an example:
> >>>>
> >>>> coll.find({"username":username}, {"sort":['date','desc']},
> >>>> function(err,cursor) {
> >>>>
> >>>> also tried as per test:
> >>>> coll.find({"username":username}, {"sort":[['date', -1]]},
> >>>> function(err,cursor) {
> >>>>
> >>>> thks for any help on this
> >>>>
> >>>> -- Job Board: http://jobs.nodejs.org/
> >>>> Posting guidelines:
> >>>>
> https://github.com/joyent/node/wiki/Mailing-List-Posting-Guidelines
> >>>> You received this message because you are subscribed to the
> Google
> >>>> Groups "nodejs" group.
> >>>> To post to this group, send email to [email protected]
> >>>> <mailto:[email protected]>
> >>>> To unsubscribe from this group, send email to
> >>>> [email protected]
> >>>> <mailto:nodejs%[email protected]>
> >>>> For more options, visit this group at
> >>>> http://groups.google.com/group/nodejs?hl=en?hl=en
> >>>>
> >>>>
> >>>> --
> >>>> Job Board: http://jobs.nodejs.org/
> >>>> Posting guidelines:
> >>>> https://github.com/joyent/node/wiki/Mailing-List-Posting-Guidelines
> >>>> You received this message because you are subscribed to the Google
> >>>> Groups "nodejs" group.
> >>>> To post to this group, send email to [email protected]
> >>>> To unsubscribe from this group, send email to
> >>>> [email protected]
> >>>> For more options, visit this group at
> >>>> http://groups.google.com/group/nodejs?hl=en?hl=en
> >>>
> >>>
> >> --
> >> Job Board: http://jobs.nodejs.org/
> >> Posting guidelines:
> >> https://github.com/joyent/node/wiki/Mailing-List-Posting-Guidelines
> >> You received this message because you are subscribed to the Google
> >> Groups "nodejs" group.
> >> To post to this group, send email to [email protected]
> >> To unsubscribe from this group, send email to
> >> [email protected]
> >> For more options, visit this group at
> >> http://groups.google.com/group/nodejs?hl=en?hl=en
>
>
--
Job Board: http://jobs.nodejs.org/
Posting guidelines:
https://github.com/joyent/node/wiki/Mailing-List-Posting-Guidelines
You received this message because you are subscribed to the Google
Groups "nodejs" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/nodejs?hl=en?hl=en
