Sort on date column not working with aggregate

Moralis General
#1 

const pipeline= [{sort:{"updatedAt": -1}},{limit:1}]
const query = new Parse.Query("TokenBalance");
const result = await query.aggregate(pipeline);
console.log(result);

first object in result array

image
image837×361 14.8 KB

data in collection

image
image1541×238 45.8 KB

#2

update - works with the query.descending("updatedAt) but not with aggregations. Aggregations are crucial for complex queries, why its not working?

#3

maybe you can try to convert it to string and then use it in aggregation, not sure if it will work

#4

but why customers cant sort based on date using aggregations?

#5

I don’t know why that happens

#6

There are threads on this forum mentioning this issue almost over a year old. Arent these bugs reported to the accordng department?

#7

I didn’t know about this problem.

In the past there were some problems on sorting by date if there were different date formats in db in that column.

#8

can this be investigated or forwarded? Feel like there are a good amount of issues from older posts still relevant now but new features get implemented almost monthly.

#9

I’ll have to test it, to see that it replicates, then it can be forwarded

1 Like
#10

thank you, lmk please so I can move on

#11

it looks like this syntax works:


Moralis.Cloud.define('test_aggregate', async (request) => {
   const pipeline= [{sort:{"_updated_at": -1}},{limit:1}]
   const query = new Parse.Query("EthNFTTransfers");
   const result = await query.aggregate(pipeline);
  
   return result;
})
[SOLVED] How to use group by and date filter
#12

I ran into this issue a long time ago, and still using block_number as workaround instead of sorting on createdAt.
Referenced here Can't get sort to work in aggregate query
I tested out using _created_at instead and that works fine. thanks for that clarification @cryptokid!

1 Like
#13

yes I switched to a new column timestamp with Date.now() values im using now cause the fields still seem bugged and its confusing if they are named differently using other tools than the browser dashboard.