java - 在 Firebase android 中的两个日期内搜索子值

Question

这是json的样子

"Node" : {
      "1-5-2018" : {
        "10001" : {
          "centre" : "centre_1",
          "name" : "name_1",
          "paidAmt" : "25000"
        },
        "10002" : {
          "centre" : "centre_2",
          "name" : "name_2",
          "paidAmt" : "25000"
        },
        "10003" : {
          "centre" : "centre_3",
          "name" : "name_3",
          "paidAmt" : "10000"
        }
        },
      "2-5-2018 : {
        "10004" : {
            "centre" : "centre_4",
            "name" : "name_4",
            "paidAmt" : "20000"
            }
        }

我想检索给定日期内的值(中心、名称和支付金额)

我试过使用这个特定的查询，但它总是显示数据不存在

Query query = databaseReference1.orderByKey().startAt(fromDate.getText().toString()).endAt(toDate.getText().toString());

                query.addListenerForSingleValueEvent(new ValueEventListener() {
                    @Override
                    public void onDataChange(DataSnapshot dataSnapshot) {
                        if(dataSnapshot.exists()) {
                            Log.d(TAG, "Data exists within dates");
                            for(DataSnapshot ds : dataSnapshot.getChildren()) {
                                Log.d(TAG , "Data are " + ds.getValue().toString());
                            }
                        }
                        else {
                            Log.d(TAG, "Data does not exist within dates");
                        }
                    }

如果可以检索日期内的所有数据，请告诉我。将来我计划在不同日期内添加多个数据，并希望根据需要检索它们。也许每月或每周。

Answer 1

您使用的是时间戳而不是日期，它可能看起来像这样。

"Node" : {
      "1525188857" : {
        "10001" : {
          "centre" : "centre_1",
          "name" : "name_1",
          "paidAmt" : "25000"
        },
        "10002" : {
          "centre" : "centre_2",
          "name" : "name_2",
          "paidAmt" : "25000"
        },
        "10003" : {
          "centre" : "centre_3",
          "name" : "name_3",
          "paidAmt" : "10000"
        }
        },
      "1525188873" : {
        "10004" : {
            "centre" : "centre_4",
            "name" : "name_4",
            "paidAmt" : "20000"
            }
        }