EntityQuery condition “is not equal to…”

Question

Problem :

I need filtering entities based on the value of a multiple-choice field.
I want my query returns all entities except those who have a given value ('doe' for this example).

Actual :

multiple-choice values

foo|Choice 1
bar|Choice 2
doe|Choice 3

MyController.php

$query = \Drupal::entityQuery('node')
       ->condition('type', 'order');
$nids = $query->execute();
$entities = \Drupal::entityManager()->getStorage('node')->loadMultiple($nids);

Need :

So I need something like below :

$query = \Drupal::entityQuery('node')
       ->condition('type', 'order')
       ->condition('field_multiple_choice', '!=', 'doe');
$nids = $query->execute();
$entities = \Drupal::entityManager()->getStorage('node')->loadMultiple($nids);

How can I do ? Thank you in advance.

Answer 1

I found it !

I was not far away, I've just to reverse the last two parameters of the condition.

$query = \Drupal::entityQuery('node')
       ->condition('type', 'order')
       ->condition('field_multiple_choice', 'doe', '!=');
$nids = $query->execute();
$entities = \Drupal::entityManager()->getStorage('node')->loadMultiple($nids);

As the doc says, public function QueryInterface::condition take following arguments :

condition( $field , $value = NULL , $operator = NULL , $langcode = NULL )

Answer 2

It is impossible to check for the existence of entities with field <> value if that field may be null.

Instead, you must use an orCondition to do notExists OR <>:

$query= Drupal::service('entity.query')->get('myentity');
$group = $query->orConditionGroup()
->notExists('my_field')
->condition('my_field', '53', '<>');
$ids = $query->condition($group)->execute();