Google Firestore: Filter documents where sub-key is between given value
up vote
0
down vote
favorite
I am working on a browser game and I have a collection in firestore that looks like this:
title: "doc 1",
requirements:
level:
min: 2,
max: 3
,
title: "doc 2",
requirements:
level:
min: 6,
max: 8
,
title: "doc 3",
requirements:
level:
min: 8,
max: 9
Is there any way to query for all documents, that match a given level like when I have a level of 8 I only want to fetch the documents "doc 2" and "doc 3" because the level requirements match?
I tried with something like
ref.where("requirements.level.min", "<=", level);
ref.where("requirements.level.max", ">=", level);
I also tried to change the structure in my documents to this:
title: "doc 1",
requirements:
level: [2, 3]
,
title: "doc 2",
requirements:
level: [6, 7, 8]
and filter it like this
ref.where("requirements.level", "array-contains", level)
But firestore always returns me all documents.
javascript google-cloud-firestore
asked Nov 10 at 13:43
Ma Kobi
608317
|
show 3 more comments
up vote
0
down vote
favorite
I am working on a browser game and I have a collection in firestore that looks like this:
title: "doc 1",
requirements:
level:
min: 2,
max: 3
,
title: "doc 2",
requirements:
level:
min: 6,
max: 8
,
title: "doc 3",
requirements:
level:
min: 8,
max: 9
Is there any way to query for all documents, that match a given level like when I have a level of 8 I only want to fetch the documents "doc 2" and "doc 3" because the level requirements match?
I tried with something like
ref.where("requirements.level.min", "<=", level);
ref.where("requirements.level.max", ">=", level);
I also tried to change the structure in my documents to this:
title: "doc 1",
requirements:
level: [2, 3]
,
title: "doc 2",
requirements:
level: [6, 7, 8]
and filter it like this
ref.where("requirements.level", "array-contains", level)
But firestore always returns me all documents.
javascript google-cloud-firestore
asked Nov 10 at 13:43
Ma Kobi
608317
Have you solved the issue?
– Alex Mamo
2 days ago
Unfortunately not
– Ma Kobi
2 days ago
Will it be helpful if I'll provide you an answer that implies some changes in your database structure?
– Alex Mamo
2 days ago
I am at the beginning of the development phase so I am thankful about every suggestion!
– Ma Kobi
2 days ago
Oh, sorry I missed that. You siad you have usedref.where("requirements.level", "array-contains", level)why do you say it always returns me all documents because is shouln't.
– Alex Mamo
2 days ago
|
show 3 more comments
up vote
0
down vote
favorite
up vote
0
down vote
favorite
I am working on a browser game and I have a collection in firestore that looks like this:
title: "doc 1",
requirements:
level:
min: 2,
max: 3
,
title: "doc 2",
requirements:
level:
min: 6,
max: 8
,
title: "doc 3",
requirements:
level:
min: 8,
max: 9
Is there any way to query for all documents, that match a given level like when I have a level of 8 I only want to fetch the documents "doc 2" and "doc 3" because the level requirements match?
I tried with something like
ref.where("requirements.level.min", "<=", level);
ref.where("requirements.level.max", ">=", level);
I also tried to change the structure in my documents to this:
title: "doc 1",
requirements:
level: [2, 3]
,
title: "doc 2",
requirements:
level: [6, 7, 8]
and filter it like this
ref.where("requirements.level", "array-contains", level)
But firestore always returns me all documents.
javascript google-cloud-firestore
asked Nov 10 at 13:43
Ma Kobi
608317
I am working on a browser game and I have a collection in firestore that looks like this:
title: "doc 1",
requirements:
level:
min: 2,
max: 3
,
title: "doc 2",
requirements:
level:
min: 6,
max: 8
,
title: "doc 3",
requirements:
level:
min: 8,
max: 9
Is there any way to query for all documents, that match a given level like when I have a level of 8 I only want to fetch the documents "doc 2" and "doc 3" because the level requirements match?
I tried with something like
ref.where("requirements.level.min", "<=", level);
ref.where("requirements.level.max", ">=", level);
I also tried to change the structure in my documents to this:
title: "doc 1",
requirements:
level: [2, 3]
,
title: "doc 2",
requirements:
level: [6, 7, 8]
and filter it like this
ref.where("requirements.level", "array-contains", level)
But firestore always returns me all documents.
javascript google-cloud-firestore
javascript google-cloud-firestore
asked Nov 10 at 13:43
Ma Kobi
608317
asked Nov 10 at 13:43
Ma Kobi
608317
asked Nov 10 at 13:43
Ma Kobi
608317
asked Nov 10 at 13:43
Ma Kobi
608317
asked Nov 10 at 13:43
Ma Kobi
608317
608317
Have you solved the issue?
– Alex Mamo
2 days ago
Unfortunately not
– Ma Kobi
2 days ago
Will it be helpful if I'll provide you an answer that implies some changes in your database structure?
– Alex Mamo
2 days ago
I am at the beginning of the development phase so I am thankful about every suggestion!
– Ma Kobi
2 days ago
Oh, sorry I missed that. You siad you have usedref.where("requirements.level", "array-contains", level)why do you say it always returns me all documents because is shouln't.
– Alex Mamo
2 days ago
|
show 3 more comments
Have you solved the issue?
– Alex Mamo
2 days ago
Unfortunately not
– Ma Kobi
2 days ago
Will it be helpful if I'll provide you an answer that implies some changes in your database structure?
– Alex Mamo
2 days ago
I am at the beginning of the development phase so I am thankful about every suggestion!
– Ma Kobi
2 days ago
Oh, sorry I missed that. You siad you have usedref.where("requirements.level", "array-contains", level)why do you say it always returns me all documents because is shouln't.
– Alex Mamo
2 days ago
Have you solved the issue?
– Alex Mamo
2 days ago
Have you solved the issue?
– Alex Mamo
2 days ago
Unfortunately not
– Ma Kobi
2 days ago
Unfortunately not
– Ma Kobi
2 days ago
Will it be helpful if I'll provide you an answer that implies some changes in your database structure?
– Alex Mamo
2 days ago
Will it be helpful if I'll provide you an answer that implies some changes in your database structure?
– Alex Mamo
2 days ago
I am at the beginning of the development phase so I am thankful about every suggestion!
– Ma Kobi
2 days ago
I am at the beginning of the development phase so I am thankful about every suggestion!
– Ma Kobi
2 days ago
Oh, sorry I missed that. You siad you have used
ref.where("requirements.level", "array-contains", level) why do you say it always returns me all documents because is shouln't.– Alex Mamo
2 days ago
Oh, sorry I missed that. You siad you have used
ref.where("requirements.level", "array-contains", level) why do you say it always returns me all documents because is shouln't.– Alex Mamo
2 days ago
|
show 3 more comments
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53239581%2fgoogle-firestore-filter-documents-where-sub-key-is-between-given-value%23new-answer', 'question_page');
);
Post as a guest
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Have you solved the issue?
– Alex Mamo
2 days ago
Unfortunately not
– Ma Kobi
2 days ago
Will it be helpful if I'll provide you an answer that implies some changes in your database structure?
– Alex Mamo
2 days ago
I am at the beginning of the development phase so I am thankful about every suggestion!
– Ma Kobi
2 days ago
Oh, sorry I missed that. You siad you have used
ref.where("requirements.level", "array-contains", level)why do you say it always returns me all documents because is shouln't.– Alex Mamo
2 days ago