Is it possible to request only part of a string in Firestore?

Asked Oct 02 '20 at 17:38

Active Oct 04 '20 at 07:00

Viewed 31 times

I have string fields in Firestore that can be quite long. Sometimes, all I need is the first X characters of that field and don't need the entire string. Is there a way to tell Firestore to only give me a substring of the field instead of the entire thing every time?

EDIT: This is not a question of text search, I'm try to get just the first X characters of a field, I'm not searching anything. I'm trying to minimize the data that Firestore sends back in order to minimize cost and bandwidth. Similar to SELECT LEFT(field , 100) FROM myTable in MySQL to get just the first 100 characters of field.

edited Oct 04 '20 at 07:00

asked Oct 02 '20 at 17:38

VagrantC

Firestore does not offer substring queries. You can do string prefixes though. – Doug Stevenson Oct 02 '20 at 17:43
@DougStevenson This is not a question of substring search. I've edited with a (hopefully) clarified explanation. – VagrantC Oct 04 '20 at 06:55
It's not possible to get a partial field value in query results. Your query will always retrieve the entire field. – Doug Stevenson Oct 06 '20 at 21:04

Is it possible to request only part of a string in Firestore?

0 Answers0