2个日期之间的firebase实时数据库查询日期不匹配任何内容 [英] firebase realtime DB querying date between 2 dates does not match anything

问题描述

我正在尝试查找两个日期之间的所有对象.代码如下所示

I am trying to find all the objects that are between two dates. the code look like below

getPendingOrders(dateFrom:number, dateTo:number){
    console.log('start of getPendingOrders with dateFrom:' + dateFrom + " dateTo:" + dateTo)
    return new Promise((resolve, reject) =>
      {
       this.db.list('orders',
                     ref =>  ref.orderByChild("order/_date").startAt(dateFrom).endAt(dateTo)
       ).snapshotChanges().subscribe(
        res => {
          console.log('response:' + JSON.stringify(res))
          resolve(res)
        },
        err => {
          console.log(err)
          reject(err)
        }
      )
      })
  }

控制台正在打印:

start of getPendingOrders with dateFrom:1538265600000 dateTo:1538352000000

我的数据就像下面的db

My data is like below in db

"-LNc1K09FDXGW7PrS9wu" : {
    "order" : {
      "_date" : "1538269987967",
      "_deliveryType" : "Delivery",
      "_estDeliveryTime" : "12:NaN AM",
      "_isPaid" : false,
      "_location" : "djdjdj",
      "_orderNumber" : "VikKumar-87967",
    }
  },

但是我的代码不返回任何数据.不知道为什么吗?只是在这种情况下，如果我删除.endAt，那么它可以工作.所以某种程度上上限不起作用

but my code does not return any data. Not sure why? Just to add in this case if i remove .endAt then it works. so somehow upper bound does not work

推荐答案

原因是dateFrom和dateTo是数字(请参见(dateFrom:number, dateTo:number))，并且您将_date作为字符串存储在数据库中.

The reason is that dateFrom and dateTo are numbers (See (dateFrom:number, dateTo:number)) and that you store _date as a string in your database.

这篇关于2个日期之间的firebase实时数据库查询日期不匹配任何内容的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！