Answers

• bazianm Posts: 10Questions: 5Answers: 0

  August 2016

  Is your table bound to an ajax call? If yes, couldn't you send the filter off to the server and then just .reload()? The .reload() will reissue the ajax call and repopulate the table...
• royba Posts: 5Questions: 3Answers: 0

  August 2016 edited August 2016

  Hi, the first table (#campaigns) is bound, and works well, i added a select menu (.selectpicker) which should do a filter results to the #campaigns table. Now, where and how should i add the Ajax request? (kind of newbie)... thanks

  Here is my code :

  script.
          $(function () {
              var tableTest = $('#campaigns').dataTable({
                  "ajax": {
                      "url": "/Marketing/banner_stats/"+#{campaign_id},
                      "dataSrc": "result"
                  },
                  "columns": [
                      {"data": "Advertiser"},
                      {"data": "Campaign"},
                      {"data": "Banner"},
                      {"data": "Impressions"},
                      {"data": "Clicks"},
                      {"data": "CTR"}
                  ],
                  "columnDefs": [
                      {
                          "render": function (data, type, row) {
                              if (data.indexOf("(Deleted)")){
                                  data = data.replace("(Deleted)", "<span class='label label-danger'>Deleted</span>");
                              }
                              return data;
                          },
                          "targets": 0
                      },
                      {
                          "render": function (data, type, row) {
                              if (data.indexOf("(Deleted)")) {
                                  data = data.replace("(Deleted)", "<span class='label label-danger'>Deleted</span>");
                              }
                              return data;
                          },
                          "targets": 1
                      },
                      {
                          "render": function (data, type, row) {
                              if (data.indexOf("(Deleted)")) {
                                  data = data.replace("(Deleted)", "<span class='label label-danger'>Deleted</span>");
                              }
                              return data;
                          },
                          "targets": 2
                      },
                  ]
              });
  
              $(".selectpicker").on('change', function () {
  
  
                 //Ajax request
  
  
                   //tableTest.ajax.url( "/Marketing/get_campaigns/"+range).load();
  
  
              });
  
  
          });
  
  
• bazianm Posts: 10Questions: 5Answers: 0

  August 2016

  How about just adding it as a query string to the ajax url?