AngularFire query on multiple fields

Question

I'm working on a project which needs to select data from Firebase on multiple fields.

I have a firebase database like this:

[{
    date: "2016-01-29"
    done: false
    task: "hello world"
},
{
    date: "2016-01-29"
    done: false
    task: "hello world"
}]

Now I want to query all data with date is today and done is true.

I look around google for a while but there's nothing work. Is there any one can please help me to figure this out?

Community · Accepted Answer · 2017-05-23 11:48:34Z

1

You can only query on a single property with Firebase queries. So either you'll have to do the rest of the filtering client-side or you'll have to combine the values into a single 'date_done' property.

[{
    date: "2016-01-29",
    done: false,
    date_done: "2016-01-29_false",
    task: "hello world1"
},
{
    date: "2016-01-29",
    done: false,
    date_done: "2016-01-29_false",
    task: "hello world"
}]

Now you can get all the queries that were done on January 29 with:

ref.orderByChild('date_done').equalTo('2016-01-29_true').on(...

For some more information from people who asked similar questions, see:

edited May 23, 2017 at 11:48

CommunityBot

11 silver badge

answered Jan 18, 2016 at 2:27

Frank van Puffelen

603k85 gold badges895 silver badges869 bronze badges

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

1 Comment

Trung Bui Over a year ago

Thanks Frank a lot. I figure out what need to do with the issues. I have to redesign my database and add some fields for further purpose.

Collectives™ on Stack Overflow

AngularFire query on multiple fields

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related