Laravel DataTables JSON column escaping chars

Question

Trying to use Yajra DataTables as service implementation and here is my problem:

I have JSON column metas I building table columns based on fields inside that column, for excample:

[ 'data' => 'date', 'name' => 'metas->date AS date', 'title' => 'Data' ],

So inside metas I have:

{
    "date": "2018-09-17",
}

When I try to return this to DataTable it will leave quotas, or escape it with backslash. So the output looks like:

"Something" or "Something \"mmm?\ whatever!" but should be jus Something.

Tried ->escapeColumns(false) and ->rawColumns(['date']) and ->rawColumns(['metas->date']) and many more...

Response looks like this:

{"draw":1,"recordsTotal":77,"recordsFiltered":77,"data":[{"id":43695,"nr":"18-036","date":"\"2018-09-17\""...

As you can see I have additional quotes in response near date: Normally if I return same data from DB with ->toJson() there wouldn't be problem. There is something wrong with DataTables decoding.

And what is your question? I don't see any, just a description. — sɐunıɔןɐqɐp
– sɐunıɔןɐqɐp, Commented Oct 1, 2018 at 7:54

Emmanuel Osasa · Accepted Answer · 2023-12-01 10:09:20Z

0

By default, the Laravel Datable enforce XSS filter. You have to disable it in the column or the whole response.

https://yajrabox.com/docs/laravel-datatables/10.0/xss

answered Dec 1, 2023 at 10:09

Emmanuel Osasa

11 bronze badge

Sign up to request clarification or add additional context in comments.

1 Comment

Joe Niland Over a year ago

Answer could be improved by including the actual change he should make, rather than just a link.

Collectives™ on Stack Overflow

Laravel DataTables JSON column escaping chars

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related