Querying firebase database with a nested value

Question

Having some challenges querying my firebase database for an Android app I'm writing, I have the following structure;

Matches
 - Match_01
  - awayScore
  - awayTeam
  - date
  - gameID
  - homeScore
  - homeTeam
  - pitch
  - played
  - time
 - Match_02
  - awayScore
  - awayTeam
  - date
  - gameID
  - homeScore
  - homeTeam
  - pitch
  - played
  - time

I want to be able to query by using the gameID field, the problem I'm having is how to reference the gameID without explicitly setting a child("Match_01"), as I have Match_02, Match_03, etc... below is the code I'm playing with (which doesn't work, but gives you an idea of what I want to achieve). GetArgument is a value I'm passing into my fragment;

    DatabaseReference ref = database.child("Matches");
    Query gameQuery = ref.child().child("gameID").equalTo(getArgument);

Any help is appreciated.

Peter Haddad · Accepted Answer · 2018-03-04 11:29:13Z

2

Yes it can be done like this:

 DatabaseReference ref = database.child("Matches");
Query gameQuery = ref.orderByChild("gameID").equalTo(getArgument);

when you use orderByChild() you do not have to specify the direct child under Matches

answered Mar 4, 2018 at 11:29

Peter Haddad

81.2k26 gold badges148 silver badges149 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Querying firebase database with a nested value

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related