Firestore Query Properties with special characters

Question

I've a collection with contacts with a structure like:

name: 'XPTO' emails: { [email protected]: 'Susan', [email protected]: 'Fred' }

But the query will not return result: db.firestore().collection('contacts').where('[email protected]', '==', 'Susan').get().then(...

Because of the dot at "[email protected]"

How to escape the dot?

I've tried `` and [ ] and didn't work.

Answer 1

The documentation that suggests you should escape fields using backticks is actually not correct. It's in the process of being fixed. Instead, you should use FieldPath to build a path to the field to query:

db.firestore()
.collection('contacts')
.where(new FieldPath('emails', '[email protected]'), '==', 'Susan').