Question

138

how to do joins on Firebase tables

rated 0 times [ 145] [ 7] / answers: 1 / hits: 26199 / 10 Years ago, sun, september 7, 2014, 12:00:00

I am trying to get data from two tables like (fetch all users and their details)

tableOne.on('users', function (snapshot) {

    userId = snapshot.val().userId; // line 1 (results like 1,2,3,4,5,6)

    anotherTable.child('userdetails').child(userId).once('value', function(mediaSnap) {

     // result // line 2

 });

});

but the problem is line 1 executes first for the 6 times and then line 2 that n times resulting in everytime looking for 'where user id is - 6'...isn't joins supported in Firebase?

Any help is apreciated

Answers

Only authorized users can answer the question. Please sign in first, or register a free account.

irvingcarloe

Add To Favorites

Follow

Total Points: 677

Total Questions: 109

Total Answers: 96

Location: Svalbard and Jan Mayen

Member since Sun, Sep 25, 2022

2 Years ago

irvingcarloe questions

1 Is it better to use multiple states or one state object in React?

Wed, Aug 10, 22, 00:00, 2 Years ago

1 Tailwind classes not working after page refresh in production

Fri, Jun 4, 21, 00:00, 3 Years ago

1 Event listener for dataLayer push events on Tag Manager JS

Wed, Mar 31, 21, 00:00, 3 Years ago

1 Convert file to Base64

Tue, Aug 4, 20, 00:00, 4 Years ago

1 How to autoplay audio in any browser?

Fri, Jul 3, 20, 00:00, 4 Years ago

View All

answered 10 Years ago gerardamosy · Accepted Answer

Your code snippet has a nasty side-effect:

var userId;

tableOne.on('value', function (snapshot) {

    userId = snapshot.val().userId; // line 1 (results like 1,2,3,4,5,6)

    anotherTable.child('userdetails').child(userId).once('value', function(mediaSnap) {

        console.log(userId + : + mediaSnap.val().name);

    });

});

You're not declaring userId as a variable, which means that it becomes a global variable in JavaScript. And since the callback function executes asynchronously, there is a good chance that the global values will have changed by the time you need it.

The solution is simply to make userId a local variable of the callback function:

tableOne.on('value', function (snapshot) {

    var userId = snapshot.val().userId; // line 1 (results like 1,2,3,4,5,6)

    anotherTable.child('userdetails').child(userId).once('value', function(mediaSnap) {

        console.log(userId + : + mediaSnap.val().name);

    });

});

This will ensure that each value of userId is captured inside the function.