Here my database structure :

{
  "feeling" : {
    "fake0" : {
      "fake1" : {...},
      "fake2" : {...}
    }
  },
  "profile" : {
    "fake0" : {...},
    "fake1" : {...},
    "fake2" : {...},
    "fake3" : {...}
  }
}

If the logged user is "fake0", how can he fetch all profiles that are not in his feeling ?

I would like to do something like : ref("/profile", {notEqualTo: ["fake1","fake2"]}).on('once', .....)

Perhaps my structure is bad, just tell me a better one and I will change it :) !

Here my database structure :

{
  "feeling" : {
    "fake0" : {
      "fake1" : {...},
      "fake2" : {...}
    }
  },
  "profile" : {
    "fake0" : {...},
    "fake1" : {...},
    "fake2" : {...},
    "fake3" : {...}
  }
}

If the logged user is "fake0", how can he fetch all profiles that are not in his feeling ?

I would like to do something like : ref("/profile", {notEqualTo: ["fake1","fake2"]}).on('once', .....)

Perhaps my structure is bad, just tell me a better one and I will change it :) !

• javascript
• firebase
• firebase-realtime-database

Share Improve this question Follow edited Aug 17, 2017 at 16:59 Charly berthet asked Aug 17, 2017 at 15:57 Charly berthetCharly berthet 1,31655 gold badges1717 silver badges3333 bronze badges

Add a ment  | 

1 Answer 1

Sorted by: Reset to default 8

This and a few other similar questions (Firebase: Query to exclude data based on a condition) and my experience with Firebase leads me to believe that there aren't any functionalities in Firebase that do this directly.

Now you can filter by property, which isn't entirely what you're looking for, but it might be useful for you to structure your database so that user profiles also contain reference to the /users who contain them/ in their feeling. Thus, your query would get much easier. You probably also want to, as mentioned in the other StackOverflow thread linked above, use the user ID as the key and store its value as "true." This way you can check by ID, which if I recall correctly is easier than checking value.

I know Firebase also remends that you store a little bit of redundant information; it's a matter of whether you want to put in the effort when writing or reading.