> 
> I need to retrieve the details where the reportedAt = "moka" && name =
>  "chickungunya". as displayed in the firebase screenshot attached
> 
> 
> 

Please help

```
 //Filter markers by disease
disease = String.valueOf(spnDisease.getSelectedItem()).toLowerCase();
location = String.valueOf(spnLocation.getSelectedItem()).toLowerCase();

Query dbQuery = FirebaseDatabase.getInstance().getReference().child("diseaseReported").orderByChild("name").equalTo(disease);
dbQuery.addChildEventListener(new ChildEventListener() {
    @Override
    public void onChildAdded(DataSnapshot dataSnapshot, String s) {
        Log.d("v1", dataSnapshot.toString());
        Map m = dataSnapshot.getValue(Map.class);
        double lat = m.getLat();
        double lng = m.getLng();
        String reportedAt = m.getReportedAt();
        String reportedOn = m.getReportedOn();
        String name = m.getName();
        String snippetText = "Reported on: " + reportedOn;
        LatLng c = new LatLng(lat, lng);

        mMap.addMarker(new MarkerOptions().position(c).title("Disease reported: " + name).snippet(snippetText).icon(BitmapDescriptorFactory.defaultMarker(BitmapDescriptorFactory.HUE_GREEN)));

        }

    @Override
    public void onChildChanged(DataSnapshot dataSnapshot, String s) {

    }

    @Override
    public void onChildRemoved(DataSnapshot dataSnapshot) {

    }

    @Override
    public void onChildMoved(DataSnapshot dataSnapshot, String s) {

    }

    @Override
    public void onCancelled(DatabaseError databaseError) {

    }
});

```

[Firebase screenshot](https://i.stack.imgur.com/qoVUz.png)