public function NodeComplete::query in Drupal 10
Same name in this branch
- 10 core/modules/node/src/Plugin/migrate/source/d6/NodeComplete.php \Drupal\node\Plugin\migrate\source\d6\NodeComplete::query()
- 10 core/modules/node/src/Plugin/migrate/source/d7/NodeComplete.php \Drupal\node\Plugin\migrate\source\d7\NodeComplete::query()
Same name and namespace in other branches
- 8 core/modules/node/src/Plugin/migrate/source/d7/NodeComplete.php \Drupal\node\Plugin\migrate\source\d7\NodeComplete::query()
- 9 core/modules/node/src/Plugin/migrate/source/d7/NodeComplete.php \Drupal\node\Plugin\migrate\source\d7\NodeComplete::query()
Overrides Node::query
File
- core/
modules/ node/ src/ Plugin/ migrate/ source/ d7/ NodeComplete.php, line 31
Class
- NodeComplete
- Drupal 7 all node revisions source, including translation revisions.
Namespace
Drupal\node\Plugin\migrate\source\d7Code
public function query() {
$query = parent::query();
$query
->orderBy('nr.vid');
// Get any entity translation revision data.
if ($this
->getDatabase()
->schema()
->tableExists('entity_translation_revision')) {
$query
->leftJoin('entity_translation_revision', 'etr', '[nr].[nid] = [etr].[entity_id] AND [nr].[vid] = [etr].[revision_id]');
$query
->fields('etr', [
'entity_type',
'entity_id',
'revision_id',
'source',
'translate',
]);
$conditions = $query
->orConditionGroup();
$conditions
->condition('etr.entity_type', 'node');
$conditions
->isNull('etr.entity_type');
$query
->condition($conditions);
$query
->addExpression("COALESCE([etr].[language], [n].[language])", 'language');
$query
->addField('etr', 'uid', 'etr_uid');
$query
->addField('etr', 'status', 'etr_status');
$query
->addField('etr', 'created', 'etr_created');
$query
->addField('etr', 'changed', 'etr_changed');
$query
->orderBy('etr.revision_id');
$query
->orderBy('etr.language');
}
return $query;
}