[7.0] editColumn returned html is rendering as text

[latheesan-k]

Summary of problem or feature request

I use Datatables::eloquent to load a model with relationship and then use the edit_column to render some html based on model attribute. The returned html is rendering as plain text.

Code snippet of problem

function ajaxList()
{
    // Load users with users
    $users = User::with('group', 'organisation');

    // Finished
    return Datatables::eloquent($users)
        ->editColumn('is_admin', function(User $user) {
            return '<i class="fa fa-'. ($user->is_admin ? 'check' : 'times') .'" aria-hidden="true"></i>';
        })
        ->make(true);
}

<table id="users-table" class="table table-hover table-bordered" cellspacing="0" width="100%">
    <thead>
        <tr>
            <th>User ID</th>
            <th>Is Admin?</th>
            <th>First Name</th>
            <th>Last Name</th>
            <th>Created At</th>
            <th>Updated At</th>
            <th>Action</th>
        </tr>
    </thead>
</table>
<script>
    $('#users-table').DataTable({
        processing: true,
        serverSide: true,
        ajax: '/users/ajaxList',
        columns: [
            {data: 'id', searchable: false },
            {data: 'is_admin', searchable: false },
            {data: 'first_name'},
            {data: 'last_name'},
            {data: 'created_at', searchable: false },
            {data: 'updated_at', searchable: false },
            {data: 'action', searchable: false, orderable: false }
        ]
    });
</script>

Click here to see the rendered preview

System details

• Operating System: Windows (XAMPP)
• PHP Version: 5.6
• Laravel Version: 5.4
• Laravel-Datatables Version: 7.1

[minedun6]

Happens to me as well, all u need to is

return $user->is_admin ? '<i class="fa fa-check" aria-hidden="true"></i>' : '<i class="fa fa-times" aria-hidden="true"></i>' ;

I know it's a bit stupid but bear with it my friend. It always returns eitheir "times" or "check" instead of html.

[blueminded]

Same Problem here and unfortunately the answer @minedun6 si not correct.

take a look:

`->editColumn('saltin_code', function(UserChance $code) {
$codeResult = Code::with('users')->byName($code->saltin_code)->first();
$user_id = $codeResult->users[0]->pivot->inserted_by;

        return $user_id ? '<i class="fa fa-check" aria-hidden="true"></i>' : '<i class="fa fa-times" aria-hidden="true"></i>' ;
    })`

HTML:

I also try using blade sintax and view. same result. :(

[yajra]

Duplicate, please see #949.

[blueminded]

Hell! You are the boss. I just wasted 2 hours trying a lot of crazy things to make it work but no It was just a line.

great work there and THANK YOU so much.

[yulylc]

Cómo lo resolviste, no lo logro?

[charlievergara]

You need to use "rawColumns" method

->rawColumns(['column_with_html'])

[yulylc]

Muchísimas gracias por responder, justo había resuelto, pero igual agradezco la respuesta. Veo que los datatables tienen muchos detalles, pero dominarlos ahora mucho trabajo. Saludos fraternos El jue, 7 jul 2022 a las 12:15, Carlos Vergara ***@***.***>) escribió:

…

You need to use "rawColumns" method ->rawColumns(['column_with_html']) — Reply to this email directly, view it on GitHub <#972 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AHV2XOMS7RCUO4C7WWOZQRDVS37DHANCNFSM4C63EMJQ> . You are receiving this because you commented.Message ID: ***@***.***>

-- Ing. Yulieimis López Corría Informática BMCH