How get empty record on date field with entityQuery?

Question

I am on a custom entity with custom fields and i try to get all empty record on date field :

Field was create with CCK, so the field storage has a table.

  $query = \Drupal::entityQuery('test_entity');
        $query->condition('field_date',NULL,'=');
        $ids=$query->execute();

This doesn't work for date field.

Have you looked in the DB and confirmed that the values for those columns are actually null and not something else? The column is text or integer, depending on which field type you selected, so as far as a database query goes, there's nothing special about comparing it to null — Clive, Oct 13, 2016 at 12:43
it's a field create with the drupal interface, so the field is in fact a table, she has no record — Kevin, Oct 13, 2016 at 12:44
That'll be it then - the query will do an INNER JOIN on the field data table because you've included it in the conditions, and there's no data, so nothing to compare to null. Hence no results. — Clive, Oct 13, 2016 at 12:46
yes, so i replace with $query->notExists('field_date'); that seems to work, i ll try more test — Kevin, Oct 13, 2016 at 12:51
Oh brilliant, they accounted for that situation this time round, good news. Please do put an answer on once you've confirmed that works, this will be useful to a lot of people in time — Clive, Oct 13, 2016 at 12:53

Kevin · Accepted Answer · 2016-10-13 12:54:10Z

27

Since the field is stored in a single table, this is how i get all empty record from my entity where my custom field is empty :

 $query = \Drupal::entityQuery('test_entity');
        $query->notExists('field_date');
        $ids=$query->execute();

answered Oct 13, 2016 at 12:54

Kevin

2,5564 gold badges26 silver badges42 bronze badges

What about when it's in multiple tables?
– oknate
Oct 13, 2016 at 14:41
you need to add more conditions, like id or another field for filter. But your first filter is your entity ( entityQuery('test_entity')
– Kevin
Oct 13, 2016 at 14:45
This is great for when you add a new field to a content type but you can't bulk save them all for some reason.
– Lester Peabody
Apr 18, 2018 at 18:19
This is not working on a few fields. Any idea why it will behave like this? $appeal_query = \Drupal::entityQuery('node')->condition('status', 1)->condition('type', 'appeal')->notExists('field_appeal_country');
– Suraj
May 22, 2020 at 2:42
1

Just for the record, here's the documentation for exists/notExists : api.drupal.org/api/drupal/…
– JFC
Jun 30, 2020 at 4:27

Add a comment |

1 Answer 1