Search

Edit # 2

The number_format() method in PHP might do what you want. Use it with a custom formatter - e.g.:

Hi community!

Debugger code (debug.datatables.net): https://debug.datatables.net/awuweq

What you have in the previous code snippet looks ok.

The problem is that you have nested objects for your parent table, for example:

company_p_id and company_t_id are the matching fields.

Here is the current code. Column 4 is correct for filtering. What I've found with this is that clicking on the link to do the filter/search still returns an empty grid, but clicking on the "Show…

Sorry yes, I see it above now.

@allan above I posted my backend C#, once the data is received, shouldn't the search and sort functionality do it datatable automatically?

@kthorngren thanks, ok now it works. i just need to get the search and table sorting working which doesn't seem to be going, since you were quick to respond, would you give me one last help to solve …

$('#table tbody').remove();

Hi,

Use the Download Builder to generate the files needed for the buttons you want to add. See this doc for adding the buttons to the page. Also checkout the examples.

I did a little experiment with ajax.dataSrc in this test case:

I have a use case which is very similar to the example for parent/child editing.

You will need the draw() call in line 19 to execute the search plugin on line 13. However you are removing it on line 20 so the next draw (search, sort, page) won't apply the search plugin.

I am trying to filter a table using the function shown below. What I want it to do is to show me ONLY those rows where the specific column has a given integer value. The table itself is loaded with d…

Link to test case: No link, because it only works locally

The fact that you are using CakePHP makes little to no difference to DataTables. As long as you respond with the JSON structure that DataTables expects, then it will work on any platform.