Answers

• kthorngren Posts: 21,352Questions: 26Answers: 4,955

  July 2018

  Where are you retrieving the data from?

  If using a SQL like database you can something like the SQL SELECT DISTINCT to return data with different (distinct) values. It would be best to do this in your sever script if you can.

  Otherwise you will need to process your JSON in Javascript and remove unwanted data before presenting to Datatables.

  Kevin
• patreeeeek Posts: 14Questions: 7Answers: 0

  July 2018

  How can I process my JSON file in javascript?

  $(document).ready(function () {

          $('#datatables').DataTable({
              "dom": '<"toolbar">frtip',
              "responsive": true,
              "scrollY": "550px",
              "scrollCollapse": true,
              "ajax": "smsMessages.json",
          "aoColumns": [
              {"mData": "sender"},
              {"mData": "content"},
              {"mData": "receiveTime"},
              {"mData": "messageId",
                  "fnCreatedCell": function (nTd, sData, oData, iRow, iCol) {
                      $(nTd).html("<i class='ti-pencil-alt btn btn-simple btn-edit btn-icon' href='#roleModal' data-toggle='modal' data-mode='edit'></i>\n\
                       <a href='#' type='button' class='btn btn-simple btn-danger btn-icon dt-delete'><i class='ti-close'></i></a>");
                  }
              }
          ],
              language: {
                  "search": "_INPUT_",
                  searchPlaceholder: "Search records"
              }
          });
          demo.initCirclePercentage();
      });
  

  this is how I retrieve my data right now
• kthorngren Posts: 21,352Questions: 26Answers: 4,955

  July 2018

  You can use ajax.dataSrc as a function and in the function loop through the data and keep what you want. The docs have a function example. The loop is simply your preferred way to loop through an array of objects.

  Kevin