CODEWITHSUNDEEP
swiftfirebasesearchgoogle-cloud-firestore
pho_pho
pho_pho

Reputation: 734

Firestore Query Across Multiple Fields for Same Value

Is it possible to query multiple fields in a firestore document for the same value?

Imagine I have numerous documents where each described a sport:

sportsRef.collection("sports").documents [
["bowling" : [
"equipment": "bowling ball, bowling alley, bowling shoes",
"description": "bowl the ball" ]]

["football": [
"equipment": "ball, boots, shin pads, goalie gloves",
"description": "kick the ball in the goal" ]]

["darts": [
"equipment": "darts, dartboard",
"description": "throw the dart at the board" ]]

["boxing": [
"equipment": "boxing gloves, ring",
"description": "punch your contender" ]]

["shot put": [
"equipment": "shot put",
"description": "throw the shot put, looks like a ball" ]]
]

Is there any way to make a query that, if I searched for a value of "ball", would return all the documents that have "ball" within their values. So in this case I would be returned bowling, football and shot put ("ball" is in the description of shot put).

The reason why I ask is because I have implemented a UISearchController in my iOS app and am trying to do the search in my Firestore by constructing a query in my app.

Upvotes: 1

Views: 1792

Answers (2)

user9195925
user9195925

Reputation:

One way to do something like that would be to restructure your data like so:

["bowling" : [
"ball": true, "bowling alley": true, "bowling shoes": true,
"description": "bowl the ball" ]]

and then query for documents where "ball" is equal to true:

Firestore.firestore().collection("sports").whereField("ball", isEqualTo: true)

Upvotes: 1

Doug Stevenson
Doug Stevenson

Reputation: 317382

Firestore doesn't support substring, regular expression, or full text search types of queries. Those kind of searches don't scale with the way Firestore manages its indexes.

If you need fully text searching, consider duplicating your data into a search engine such as Algolia. This type of solution is discussed in the Firebase docs.

Upvotes: 1

Related Questions