Am fetching list of users for my listview (android) i used firebaselistadapter to backing up my listview , I wanna show users data except mine . Like an sql query Select something from usertable where id!=userid;
i wanna fetch all other users data,
Asked
Active
Viewed 7,818 times
7
Frank van Puffelen
- 565,676
- 79
- 828
- 807
sivaram636
- 419
- 3
- 14
-
1Nope. Currently there is no way to *exclude* certain values in a query, only to *include* it. – Frank van Puffelen Feb 18 '15 at 13:02
-
Looks like an answer, Frank! – Kato Feb 19 '15 at 16:35
-
1Yeah yeah... I thought this had been covered before, so was hoping *someone* would help me out and look up the dupe for me. :-) – Frank van Puffelen Feb 20 '15 at 00:39
2 Answers
9
Firebase currently only offers a way to include nodes based on the presence of a certain value. You cannot exclude nodes based on the presence of a value.
Update (20160828): I wrote a related answer today that shows how to detect the absence of a property.
Community
- 1
- 1
Frank van Puffelen
- 565,676
- 79
- 828
- 807
-
@Frank is there any workaround to do this? If not, filtering results once loaded at the client would be a good idea? – kunal May 13 '15 at 16:52
-
-
@Frank is it possible to do logical or / and conditions inside equalTo condition? – Nikhil Jan 29 '16 at 16:08
1
I have the same issue, using angularfire and geofire I am searching for business prospects within a radius and trying to create a lead only for new prospects, that means to exclude any existing account already with an existing relation. To do so I need to open a firebaseObject for each key returned by geofire and after $loaded() , check for _.isNull(loadedFirebaseObject.$value). The lodash function _.isNull() returns null if the firebaseObject path does not exists (a prospect) or undefined if it exists (not a prospect but an existing account).
Is there a better way of doing this?
Arup Saha
- 179
- 1
- 3