Firebase query second level with react redux firebase

Question

I have a firebase database who contains all purchase of my users

purchase
    userId1
         purchaseId1
         purchaseId2
         purchaseId3
   userId2
         purchaseId1
         purchaseId2
         purchaseId3

A purchase object (ex: purchaseId1) contains a price and a specific code

{
 price:100,
 code:'2XBE'
}

I search a query to find all purchase with the code '3XB1'

I use react-redux-firebase

Thanks

Answer 1

you need to change the structure of your database

purchase : {
      purchaseId : {
           price:100,
           code:'2XBE'
           userId : 1
      }     
}

now you can do this

firebase.database().ref().child("purchase")
                   .orderByChild("code").equalsTo("3XB1")
                   .on( snap => console.log(snap.val() )