Cloud Firestore: check if value exists without knowing field name
up vote
0
down vote
favorite
I would like to check if a certain value is present in my Cloud Firestore collection through all the present fields and have back the document ID that has at least one field whose value is the one searched.
In this example, the code should give back only 2 records when I look for "Peter": 8cyMJG7uNgVoenA63brG and fnk0kgW7gSBc3EdOYWxD.
I know how to do a search when the field name is known. But in this case, I cannot know the field name at prior.
google-cloud-firestore
edited Nov 11 at 21:16
Doug Stevenson
68.2k880100
asked Nov 11 at 20:56
Stefano
11118
add a comment |
up vote
0
down vote
favorite
I would like to check if a certain value is present in my Cloud Firestore collection through all the present fields and have back the document ID that has at least one field whose value is the one searched.
In this example, the code should give back only 2 records when I look for "Peter": 8cyMJG7uNgVoenA63brG and fnk0kgW7gSBc3EdOYWxD.
I know how to do a search when the field name is known. But in this case, I cannot know the field name at prior.
google-cloud-firestore
edited Nov 11 at 21:16
Doug Stevenson
68.2k880100
asked Nov 11 at 20:56
Stefano
11118
In your example, "Peter" is in theAddressproperty and in the second inName. In how many others can be? Do you need an exact match orPeter Panshould also be a match?
– Alex Mamo
Nov 12 at 17:59
add a comment |
up vote
0
down vote
favorite
up vote
0
down vote
favorite
I would like to check if a certain value is present in my Cloud Firestore collection through all the present fields and have back the document ID that has at least one field whose value is the one searched.
In this example, the code should give back only 2 records when I look for "Peter": 8cyMJG7uNgVoenA63brG and fnk0kgW7gSBc3EdOYWxD.
I know how to do a search when the field name is known. But in this case, I cannot know the field name at prior.
google-cloud-firestore
edited Nov 11 at 21:16
Doug Stevenson
68.2k880100
asked Nov 11 at 20:56
Stefano
11118
I would like to check if a certain value is present in my Cloud Firestore collection through all the present fields and have back the document ID that has at least one field whose value is the one searched.
In this example, the code should give back only 2 records when I look for "Peter": 8cyMJG7uNgVoenA63brG and fnk0kgW7gSBc3EdOYWxD.
I know how to do a search when the field name is known. But in this case, I cannot know the field name at prior.
google-cloud-firestore
google-cloud-firestore
edited Nov 11 at 21:16
Doug Stevenson
68.2k880100
asked Nov 11 at 20:56
Stefano
11118
edited Nov 11 at 21:16
Doug Stevenson
68.2k880100
asked Nov 11 at 20:56
Stefano
11118
edited Nov 11 at 21:16
Doug Stevenson
68.2k880100
edited Nov 11 at 21:16
Doug Stevenson
68.2k880100
edited Nov 11 at 21:16
Doug Stevenson
68.2k880100
68.2k880100
asked Nov 11 at 20:56
Stefano
11118
asked Nov 11 at 20:56
Stefano
11118
asked Nov 11 at 20:56
Stefano
11118
11118
In your example, "Peter" is in theAddressproperty and in the second inName. In how many others can be? Do you need an exact match orPeter Panshould also be a match?
– Alex Mamo
Nov 12 at 17:59
add a comment |
In your example, "Peter" is in theAddressproperty and in the second inName. In how many others can be? Do you need an exact match orPeter Panshould also be a match?
– Alex Mamo
Nov 12 at 17:59
In your example, "Peter" is in the
Address property and in the second in Name. In how many others can be? Do you need an exact match or Peter Pan should also be a match?– Alex Mamo
Nov 12 at 17:59
In your example, "Peter" is in the
Address property and in the second in Name. In how many others can be? Do you need an exact match or Peter Pan should also be a match?– Alex Mamo
Nov 12 at 17:59
add a comment |
1 Answer
1
active
oldest
votes
up vote
0
down vote
accepted
If you don't know the name of a field, you can't perform any queries against its value. Firestore requires queries to use some index, and indexes always work with the names of fields in your documents.
answered Nov 11 at 21:16
Doug Stevenson
68.2k880100
I know the name of the collection. But I have to look through all the fields of that collection.
– Stefano
Nov 12 at 8:41
I understand that. You can't do that with a Firestore query. Probably you need a full text search engine instead.
– Doug Stevenson
Nov 12 at 8:51
add a comment |
Your Answer
StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
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
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53253158%2fcloud-firestore-check-if-value-exists-without-knowing-field-name%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
up vote
0
down vote
accepted
If you don't know the name of a field, you can't perform any queries against its value. Firestore requires queries to use some index, and indexes always work with the names of fields in your documents.
answered Nov 11 at 21:16
Doug Stevenson
68.2k880100
I know the name of the collection. But I have to look through all the fields of that collection.
– Stefano
Nov 12 at 8:41
I understand that. You can't do that with a Firestore query. Probably you need a full text search engine instead.
– Doug Stevenson
Nov 12 at 8:51
add a comment |
up vote
0
down vote
accepted
If you don't know the name of a field, you can't perform any queries against its value. Firestore requires queries to use some index, and indexes always work with the names of fields in your documents.
answered Nov 11 at 21:16
Doug Stevenson
68.2k880100
I know the name of the collection. But I have to look through all the fields of that collection.
– Stefano
Nov 12 at 8:41
I understand that. You can't do that with a Firestore query. Probably you need a full text search engine instead.
– Doug Stevenson
Nov 12 at 8:51
add a comment |
up vote
0
down vote
accepted
up vote
0
down vote
accepted
If you don't know the name of a field, you can't perform any queries against its value. Firestore requires queries to use some index, and indexes always work with the names of fields in your documents.
answered Nov 11 at 21:16
Doug Stevenson
68.2k880100
If you don't know the name of a field, you can't perform any queries against its value. Firestore requires queries to use some index, and indexes always work with the names of fields in your documents.
answered Nov 11 at 21:16
Doug Stevenson
68.2k880100
answered Nov 11 at 21:16
Doug Stevenson
68.2k880100
answered Nov 11 at 21:16
Doug Stevenson
68.2k880100
answered Nov 11 at 21:16
Doug Stevenson
68.2k880100
68.2k880100
I know the name of the collection. But I have to look through all the fields of that collection.
– Stefano
Nov 12 at 8:41
I understand that. You can't do that with a Firestore query. Probably you need a full text search engine instead.
– Doug Stevenson
Nov 12 at 8:51
add a comment |
I know the name of the collection. But I have to look through all the fields of that collection.
– Stefano
Nov 12 at 8:41
I understand that. You can't do that with a Firestore query. Probably you need a full text search engine instead.
– Doug Stevenson
Nov 12 at 8:51
I know the name of the collection. But I have to look through all the fields of that collection.
– Stefano
Nov 12 at 8:41
I know the name of the collection. But I have to look through all the fields of that collection.
– Stefano
Nov 12 at 8:41
I understand that. You can't do that with a Firestore query. Probably you need a full text search engine instead.
– Doug Stevenson
Nov 12 at 8:51
I understand that. You can't do that with a Firestore query. Probably you need a full text search engine instead.
– Doug Stevenson
Nov 12 at 8:51
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
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
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53253158%2fcloud-firestore-check-if-value-exists-without-knowing-field-name%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
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
Required, but never shown
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
Required, but never shown
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
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
In your example, "Peter" is in the
Addressproperty and in the second inName. In how many others can be? Do you need an exact match orPeter Panshould also be a match?– Alex Mamo
Nov 12 at 17:59