Query data from firebase Array

Question

My firebase users tree has this structure:

users:

{
 {
 'userName': 'abc',
 'userEmail' : '[email protected]',
 'userPreferences': 
   [ 
     0:'Cinema', 
     1:'It' 
   ] 
  },
  {
 'userName': 'abc',
 'userEmail' : '[email protected]',
 'userPreferences': 
   [ 
     0:'Cinema', 
     1:'Music' 
   ] 
 }
 }

Then, I try to find all users that their preference list contain 'Cinema'.
I try this code:

var ref1 = new Firebase("https://event-application.firebaseio.com/users"); 
$scope.user = $firebaseArray(ref1.orderByChild("userpreferences").equalTo('Cinema'));
console.log($scope.user);

But I don't get the best result. I get this record:

What does "I don't get the best solution" means ?

Maen
– Maen

2016-04-28 10:59:45 +00:00
Commented Apr 28, 2016 at 10:59 — Maen
– Maen, Commented Apr 28, 2016 at 10:59

Grant · Accepted Answer · 2016-04-28 12:34:10Z

1

Your JSON structure shows preferences as userPreferences, so wouldn't the following work?

var ref1 = new Firebase("https://event-application.firebaseio.com/users"); 
$scope.user = $firebaseArray(ref1.orderByChild("userPreferences").equalTo('Cinema'));
console.log($scope.user);

However I think there is also another problem with your code, you're called an .equalTo('Cinema') however you're comparing it to an array, correct me if i'm wrong but I don't think the behaviour of .equalTo('Cinema') is to loop through each of the values and compare them, I think it's just a straight up comparison

If this is the case, you may need to build a custom query by reading the data from firebase and manipulating it via function available to a snapshot

answered Apr 28, 2016 at 12:34

Grant

4476 silver badges24 bronze badges

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

3 Comments

Sihem Hcine Over a year ago

Thank you for your answer. I edited my post. Yes that was my problem i don"t find how to compare .equalTo('Cinema') with array. And i must keep the same data structure

Grant Over a year ago

@SihemHcine Would you like me to go into reading data from firebase?

Sihem Hcine Over a year ago

yes of course Sir. Could you give me your mail please

Community · Accepted Answer · 2017-05-23 12:34:56Z

In NoSQL you'll often end up with a data model that reflects the way your application uses the data. If you want to read all the users that have a preference for Cinema, you should model that in your tree:

users: {
   'uid-of-abc': {
     'userName': 'abc',
     'userEmail' : '[email protected]',
     'userPreferences': [ 
        0:'Cinema', 
        1:'It' 
     ] 
   },
   'uid-of-def': {
     'userName': 'def',
     'userEmail' : '[email protected]',
     'userPreferences': [ 
       0:'Cinema', 
       1:'Music' 
     ] 
   }
},
"preferences-lookup": {
  "Cinema": {
     "uid-of-abc": true,
     "uid-of-def": true
  },
  "It": {
     "uid-of-abc": true
  },
  "Music": {
     "uid-of-def": true
  }
}

Now you can find out what users prefer cinema with:

ref.child('preferences-lookup/Cinema').on('value', function(snapshot) {
  snapshot.forEach(function(userKey) {
    console.log(userKey.key()+' prefers Cinema');
  });
});

This is covered in this blog post on denormalizing data with Firebase, in the Firebase documentation on structuring data and in dozens of answers here on Stack Overflow. A few:

Thank you Sir for your anwer :). But in my application structure(code) i have not to define preference for Cinema.

Collectives™ on Stack Overflow

Query data from firebase Array

2 Answers 2

3 Comments

1 Comment

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

1 Comment

Linked

Related