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

just hit the url directly /purchase/{auth.user}/purchase1 – rijin Jan 24 '18 at 11:12 — rijin, Jan 24 '18 at 11:12
But only with the good code in purchase object – Lionel B Jan 24 '18 at 11:13 — Lionel B, Jan 24 '18 at 11:13

score 1 · Accepted Answer · answered Jan 24 '18 at 11:16

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() )

answered Jan 24 '18 at 11:16

Ali Faris

17,754
10
45
70

You know how to do this kind of request with react-redux-firebase ? – Lionel B Jan 24 '18 at 12:28
sorry I didn't used react-redux-firebase – Ali Faris Jan 24 '18 at 12:44

Firebase query second level with react redux firebase

1 Answers1