Firestore query data based on string name [duplicate]

Question

I am trying to query data in FB/FS.

Lets say I have data like this:

"items": {
    "id1":{
        "phrase": "the cat got hit by a van"
    }
    "id2":{
        "phrase": "the frog got hit by a bad driver"
    }
    "id3":{
        "phrase": "the dog got hit by a car"
    }
    "id4":{
        "phrase": "the deer got hit by a bus"
    }
}

If I wanted to query data where phrase contains "cat" or "dog || van", how would I do this? Or can it be done?

I tried

db.collection("items").where("phrase", "array-contains", urlParams.get('s')).get().then((querySnapshot) => { ... }

but phrase is not an array, its a string.

aabdulahad · Accepted Answer · 2023-09-16 21:56:39Z

1

This is not possible in Firebase - see this link

Your options are really to either change your data structure to make use of Firebase features, query the entire collection by retrieving all documents and searching through them client side (which can very quickly become very expensive), or to switch to a different database solution - potentially something SQL based is what you are looking for.

answered Sep 16, 2023 at 21:56

aabdulahad

1,1458 silver badges23 bronze badges

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

1 Comment

letsCode Over a year ago

was afraid of this. thanks for the quick response.

Collectives™ on Stack Overflow

Firestore query data based on string name [duplicate]

1 Answer 1

1 Comment

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Linked

Related