Datatables change ajax data. The ajax docs state this:.

Datatables change ajax data Sorry I'm not following your code flow so these answers might not help. You will probably need to change something in your server script to not affect Ajax. The jQuery. Jquery Datatables passing extra parameters while making Ajax call. but after cant reflect on changes Thanks. php. reload();} ``` i am sorry repeat this question ,but i am new to this concept ,i have been trying to undertand the concept plz help me on it and save my day. The columns. Maybe try it using Bootstrap 3 styling with Ajax data load and serverSide processing. reload() in datatables. I was going though this forum and for server side processing most of the discussion point to oTable. 17. 10) that uses an AJAX data source, which accepts a parameter, as below: I have a datatable (1. The script used to perform the server-side processing for this table is shown below. Element 0 is of course used for indexing as the primary key and 8-10 was added for additional sorting so I can order 8 (ASC), I have a datatable (1. No, there is not. Colin var table = $('#example'). Within this function I assigned the callback to another global function in my code, let's say myFunction(), and thus myFunction() By default DataTables will look for the property `data` (or `aaData` for compatibility with DataTables 1. This works perfectly fine with DataTables although having some issues trying to change the specific rows colour once changed. the X-Requested-With is missing in header and the if case " Request. if any date not found it will show on range means all records will show and set page index. For each filter that is selected I get 2 set of data back from the server: one POST generated by the Ajax Query with the correct set of data and another GET generated by fnReloadAjax always with the full original set. data option. You could either hard-code which tables are on the server if they're static, or you could issue another ajax request to a different script get a list of tables to populate the select element. cell(this). Are you wanting to use those parameters in the Ajax fetch that DataTables is making? In which case, Kevin is spot on - use ajax. It can also be used to retrieve the currently set Ajax data source URL for a table. Datatable paging is correctly selected but remote data isn't updated and always show first page data. I don't believe there is anything in Datatables to dynamically change the value. I was worried that this would be the spirit of the reply. 10 using ajax request to get all the data from the server so that paging is done only on the client. DataTables AJAX dynamic URL. Get / set the URL that DataTables uses to Ajax fetch data. )DataTable() I tried . I have looked at many examples including the one you suggested but I am missing something. The latest data that has been loaded is shown below. numbers_length = 5; DataTables: page. reload() Use ajax. json" } ); table. Which is the way of change it on table. why is datatable use ajax when has event Order data from server has be change but template #student has be not change like data from server? DataTables. adding deferloading I get an empty table with no data but just the header. I will dig a little more. Here is my code: Warning: This assumes you are not using server-side processing, as this will overwrite the server-side request data which is auto-generated by DataTables. element(document). I'm using jquery and able to swap the classes but figure there has to be an easier way with datatables. The examples in this section demonstrate the use of Ajax loading data in DataTables, with client-side processing. In on change event it calls dt. dataTables Change Data for ajax call. reload() option makes it very easy to simply reload data from the existing data source, there are times when you want to change the data source URL. When I change the value in my model class, the value of the datatable column changes also. I actually solved the problem using the function ajax( data, callback, settings ). i do not need like this. g. I tried adding: $('. I want to be able to reload my datatable with AJAX, but need to be able to pass POST parameters. The environment doesn't have code to supply ajax data parameters as filters so the fetched data is the same each time. doesn't shows the new rows. Editor. This is due to the requirements for users to provide accurate data for the SearchPanes options, whose values change when using these two options. This is done through use of the ajax option, which has a number of options to customise how the data is retrieved from the server. Since you are using jQuery's ajax instead of Datatables ajax I would recommend reading some tutorials like this: https://howtodoinjava. Processing event - fired when DataTables Hi! How can I change the date display format from the json file from 2020-11-01 format to 01. rycwilson Posts: . I enter again the 3 and everything works fine. 11. Does provided answer address the issue thoroughly (then you may upvote/accept You need to use ajax. Improve this answer. I am using DataTable. How to fix? ajax here then $("div. Changing dataTables Change Data for ajax call. var oTable = $('#filtertable_data'). The ajax option basically inherits all of the options made available by jQuery. row('#my-row'). href = ajax. So for one column, datatable takes the data from my backbone model class. If you want to get involved, click one of these buttons! I'm using datatables with a non rdbms (like elasticsearch) system. There are some cases like ajax. Action on creating the table new { cyfy = "_Switch" })". ready(function {$. data(newValue) from within your click handler or even $(this). 10) that uses an AJAX data source, which accepts a parameter, as below: DataTables. Note you have to do the draw() afterwards, but you'll see that in the examples. "data : aoData" posts DataTable's own params via $. reload( null, false ) and cursor which was highlighting on second row disappears. Also adding an ajax. reload () option makes it very easy to simply reload data from the existing data source, there are times when you want to change the data source URL. For each action there should be different data used, so I have to somehow change my data source. Below is the code snippet how i initialize my data table. push({ "test" : "hello"}) just before $. reload(); I am only able to change the Ajax source URL, but that doesn't need to change. I have modal window for both - "New record" and "Edit record". clear() but then search does not return anything You would use dependent() to then get the different values for that other Select2 element - the change to the first would trigger the update to the second. Now I need to be able to "refetch" the AJAX data to update the DataTable, but without re-initialising the table. When the ajax runs again to refresh table data, the search caches the original table data and does not recognize the new data. Code works but as soon i replace html data with ajax it fails. I'm, using ajax request to get data to make my datatables, but I need change de columns with html's tags and content. Non of this worked. when user is at bottom of the page then not only focus on qty column is lost but also the page scrolls to top DataTables - Live Ajax. The only thing I can think of currently is to use the API and change the URI used, adding the selected option as part of the URL, but not 100% that'd work. data() doesn't work. dataSrc option of ajax as an object, if your data is formatted differently): { "data": [ // row 1 data source, // row 2 data source, // etc ] } Hi, On page load I display the JSON output of employee. You can set the data for that row with row(). I populated my DataTable by NOT USING server side, so data are preloaded (JSON) like this : datatable = $("#datatable"). After some research I Hi, When the value of column 'status' equals 'Aanwezig', i want to color de row green, otherwise red. 1. You can replace ajax: '/app/users' to data: yourJsonData - using a variable which holds JSON data you want to process. The table's data is being fetched by an async process on a different machine so I need to defer the ajax promise's resolution until the async server will finish processing. load it. Here is how I initialize the table $('#list'). But I have to use POST, with get the URL is to long. How to change Ajax Request Headers in Datatables. This data will update automatically as any additional data is loaded. ext. How to change data source for column. ajax, but we provide the extra option of dataSrc to provide the ability to alter what data DataTables will read from the JSON returned from the server, or to manipulate the data from one form into another (be it JSON to another form of Add or modify data submitted to the server upon an Ajax request. Sounds like you will need to determine which text box has focus and in the ajax. You are loading the Datatable data with data: data,. JQuery - Change the ajax data source of my datatable. I'm not actually fully understanding your initial question I'm afraid. ajax. So, my question is: how can i change the URL in the "preUpload" or is there another way how i can change the URL based on if I'm actually going to reinstate the deferLoading option for DataTables 2. 1. In general the Datatables initialization options can't be changed. fnDraw(). Description. The documentation shows an example for that, using jQuery extend: "data": function ( d ) I am trying to change the column number and header according to the return value of ajax, while the table data is updated using DataTables jquery plugin. I want to pass form data to datatable and submit like a regular form, i want to know if i pass data to ajax and click on submit then when Ajax configuration for form data submission. a feature in Datatables to dynamically change the column names. Hi,i have to try change css cell or row after ajax success. There isn't anything in the code there that relates to DataTables. reload() callback function set the focus back to that input. Use the xhr event to see if the options object exists and if it does The default page control presented by DataTables (first, last, forward and backward buttons with up to 7 page numbers in-between) is fine for most situations, but there are cases where you may wish to customise the options presented to the end user. dataTable( {"bProcessing": true, "bServerSide": true, I have a datatable in which I manipulate one of the table elements through ajax on a click event. DataTables: preXhr. thanks to topic on stackoverflow, I was able to pass in parameter from my variable in to url. reload() on my table. cascadePanes are supported. By clicking on the student button I want to change the datasource to students. Datatable on change ajax on checkbox not working, I have a data table and i am trying to update the value of active in the table into 1 if the checkbox is @kthorngren hi, in live. Colin "Note: When loading SearchPanes options over ajax, but then using serverSide processing, neither searchPanes. Please note - this property requires the Editor extension for DataTables. The select box has Division 1, Division 2, Division 3 and is separate and above the data table. Cheers, Colin DataTables can read data from a server via Ajax, while still performing searching, ordering, paging etc on the client-side. It all works fine in the examples I find but when I try and use createdRow or rowCallback it in combination with Ajax to get the table data it doesn't work. Advanced interaction features for your tables. However, even that inital set of JSON isn't populating the table. My code, but nothing changes Right now, I'm trying to bring in a set of initial data from an Ajax source, and then re-load it when my drop-downs change values. See ajax. It is a jQuery Ajax call that submits a form. If rowId is specified, then liveAjax will update only the necessary Hi. com Server Side Processing uses the draw parameter as a sequence number. page(${pageNumber}). Inside my modal I'm trying to populate another DataTable according to action - new/edit. Hello, I'm trying to implement a search form. It's work great but i have to get a parameter from the URl and set DataTables initial page. If I then change the data and instead enter 3 and then press enter, again the page goes to the top, URL changes, no data, and nothing on developer tool. ajax doesn't work. Follow answered Apr 2, 2018 at 18:55. data option can be used to modify the data DataTables submits to the server upon an Ajax request, by manipulating the original data object DataTables constructs I'm trying to change the parameters of the ajax() object, but it won't show an updated table. upload_url", "e. ajax allowing fine control of the Ajax request. This is why I wanted to write the quick post about how to use dynamic data in your DataTables AJAX request. But do you really need to? Assuming you mean with serverSide:true, the "draw" value (providing you are setting it in your response from your request on the server side, will keep the transactions in sync to ensure that the second requests does not get written over the first if the come back out of order. I've added a new feature to my datatables that allows me to re-query the data loaded, hence, I need to re-request/re-reload/re-recall the url ajax endpoint is what you are looking for to change the URL If you want to pass parameters Data property or manipulation method for table data. Looks ike you should be using data: aaData, since there is not a data object. The docs state: dt = table. I can set the value into a JS var when the user changes the radio button, no problem - just not sure how to get that into the DataTables' AJAX call to send back to the server. I have one big datatable on webpage and block of filters, which changes the url and ajax. DataTable( ); // to reload oTable. Hi, all my source, var mainMng=Howdy, Stranger! It looks like you're new here. Like the example I linked. url(). pager. upload_url, data. In this sample all the data needed is retrieved and paging is done in browser memory. ; A Javascript array - used when your data exists in a Javascript array; An Ajax data source; This section of the manual looks at how to use the last option here as it is can be particularly convenient to load your data Ajax What I'm after is, is there a way to change the closest row colour after being updated through ajax? The way our table works is, there's an edit button being called in another . reload() knows the table variable. If you could pass a function then I would say it could be dynamic. As of DataTables 2, this option can be given as an empty string to I am using DataTables serverSide in an Angular2 project. data as a function. DataTable. If you just need to change the datatable's ajax initial url later in your code, you can use: tbl. The paging is not setup I have it returning all data at the moment. Update sorting after ajax change. 9-) when obtaining data from an Ajax source or for server-side processing - this parameter allows that property to be changed. October 2010 edited October 2010 in General. What I want is to change the child row position when the parent row position changed. $('#example'). DataTable({ ajax: { url: 'data/objects_root_array. load. In your server script look for the draw parameter and when it is 1 you can build the options and return them in your own object, call it options for example, along with the rest of the JSON response. It works when I pass STATICs datas but doesn't work when I replace the STATIC data by a VARIABLE. Then when I click on a th I make an ajax call and get the data to fill the datatable. IsAjax() " returns false!!! Hi Allan, thanks for replying. or example_input3 change, simply reload the ajax method of DataTables by Howdy, Stranger! It looks like you're new here. I have the table working with paging and filtering, but I also want to bind to an event somewhere on the page (a click or whatever) that would change the ajax source and reinitialize the table. Hi there, This is my first time working with Datatables (using c# mvc in the back end), and the functionality I'm trying to create is the following: Datatables, change AJAX data ( not with elements ) 17. As an object, the ajax object is passed to jQuery. data() (or cell(). You could parse the HTML into JSON, but I suspect what would be a lot easier is to just make the $. What is wrong with my code? Here is my code: For a column, there is the wrong data loaded. Allan I try to refesh my table with ajax. Manual. the column headers are usually called DataTables_sort_wrapper. This example shows how SearchPanes can be populated via ajax, while using client-side processing. Problem is that if you change number of rows or filter data the rows(). I would like to reload the table with different parameters on a click event only i cant work out how to do this. At the moment I'm trying to modify ajax url for my table inside modal when modal is opened: I try to refesh my table with ajax. reload not solve the problem. i have problem about header when i send a request from datatables to my controller in mvc. Then the How should I go about posting additional data across to a php server-side data source with an ajax load method? I have a set of filters that modify the datatable based on a the selected value of each filter - this uses $_GET. That is separate ajax call for each page index change How to change Ajax Request Headers in Datatables. Pre-draw event - triggered as the table is about to be redrawn. I use Datatables for my project. This table loads data by Ajax. Database columns Column that I want to edit. Doesn't look like you are placing the JSON data in the data object (dictionary in Python terms) that Datatables looks for by default. After this call I need to change the column header class ("sorting_asc" or "sorting_desc"). It works when I define the var table; at the very top. I'm trying to change cell class based on its value. To be simple: I'm trying to make a new ajax request to the api for getting the new records on page change. angular. rows(). Note that DataTables expects the table data to be an array of items in the data parameter of the object (use the ajax. Ask Question Asked 8 years, 2 months ago. php', data : { a: 1, Get JSON data from a file via Ajax, using dataSrc to change data to tableData (i. Due to huge amount of data i am facing performanc issues so we need more sophisticated approach. Hello, I have the following code which I want to allow the user to filter the results of the data table based on 2 user inputs, start date and end date. Ajax automatically change page on ordering and search. We use the Jquery Datatables Ajax method for recieving data in the datatable like this: We use the Jquery Datatables Ajax method for recieving data in the datatable like this: Ajax automatically change page on ordering and search. Then clear and add fresh data: Sorry Allan, I must be thick, but I can't add my own data to the data that DataTable needs to post. DataTable({ ajax: { url: 'myfunction. datatable'). I'm using the following function to load a DataTables table with data from the server. data() will give you only initial data on load of page. Thats a good idea @rduncecb, I did get a work around where i made the initialisaztion a function and passed in the dataSrc id like to look at. aoColumnDefs=arrayDef; Secondly, the ajax option in Editor initilization on its own works fine for a row but I'm having trouble getting the function form of ajax to work, see code below: Hi @guillermovil,. :-) The DataTable() instance is after the slider() instance. In this example I am using a flat array for my JSON I found that you can use ajax. That is expected. data is used to define the object property for the column. url = ajax. dt event. After successful inline editor ajax update and change of focus, editor reverts to original value. I think you will want to use the 2nd example in the Also when i changed the 3rd and 4th row file name to 1st and 2nd file names respectively then it loads and working. css('background-color', 'greenyellow'); But when a filter is active the #idofcell not exist and css not applied. data() for individual cells). I can't figure out how to replace the current data i have a requirement of after searching in custom text box (not using datatable defaults search box) data will populated based on date on ajax call. If these custom query parameters are dynamic like retrieved from some input elements. If you want to load the initial data using data then the use of jQuery ajax will be much easier than trying to manipulate Datatables to go from using data to ajax. The full Editor reference documentation is available to registered users of Editor - the information shown below is a summary only. If you want to get involved, click one of these buttons! Datatable on change ajax on checkbox not working, I have a data table and i am trying to update the value of active in the table into 1 if the checkbox is clicked, and 0 if clicked again. Kevin. I tried something like: ' oSettings. The JSON data has been formatted specifically for use with DataTables. In the meantime, a workaround would be as Kevin says, return an empty data set if draw===1. Action on Ajax. If you want to get involved, click one of these buttons! I think you can't do that as you want it to do (at least, if I understood your "question" correctly). var dataFromTable = table. Data for a DataTable can essentially come from three different locations: The HTML - ideal for when your table already exists and has been populated with data. dt(); They had an example that removed a row from the DataTable. I have checked several questions already about this topic here in stackoverflow, but they are all using the old dataTable. I am doing something like this, but it doesn't work: dt. Trouble is I can't seem to reference the row and the the specific cell to change the data value in column 0 (the "Status:name" column) which is not the column of the action buttons. The cell background-color works but not border-color. There isn't a way for DataTables to embed its parameters into the address at the moment. At the moment it is only being evaluated when the table is initialised. I used (fnRowCallback) & (createdRow) & (rowCallback) with : Use the ajax. ready(function() {$('#example'). DataTables only expects JSON back. Hello, I'm, using ajax request to get data to make my datatables, but I need change de columns with html's tags and content. text(newValue) if you don't care about table source data and won't need to access that by DataTables API methods later on. url('api/route'). This method is design This is a quick post about how to modify your JSON returned objects before sending them to the tables using DataTables. I need to pass across additional hidden data to the server-side data source using $_POST Hello. Modified 8 years, 2 months ago. Instead of using variables use get the input value for the ajax. So what comes to mind is, you could change the appearance of those column headers with css and/or jQuery. If the DataTables setting rowId is not specified, then the entire table will be reloaded (via ajax. Although I like that idea. url( 'newData. Download. data(); console. Ajax event - fired before an Ajax request is made. Then on button click i change the state of the variable ( to 0 or 1 ) and call Ajax. Rezalfa Posts: 1 Questions: 1 Answers: 0. The goal is to refresh datatable automatically. Note: the author is using an AJAX call to retrieve his data in this example. value. DataTables. url("new url"); API Documentation As a function, the ajax. fn. With jquery by id selector no problem because it's on screen. load(); Share. Good questions. target. I ended up using a small JS block to add the d-none class to the inner divs. Records on the data source have a unique id and I can query them by using the api like; Hi guys, I'm trying to pass data using GET ajax function. Orthogonal data, with respect to DataTables, has solved quite a few future i have a requirement of after searching in custom text box (not using datatable defaults search box) data will populated based on date on ajax call. When there is a change to any of these inputs you will want Howdy, Stranger! It looks like you're new here. url() where you can make changes. By following this guide, you can implement DataTables with its default settings, integrate AJAX for dynamic data loading, and set up server-side processing for handling large While the ajax. vinayakj DataTables change Ajax URL mid-fly. Comprehensive editing library for DataTables. The Code. There is a note in the ajax documentation that says:. If not then you will need to use the ajax. reload. data. Hi. fnDraw The create your own inputs for these and pass the via the jQuery ajax() data option to the server. It has already been committed and I'm aiming for a release in about two weeks time. php in a datatable. cell or table row?? All tr and td have id. DataTable( Hi to all! In my datatable i pass few custom parameters (ex: values of input fields). find("table". type = 'POST'; dt. We have to pass these parameters as a function instead of a plain object. Please note that this is just an example script using PHP. The data from the ajax call is okay, I checked the json. { tableData: [ data ] }): For example, if the values of example_input1, example_input2, or example_input3 change, simply reload the ajax method of DataTables by using : example_table. Columns are identical at the moment. data = {<some data here>}; dt. data() . find("table tbody"). triggered immediately before data load. upload_url",". This is what I do: mtable = $('#messagestable') . I was wandering if its possible to pass in a different parameter to a controller using Ajax. Javascript and jQuery Code below: $( docum Currently using the jQuery Datatables plugin. Hi guys, i am new to datatable here, i am trying to create a datatable that is able to change its url whenever user changes the input text. I think what you'd have to do for this, since they are query string parameters, but part of the address, you'd need to use ajax as a function and then make your own Ajax call based on the information that DataTables is requesting. Please help me to refresh this data table. I have a DataTable which is able to successfully fetches AJAX data once while initialising the table. Answers i tried to set it with "e. The thing is t The ajax docs state this:. The data in "str" need to be passed on we all know basic way to access ajax data paging through datatables plugin in Jquery. Description: Monitor the AJAX data source every 5 seconds (default), comparing the current data structure and the data structure just pulled. DataTable( { ajax: "data. When they select the division the table only shows the inspection types for that division. What is wrong with my code? Here is my code: However, I would now like to change the request type to a POST and include a data object before I force an Ajax reload. You can change this by using destroy() and reinitializing the columns with the desired object properties but I'm guessing this isn't what you want. replace("_Switch",Switch). log(dataFromTable); and you should get the the array of rows. You may simply do table. DataTables: preDraw. The datatables already have classes for each element, e. Then the table. There are a lot of data in some columns, so I want to give users the control to show full data in cells or part of it (suppose those cells have class 'not-extended'). ajax docs state that the headers option can be a plain object. With get all works fine, but if I use POST I can't change the values put to the ajax script. once the request is made, you can't cancel it but you can ignore it. I want to be able to change the default page (on the client), so that for example when I reload ajax the UI will display page 2 initially. Description of problem: I want to load datatable on buton click or dropdown change, will it be like normal ajax submit or something else. 4 columns total. draw(false); to init. Please let me know if you know the solution or how this will work out. How to set dynamically the Ajax URL of a dataTable? 1. Viewed 1k times 1 . I can get the id of the clicked th but I don't know how to set the class. load() to change the data content. Example of my JSON: This is the SearchPanes extension for DataTables. ajax. DataTable({ data : myData, moreoptions : moreoptions }); Hi, I'm using datatables 1. $('#idofcell'). Hi, I have a table where I server-side process my data (0 to 10) and only display data elements 1 through 7. September 2018 in Free community support. Not really sure if that helps. I'm using this basically [code] $(document). I now need to be able to change the ajax data source based on some form input values, which would be submitted on a button click? What is the recomme In its simplest form, ajax, when given as a string will simply load the data from the given remote file. johncolvin Posts: 2 Questions: 0 Answers: 0. That is separate ajax call for each page index change I checked the backend code and it seems to return the right amount of rows, but i am not sure wht needs to be set so that datatable takes the dynamically changed ajaxsource and binds the datatable with the new set of rows. I'm just flipping between sources for project data which is different between each project. js. filter from the INPUT is ignored, like it's not there. I am tying to change the cell border after table update from ajax. The ajax docs state this:. reload()) whenever any changes are detected. . html(ajaxreturn) $("div. ajax() so I need to add my own params to that, right? Adding aoData. Take a look at the SSP protocol docs to get an idea of what is sent using SSP. viewTotal or searchPanes. data for more information. deferLoading, as the documentation explains, means that you have rendered the first page of the DataTable into the HTML so no Ajax call is sent. This we all know basic way to access ajax data paging through datatables plugin in Jquery. txt', dataSrc: '' }, columns: [ { data: 'name' }, { data: 'position' }, { data: 'office' }, { data Thank you very much for your reply. But when i changed the first row file to another name it doesn't load. I have a problem with changing the ColumnsDefs using the ajax. My datatables resquest is: DataTables. jQuery Datatables use function as ajax data source instead of path or url. mytable"). php file that saves the data being changed. I want to call a hyperlink in a modal window, the problem is that I can not recall the date variable + data + into the " #example00" "url" , Please Help !! You would need to use ajax sourced data to get the table's data - examples here. If you are using server-side processing, then you have to merge your custom data into the pre-existing request data. There is a flag that splits the data and alternates between the first half and second half Fetching large data using ajax and php (server side processing). DataTables: processing. This method is design to fit that purpose. how change number of rows in "Show Entires, which by default shows values 10,25,50,100. Every value of this column is from the model variable. jellepals Posts: 4 Questions: 1 Answers: 0. log is able to print out the new value but when java is trying to get the radio, radio shows the initial value being set into the table. datatables cant console log the data but on browser it is working like below var table you put. DataTable(). It is only in the case where I need to kind of "pre-set" the filter to a certain value that it isn't working. dataSrc option. reload(); If you declare your datatable as dataTable() (old version) you need: i use ajax after submitting results that will make change to the table. oTable. I am trying to reload the table after making changes, and those changes I want to pass them as parameters in POST via AJAX. While the ajax. I then added the Destroy parameter to the initialisation and on cahnge i call that function to create the dataTable. Page change event - fired when the table's paging is updated. e. Datatables isn't built to support both data and ajax at the same time. . but, as outlined above, clicking outside the editor results in the displayed data reverting Stack Overflow for Teams Where developers & technologists share private knowledge with coworkers; Advertising & Talent Reach devs & technologists worldwide about your product, service or employer brand; OverflowAI GenAI features for Teams; OverflowAPI Train & fine-tune LLMs; Labs The future of collective knowledge sharing; About the company I tried the styling but it kept being reset after the panel popped up. On initialization it sends 1 as the first sequence. 2020 format You don't need to lookup for the cell's row/column indexes. This seems to work, though it is probably a clunky way to do it. 0. Console. ajax() call yourself to get the HTML, write it into the document and then initialise DataTables on the table that has now been inserted into the document. data option as a function to retrieve the data you want to pass as parameters in the ajax request. Change parameter used in datatables ajax url. json' ). url() API method to set the URL that DataTables uses to Ajax fetch data. I'm doing the same as you, trying to update using a button, the tableupdates but doesn't change the information, for example the datable shows data of 1 week, if the second ajax (this one also works, I did some testing and it lloads all the new data) run, it loads the info for 1 month, the datatable updates but keeps the same info. Allan. jkkm rqeepna vomgpsx ilsr jlptp irmv stnj ajdpoxf akhi qqh vyof wex aaeso hrbx nsws