Cloud Firestore query with Variable in Where clause isn't working. Flutter

Question

I have declared a global variable and defined it in the initState() function of the app.

But when later using that variable in the Where clause of the Cloud Firestore query, the query doesn't work:

.where("email", isEqualTo: _userEmail.toString())

Instead, the query works when used with quotes:

.where("email", isEqualTo: "[email protected]")

Firestore.instance.collection('Matrimonial').where("email", isEqualTo: _userEmail.toString()).getDocuments();

Not Working

Firestore.instance.collection('Matrimonial').where("email", isEqualTo: "[email protected]").getDocuments();

Working

post you setStatemethod

Rubens Melo
– Rubens Melo

2019-05-02 06:27:39 +00:00
Commented May 2, 2019 at 6:27 — Rubens Melo
– Rubens Melo, Commented May 2, 2019 at 6:27
Did you ever find a solution?

Birch
– Birch

2019-09-11 21:07:21 +00:00
Commented Sep 11, 2019 at 21:07 — Birch
– Birch, Commented Sep 11, 2019 at 21:07
Dec 2021, seems to still be an issue...

Rens
– Rens

2021-12-01 11:27:35 +00:00
Commented Dec 1, 2021 at 11:27 — Rens
– Rens, Commented Dec 1, 2021 at 11:27

Birch · Accepted Answer · 2019-09-12 21:43:48Z

1

I found a way of using a varible parameter in the where clause by using vuefire:

watch: {
    userProfile () {
      this.$bind('allUsers', this.$db.collection('users').where('institution', '==', this.userProfile.institution))
    }
  }

This case, as different admins log in and become the currentUser, then they can only see all of the users from their institution.

answered Sep 12, 2019 at 21:43

Birch

2353 silver badges8 bronze badges

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

Comments

Angus Ryer · Accepted Answer · 2020-08-02 20:35:38Z

0

Late to respond, but I was searching or an answer to this question, and using string interpolation worked for me:

Firestore.instance.collection('Matrimonial').where("email", isEqualTo: `${_userEmail.toString()}`).getDocuments();

answered Aug 2, 2020 at 20:35

Angus Ryer

1742 silver badges13 bronze badges

2 Comments

Katherine Chen Over a year ago

This method doesn't work for me. There is a syntax error on the backtick quotation.

Angus Ryer Over a year ago

Thanks @KatherineChen -- odd that this worked for me. Where do you see the error?

Collectives™ on Stack Overflow

Cloud Firestore query with Variable in Where clause isn't working. Flutter

2 Answers 2

Comments

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related