Firebase Query an Array of Keywords

Question

That's my Firebase Structure

My code

FirebaseDatabase database = FirebaseDatabase.getInstance();
DatabaseReference myRef = database.getReference("stock");
Query i = myRef.orderByChild("keywords").equalTo("Hammer");
i.addValueEventListener(new ValueEventListener(){
    @Override
    public void onDataChange(DataSnapshot dataSnapshot) {
        System.out.println(dataSnapshot.getValue());    
    }

    @Override
    public void onCancelled(DatabaseError databaseError) {

    }
});

My Problem: I wanna query only one item with the Keyword eg. "Hammer", but I only getting null as value. If I query like "orderByChild("keyword").equalTo("Hammer")" I'm getting the same null value. Please help me.

Please read this guide for asking questions over here: stackoverflow.com/help/how-to-ask — Kurt Van den Branden
– Kurt Van den Branden, Commented Jul 11, 2016 at 12:28
add the code as text. and include what myRefis refering to. — adolfosrs
– adolfosrs, Commented Jul 11, 2016 at 12:36
@adolfosrs there is no "stock" node in the database provided — Rohit Navarathna
– Rohit Navarathna, Commented Jul 11, 2016 at 13:05
Why would you use a realtime database to store this static data? It seems like overkill — Rohit Navarathna
– Rohit Navarathna, Commented Jul 11, 2016 at 13:08

adolfosrs · Accepted Answer · 2016-07-11 13:56:38Z

1

orderByChild will only look into the next level childs for the branch you are refering in /stocks. Your code would only work if you had the child keywords/0/keyword right bellow /stocks. Since its under /stocks/inserate/0 it wont work.

Query i = myRef.child("inserate/0/keywords").orderByChild("keyword").equalTo("Hammer");

This will do the trick but it might not be exactly what you want. If you want to search in all the iserates childs you should do some refactoring into your database.

answered Jul 11, 2016 at 13:56

adolfosrs

9,3896 gold badges45 silver badges69 bronze badges

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

Collectives™ on Stack Overflow

Firebase Query an Array of Keywords

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