Search

to show icons, then columns.render probably is the best

to the browser. The columns.render function will manipulate that

I had the same issue and could eventually work it out, using the columns.render property. See https://datatables.net/reference/option/columns.render and especially the 2nd example there.

Thank you for the explanation Allan, now I understand why it loops three times when using columns.render. I will ask for a new stored procedure to the DBA to avoid using render.

RESOLVED. The "recordsFiltered" has a value different of "recordsTotal". The "recordsFiltred" is the number of items after globalSearch or columnSearch. If there is no search (globalSearch or columnSearch) , then the value "recordsFiltered" is equal to "recordsTotal". :)

you should use the columns.render option as it is

You can also use columns.render if you don't want to embed it into the JSON. There is an example on that page. Allan

Yes, the columns.render method is called every time DataTables requests data from the data source - this is intentional and desirable. Allan

Sure - use columns.render. A number of my Editor examples use exactly that (example). Allan

You make an Ajax call inside the columns.render function? It isn't designed to be suitable for async processing as that will be a serious performance issue. Do you really need Ajax to just build a link? Allan