$(document).ready(function() {
    tableApi = $('#all-queries').DataTable( {
        "rowCallback": function( row, data, index ){
            if (data[4] == "Pi-holed") {
                $(row).css('color','red')
            }
            else{
                $(row).css('color','green')
            }

        },
        "ajax": "api.php?getAllQueries",
        "autoWidth" : false,
        "order" : [[0, "desc"]],
        "columns": [
            { "width" : "20%", "type": "date" },
            { "width" : "10%" },
            { "width" : "40%" },
            { "width" : "15%" },
            { "width" : "15%" }
        ]
    })
} );

function refreshData() {
    tableApi.ajax.url("api.php?getAllQueries").load();
}
@@ -621,16 +621,90 @@
        %5D
+,%0A        %22lengthMenu%22: %5B%5B10, 25, 50, 100, -1%5D, %5B10, 25, 50, 100, %22All%22%5D%5D,
 %0A    %7D)%0A
@@ -790,8 +790,9 @@
 oad();%0A%7D
+%0A

Add option to show *all* queries at once