Searching for an empty field in FireStore

Question

Searching for an empty field in FireStore

I'm facing an issue with a query that searches for a gameCreatedAt equal to null. Even though the collection doesn't have any null values, it still retrieves data inexplicably!

Here is how the query is written:

const query = firestore().collection('matches')
  query.where('gameStartedAt', '==', null)
  query.where(`lobby.${uid}`, '>', 0)
  query.orderBy('createdAt', 'desc')
  query.limit(1)

And this is what the data looks like: https://i.sstatic.net/AfOfX.png

I am puzzled as to why the

query.where('gameStartedAt', '==', null)

condition appears to be silently dropped. I was hoping someone could shed light on this peculiar behavior. While the criteria works in other programming languages using something like NSNULL() as mentioned in this stackoverflow post, in JavaScript, null seems to just end up being ignored.

javascript firebase google-cloud-firestore

Answer 1

Answer №1

One issue is that the query method returns a new query object instead of modifying the original one (source).

To address this, you can simply remove query from each line, like so:

const query = firestore().collection('matches')
  .where('gameStartedAt', '==', null)
  .where(`lobby.${uid}`, '>', 0)
  .orderBy('createdAt', 'desc')
  .limit(1)

This adjustment should resolve the issue.

Answer 2

One issue is that the query method returns a new query object instead of modifying the original one (source).

To address this, you can simply remove query from each line, like so:

const query = firestore().collection('matches')
  .where('gameStartedAt', '==', null)
  .where(`lobby.${uid}`, '>', 0)
  .orderBy('createdAt', 'desc')
  .limit(1)

This adjustment should resolve the issue.

Searching for an empty field in FireStore

Answer №1

Similar questions

An obstacle prevents the code injection process in the Chrome extension when a button is pressed

The type 'Observable<void | AuthError>' cannot be assigned to 'Observable<Action>'

The script encountered an error when attempting to access the property 'getContext' of a null object during the page's

Ways to toggle the expansion and collapse of multiple divs efficiently with jQuery without duplicating code

Revamp the Side Navigation Feature to Identify the Currently Viewed Section of the Page

Deliver a response to recipients through the "button" feature within the WhatsApp cloud API

Implementing email validation on the view layer for the yii framework using JavaScript

Leveraging promises with node.js and couched/nano for asynchronous operations

What is the best way to verify if an XMLHttpRequest made to my public API originates from my own web application or from a third-party client in order to maintain priority?

The art of swift JavaScript currency conversion based on time

Angular.js provides a solution for parsing a unique structure of JSON array containing objects

Adjusting the dimensions of :before with JavaScript: A Step-by-Step Guide

What is the best way to search for and isolate an array object within an array of objects using Javascript?

Retrieve the calculated events of an HTML element using JavaScript

Maximizing the Potential of AngularJS with HTML Injections via Chrome Extensions

Utilizing the useState hook to manage state

Error encountered in React Material UI: Appbar - TypeError occurred when attempting to read properties that are undefined (specifically, reading '100')

Learning about a basic sorting algorithm that analyzes and compares different values

Is there a method to make .load work on Chrome?

"An unexpected 'b' character was found at the beginning of the