Programmatically add views join query in Drupal 9

By hari, 1 August, 2023

Converting below join query string in Drupal's ways


INNER JOIN {user__roles} "user__roles" ON users_field_data.uid = user__roles.entity_id

use Drupal\views\ViewExecutable;
use Drupal\views\Plugin\views\query\QueryPluginBase;
use Drupal\views\Views;

/**
 * Implements hook_views_query_alter().
 */
function MYMODULE_views_query_alter(ViewExecutable $view, QueryPluginBase $query) {
  if ($view->id() == VIEW_MACHINE_NAME && $view->current_display == DISPLAY_ID ) {
  
  $configuration = [
        'type' => 'INNER',
        'table' => 'user__roles',
        'field' => 'entity_id',
        'left_table' => 'users_field_data',
        'left_field' => 'uid',
        'operator' => '=',
      ];
      $join = Views::pluginManager('join')->createInstance('standard', $configuration);
      $query->queueTable('user__roles', 'users_field_data', $join , 'user__roles');
  }
}

Programmatically add views join query in Drupal 9

Tags