Version

Enable Eager Join Aliases

The enableEagerJoinAliases() API enables the generation of unique table aliases when joining eagerly loaded relationships. This solves the "Not unique table/alias" error when performing searches or ordering on columns from relationships.

Basic Usage

use Yajra\DataTables\Facades\DataTables;
use App\Models\Post;
 
Route::get('post-data', function() {
    return DataTables::eloquent(
        Post::with(['author', 'comments', 'tags'])
    )
        ->enableEagerJoinAliases()
        ->toJson();
});

The Problem

When you have nested eager-loaded relationships and try to search/sort on relationship columns, you may encounter:

SQLSTATE[42000]: Syntax error or access violation: 1066 Not unique table/alias: 'users'

This happens because multiple joins reference the same table without unique aliases.

The Solution

enableEagerJoinAliases() generates unique aliases for each joined table:

// Without aliases - causes conflicts
users
users AS users_author
users AS users_comments_pivot
tags AS tags_posts_pivot
posts AS posts_author

Supported Relations

This feature works with:

HasOne
HasMany
BelongsTo
BelongsToMany
HasOneThrough

Example with Multiple Relations

use Yajra\DataTables\Facades\DataTables;
use App\Models\User;
 
Route::get('user-data', function() {
    // Eager load all relationships
    $model = User::with([
        'posts.comments',      // Nested: posts -> comments
        'roles',               // Direct: roles
        'profile',             // HasOne: profile
        'teams.members',        // BelongsToMany: teams -> members
    ]);
 
    return DataTables::eloquent($model)
        ->enableEagerJoinAliases()
        ->toJson();
});