Retrieving data from firebase Array

Question

My Firebase Array has the following structure:

[
   {
  'userId': '12345',
  'itemOrdered' : 'abc',
  'status': 'pending'
   ...other attributes
   },
  {
  'userId': '6789',
  'itemOrdered' : 'def',
  'status' : 'pending',
   ...other attributes
   },
  {
  'userId': '12345',
  'itemOrdered' : 'def',
  'status' : 'complete',
   ...other attributes
   },

]

I am not able to figure out how to retrieve the following data:

Get records with userId = xxx
Get all records where 'itemOrdered" = 'def'

Firebase docs talk about using orderByChild but that doesn't make much sense.

Avoid using numeric sequential ids (i.e. arrays) in distributed systems.. Really? Yes, really — Kato
– Kato, Commented Jun 22, 2015 at 21:12

Frank van Puffelen · Accepted Answer · 2015-06-23 14:41:33Z

2

Assuming you're using the JavaScript SDK to access Firebase:

ref.orderByChild('userId').equalTo('xxx')
ref.orderByChild('itemOrdered').equalTo('def')

If you're trying to build a query that gets order of item def from user xxx, then that's not currently possible with Firebase's querying. The only way to query the value of multiple properties is to combine them in a single property in a way that allows the query you want. E.g.

ref.orderByChild('userId_itemOrdered').equalTo('xxx_def')

edited Jun 23, 2015 at 14:41

answered Jun 22, 2015 at 17:40

Frank van Puffelen

603k85 gold badges896 silver badges869 bronze badges

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

2 Comments

runtimeZero Over a year ago

Frank..that's exactly what I am trying to achieve.. get all items that user xxx ordered. when you say that's not possible in firebase... I dont' quiet understand your statement... what exactly does your solution .orderBY().equalTo() do then on the server side ?

Frank van Puffelen Over a year ago

Sorry, I misread your sample data. In my defense, items abc and def are somewhat hard to interpret. What I mean is that you can only query on a single property. So you can get all items ordered, but not all def that user xxx ordered (unless you combine those property values, like I show in #3). I'll update my answer.

Jay · Accepted Answer · 2015-06-22 21:01:47Z

0

There are additional options depending on your platform.

1) Query for the userId and then filter in code for the item you are looking for. 

2) Query for the userId and build another query based on those results.

3) Flatten your data!

For example: create a node called user_purchases and each child could be a userId node with that users purchased itemId's (that makes it a snap to know exactly what items a user purchased). Or create an items_purchased node with each child being an item number node and then associated userId's who purchased that item.

answered Jun 22, 2015 at 21:01

Jay

35.8k19 gold badges61 silver badges89 bronze badges

Collectives™ on Stack Overflow

Retrieving data from firebase Array

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related