Search

Result of query: {"error":"Unknown field: (index 0)","data":[]} this is my code: $(document).ready(function() { var inputFilter = $('#example').dataTable( { order: [[ 8, "desc" ]], processing: true, serverSide: true, ajax: { url: "/complex/examples/php/join.php", type: 'GET' }, columns: [ { data: null, defaultContent: '', orderable: true }, { data: "shows_video.id" }, { data: null, render: function( data, type, full, meta ){ var youtube = data.shows_video.youtube ? '<i class="fa fa-youtube" style="color:#24CA00;"></i>' : '<i class="fa fa-youtube"></i>'; var top = data.shows_video.top ? '<i class="fa fa-home" style="color:#24CA00;"></i>' : '<i class="fa fa-home"></i>'; var recommended = data.shows_video.recomended ? '<i class="fa fa-bookmark" style="color:#24CA00;"></i>' : '<i class="fa fa-bookmark"></i>'; var video = data.shows_video.file ? '<i class="fa fa-film" style="color:#FFC200;"></i>' : '<i class="fa fa-film"></i>'; var image = data.shows_video.img ? '<i class="fa fa-camera" style="color:#24CA00;"></i>' : '<i class="fa fa-camera"></i>'; return '<span title="YouTube">'+ youtube +'</span> <span title="რეკომენდებული">'+ recommended +'</span> <span title="მთავარი სლაიდერში">'+top+'</span> <span title="YouTube">'+ video +'</span> <span title="YouTube">'+ image +'</span>'; } }, { data: "shows.title_ge" }, { data: "shows_video.title_ge" }, { data: "shows_video.title_en" }, { data: "shows_video.viewscount" }, { data: null, defaultContent: '', orderable: true }, { data: "shows_video.adddate" } ], } } ); $('#example_filter input').addClass('datetime').css({'width': '220px'}); $('.datetime').datepicker({ dateFormat: "yy-mm-dd", onSelect: function(dateText, inst){ var date = $(this).val(); inputFilter.fnFilter( date ); } }); } );

Hello, I saw a posting in the comments, but for me it did not work (http://www.datatables.net/examples/api/multi_filter.html). Someone answering me a question? The it was made I have sent several requests to my server. It is possible to only send a request with all que any fields are filled? I Was Unable to it in Place. I'm using version 1.10.

Hi, I'm currently loading datatables with an ajax source with anything between 100 - ~ 10,000 rows returned as a basic json response. JSON is returned in a very basic format and I make use of "render" to display the response accordingly in a user friendly manner and for filtering/searching I use the raw JSON data. For usability, i'd like datatables to load, say the first 5 records from DOM and the remainder from the datatables ajax request. The first 5 DOM elements will be outputted to the page already in the user friendly display (I guess you could call this the same as my "render" format ....). I have been reading about Defer Loading function, however, this looks to be Server side only, which mine is not. Even if I could use this function. How would you integrate the first 5 elements whilst ensuring they could be included and contain the necessary data for filtering/searching etc? I have complete control over how the first 5 are outputted to the page so I was originally thinking of making use of html 5 data attributes for the filter data but am at a complete loss as to how this would work with datatables..... Really appreciate if you could help on this one - please let me know if I need to provide more info. Thanks.

Hi, Is there a way to use http://datatables.net/reference/api/search() function so that even if serverside is true, it should just with data that tbale has at the moment. I think there should be option serverside(true/false)|optional .search(input,regex,smart,caseInsen,serverside(true/false)|optional)

Whatever I do, I cannot see why this is happening HTML: http://pastebin.com/2GJ9yuhm Screenshot: http://i.imgur.com/IKSGNhN.png Debug url: http://debug.datatables.net/awajup

Hi, I have a situation where I need to show two or more rows as a unit of data. For example, I might want to show two products that can go together to make a unit. Suppose I was looking for things that could be made into a sandwich. My results might show:  FoodCaloriesPrice 1.Bread2000.25  Peanut Butter1500.10   2.Bread2000.25  Peanut Butter1500.10  Jelly750.10   3.Bread2000.25  Roast Beef2501.00   OK, here's the challenge. I need to be able to filter and sort them by: a) All combinations containing an ingredient. b) Total calories. c) Total cost. I was thinking that I could use a nested table for this with some hidden columns that have the totals and other information (like a comma delimited list of the descriptions) and filter/sort on those. I was planning on using YADCF for the sorting. Any ideas if this is feasible? If my approach is wrong, is there another way to accomplish this with datatables and something like YADCF? Thanks

i searched using custom code id(table..column().search().draw()) it 's working fine but how to get back to normal state

Hi, i have an application with datatables. In a specific table there are around 500.000 records, it runs perfect. Table load in 1-2 seconds. Table has individual column filter, when i look for a record it takes around 15-20 seconds and i want to reduce this time because table will be bigger...someone knows if is there any way to look for data faster? i have thought delete individual column filter and insert a form with a select boxes with value of the columns and a text box to insert data that we need look and send this data serversideprocessing.php but o dont know if is possible? someone have made this? it reduces time to swow data? Thnaks

In my page I have text boxes and dropdown lists, like shown in below link. http://datatables.net/examples/api/form.html I want sorting and searching to be work on these fields also. How should I do this?

Hi! I'm using the Highlight plugin from: https://datatables.net/forums/discussion/2123/filter-post-processing-and-highlighting/p2 and it works fine. However it ignores if columns are set to searchable: false. Is there any way to disable the highlight on those columns? I added a fiddle: http://jsfiddle.net/3UZZW/ If you type in 13 you'll see that the date in the left column gets highlighted, too