Possible to use EntityStorageBase::loadByProperties() to specify that field is or is not empty?

Question

Is there a way to use EntityStorageBase::loadByProperties() to specify that a field is either empty or not empty? I just want to check whether or not a field_date_completedhas a value set one it.

Looking to do something like $this->myEntityStorage->loadByProperties(['field_date_completed'=> notEmpty]) or $this->myEntityStorage->loadByProperties(['field_date_completed'=> isEmpty])

EDIT: Sorted out a solution using the accepted answer. Per How get empty record on date field with entityQuery?, we can do something like

$query = $this->myEntityStorage
  ->getQuery()
  ->notExists('field_data_completed');

$entity_ids = $query->execute();

Answer 1

Only in a narrow scope where "empty" for the field means the empty string ('') and it's stored as such in the DB.

EntityStorageBase::loadByProperties() uses a helper method, ::buildPropertyQuery(), that chains comparisons using the IN operator. As such, you can't use negation or special comparison cases (e.g. IS NULL if "empty" means NULL in the DB).

Unless you have simple string comparisons for your field, you're better off skipping ::loadByProperties() and using EntityStorageBase::getQuery() to retrieve a query object that you can customize to fit a "empty" / "not empty" query.