[SOLVED] Can't retrieve data based on dates :(

Moralis General
#1 
Moralis.Cloud.define("returnData", async (request) => {
  const query = new Moralis.Query("PolygonTransactions");
  let start=new Date(2022,03,28);
  let end=new Date(2022,04,23);
  const pipe=[
                {
                  match:{
                    $expr:{
                      $and:[
                        {$gte:["$createdAt",start]},
                        {$lte:["$createdAt",end]}
                      ]
                    }
                  }
                }
              ];
  const data=await query.aggregate(pipe);
  return data;
  });

The function returns [] although there exists data. I need to resolve this issue ASAP.

#2

You have to convert the date to iso string

An example:

                    {$gte: ["$block_timestamp", {"$toDate": new Date('2022-05-01').toISOString()}]},
#3

Screenshot 2022-06-11 at 3.30.39 PM
Screenshot 2022-06-11 at 3.30.39 PM2276×1272 521 KB

For example:
I need to fetch the transactions from start to end date given by the user from the frontend.

Moralis.Cloud.define("returnData", async (request) => {
  const query = new Moralis.Query("PolygonTransactions");
  let start=new Date(2022,02,01).toISOString();
  //start.setHours(start.getHours()+4);
  let end=new Date(2022,05,23).toISOString();
 // end.setHours(end.getHours()+4);
  const pipe=[
                {
                  match:{
                    $expr:{
                      $and:[
                        {$gte:["$createdAt",{"$toDate":start}]},
                        {$lte:["$createdAt",{"$toDate":end}]}
                      ]
                    }
                  }
                }
              ];
  const data=await query.aggregate(pipe);
  return data;
  });

But this code always returns []. Please help me am in the verge of completing my final assignment.

#4

try to use some logging to see what values you have for start and end

also, you may have to use _created_at instead of $createdAt

#5

Still returns the same - [] empty array. :frowning:

#6

What is the code that you use now?
Try to remove/comment parts of that condition with date limits
Did you log the date value?

#7

Screenshot 2022-06-11 at 4.47.46 PM
Screenshot 2022-06-11 at 4.47.46 PM1322×258 40.4 KB

Start and end date

#8

Try to also add master key parameter

Try without date filters to see if it works

#9

Yes it works without any filters. But this isn’t I was looking for :frowning:

#10

Ok, now add knelt one filter. Try various ways for that filter and date.

#11

Also, Try to post current code that you use.

#12

Above I have pasted the code below the PolygonTransactions collections image :frowning:

#13

Yes, that is the original code, that code is not going to work. What is the updated code that you use now?

#14 
Moralis.Cloud.define("returnData", async (request) => {
  const query = new Moralis.Query("PolygonTransactions");
  let start=new Date("2022-01-01");
  
  let end=new Date("2022-05-30");
  const pipe=[
                {
                  match:{
                    $expr:{
                      $and:[
                        {$gte:["createdAt",start]},
                        {$lte:["createdAt",end]}
                      ]
                    }
                  }
                }
              ];
  const data=await query.aggregate(pipe,{ useMasterKey: true });
  return {data, start, end};
  });
#15
  1. try to use _created_at instead of createdAt
  2. try to use something like new Date(‘2022-01-01’).toISOString()
#16 
Moralis.Cloud.define("returnData", async (request) => {
  const query = new Moralis.Query("PolygonTransactions");
  let start=new Date("2022-01-01").toISOString();
  
  let end=new Date("2022-05-30").toISOString();
  const pipe=[
                {
                  match:{
                    $expr:{
                      $and:[
                        {$gte:["_created_at",start]},
                        {$lte:["_created_at",end]}
                      ]
                    }
                  }
                }
              ];
  const data=await query.aggregate(pipe,{ useMasterKey: true });
  return {data,start,end};
  });

Updated code but with the same output. [] Array

#17

it looks like this worked for me:

Moralis.Cloud.define("returnData", async (request) => {
  const query = new Moralis.Query("BscTokenTransfers");
  let start=new Date('2022-05-01').toISOString()
  let end=new Date('2022-06-01').toISOString()
  const pipe=[
                {
                  match:{
                    $expr:{
                      $and:[
                        {$gte: ["$_created_at", {"$toDate": start}]},
                        {$lte: ["$_created_at", {"$toDate": end}]}
                      ]
                    }
                  }
                }
              ];
  const data=await query.aggregate(pipe,{ useMasterKey: true });
  return {data,start,end};
  });
1 Like
#18

It worked thanks a lotttt :laughing:

1 Like