Firestore select where is not null : <p>I'm using firebase to manage my project and I cannot get to create a query with a where clause where some value is not null. </p>

<p>Example: I have a collection of employees. Each have a list of equipments as an object where the key is the equipment id and the value a color. </p>

<pre><code>user = {
    firstName: 'blabla',
    lastName: 'bloblo',
    equipments: {
        123: 'blue',
        124: 'red'
    }
}
</code></pre>

<p>I would like to get all the employees who has a certain equipment in the equipments. Lets say 123. </p>

<p>It comes to Select * from Employees where equipments.123 is not null. I've tried:</p>

<pre><code>firestore.collection('employees').where(`equipments.${equipmentId}`, '!=', null)
</code></pre>

<p>but it's not working.</p>

<p>I can't seems to make it work. Can you help me.</p>
