jquery dataTables plugin: dynamically modify ajaxSource

Question

on my page i have dataTable, which was initialized with, for example, sAjaxSource url like "/api/reports". when we're doing sorting, filtering it appends to url additional query-keys. I want do add keys "date_from" and "date_to" to sAjaxSource url (date intervals could be changed after table initialization). is there any entry-point function, before table reload, so i can do there smth like:

var oSettings = rtbl.fnSettings();
oSettings.sAjaxSource = "/api/reports/?type=sites&date_from=" + $("#date_from").text() + "&date_to=" + $("#date_to").text();

thanks for your help!

Anton Koval' · Accepted Answer · 2010-03-08 08:39:52Z

3

so, i've solved it, by next, quite dummy, way:

function set_sAjaxSource(){
                var oSettings = rtbl.fnSettings();
                oSettings.sAjaxSource = "/api/reports/?type=sites&date_from=" + $("#date_from").val() + "&date_to=" + $("#date_to").val();
            }

            $('.sorting').bind('click', set_sAjaxSource)
            $('.sorting_asc').bind('click', set_sAjaxSource)
            $('.sorting_desc').bind('click', set_sAjaxSource)
            $('.sorting_desc').bind('click', set_sAjaxSource)
            $('.paginate_button').bind('click', set_sAjaxSource)
            $('.sorting_active').bind('click', set_sAjaxSource)

answered Mar 8, 2010 at 8:39

Anton Koval'

5,0935 gold badges35 silver badges46 bronze badges

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

Comments

MisterHux · Accepted Answer · 2012-06-04 17:43:23Z

2

The correct way to do this to use the fnServerParams function of datatables, when creating the table:

fnServerParams: function(aoData) {
              aoData.push({ name: "type", value: 'sites' });
              aoData.push({ name: "date_from", value: $("#date_from").text() });
              aoData.push({ name: "date_to", value: $("#date_to").text() });
            }

answered Jun 4, 2012 at 17:43

MisterHux

14012 bronze badges

Collectives™ on Stack Overflow

jquery dataTables plugin: dynamically modify ajaxSource

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related