Skip to content

Check for dates not migrating to smart dates fields after going live

mysql> SELECT d.bundle, d.entity_id FROM node__field_findit_dates d LEFT JOIN node__field_findit_opportunity_dates o ON d.entity_id = o.entity_id WHERE o.entity_id IS NULL;
+----------------+-----------+
| bundle         | entity_id |
+----------------+-----------+
| findit_event   |      8557 |
| findit_event   |      9731 |
| findit_event   |     10020 |
| findit_event   |     10020 |
| findit_program |      1471 |
+----------------+-----------+