select('field_config_instance', 'fci') ->fields('fci', [ 'field_name', 'bundle', 'data', 'entity_type' ]) ->fields('fc', [ 'type', 'module', ]); $query->join('field_config', 'fc', 'fci.field_id = fc.id'); return $query; } /** * {@inheritdoc} */ public function prepareRow(Row $row) { $data = unserialize($row->getSourceProperty('data')); $row->setSourceProperty('widget', $data['widget']); $row->setSourceProperty('widget_settings', $data['widget']['settings']); return parent::prepareRow($row); } /** * {@inheritdoc} */ public function fields() { return [ 'field_name' => $this->t('The machine name of field.'), 'bundle' => $this->t('Content type where this field is used.'), 'data' => $this->t('Field configuration data.'), 'entity_type' => $this->t('The entity type.'), ]; } /** * {@inheritdoc} */ public function getIds() { return [ 'bundle' => [ 'type' => 'string', ], 'field_name' => [ 'type' => 'string', 'alias' => 'fci', ], ]; } }