Search

<thead> <tr> <th class="nosort">#</th> <th>Name</th> <th>Age</th> <th>Location</th> </tr> </thead> I have a while loop that produces 1 | Donald | 37 | Sidney 2 | Janice | 54 | London 3 | Alice | 44 | California ID is incrementing i++. The 'nosort' works fine, I cannot click the #. However, when I click Name for example, the following happens. 3 | Alice | 44 | California 1 | Donald | 37 | Sidney 2 | Janice | 54 | London As you can see, the # "changes". I want the # column to be static, only displaying the position so it won't change when I sort by name or age for example. How can I achieve this?

Hi, { "targets": 7, "data":"active", "render": function ( data, type, full, meta ) { return (data == "Yes") ? 'Inactivate': 'Activate'; } how can i access id from my table so that i can edit the row.s e.g href="edit.php?id='+data+'"; can i pass like below to access the id? "data":"active", "data":"id"

For instance, if the initial table width is 500px when the table is first drawn, if I then hide each column individually with colvis then unhide each column with colvis, I get a table with an overall width of 200px or so. Any ideas why this is happening? how can I get it so the table is 500px again?

Hi, I am using two grids in in my asp.net application. And one of the grids is duplicating the header. Facility Group Submit Date Submit By Request By User Name Title Email Approved Approved Date Actions Facility Group Submit Date Submit By Request By User Name Title Email Approved Approved Date Actions This is how I am setting up the grids: $(".gvv").prepend($("").append($(this).find("tr:first"))).dataTable({ "lengthMenu": [[3, 5, 10, 25, -1], [3, 5, 10, 25, "All"]], bJQueryUI: true, sPaginationType: "full_numbers", "bSort": false, "bFilter": true }); How can I remove the duplicate header? Any help will be very appreciated.

Hi, I have a url for an image in column 1. I have a hyper link url in column 2. I would like to display the image in column 1 and use the hyperlink from column 2 to link the image to an external url. How do I accomplish this task? Wyatt

I am using Jquery datatable to generate a empty table that i need to plot shifts into from some ajax data. My headers contains dates which i need to compared to my ajax data objects to see if they are the same, then insert a shifts html element. Unfortunately i have only been able to grab the Settings object in the callback, but it is ill advised to use it and hope for it to last, so any other way of doing this would be greatly appriciated. Thanks in advance

I have a table about dataTable ,there has one column I set the data 'null',then render it with the full data's compute result ;And I set this column "sortable:true',however,unfortunately,it don't working;some time,it working ,but,even if working ,the order is disorderly,It is no positive sequence or reverse order ;who can tell me what's reason ,thanks;

Hi I am using jquery 1.7 with primefaces 3.5 version for datatables with rowspan and colspan in headers in frozen column. when column freezed then header's row repeat with height='0' px dynamically. When removed these header's line by style ='none' then headers removed but row and column misalligned.

Hello, I have datatable 1.10.9 where i have used individual column search in each column, and tried to use horizontal and vertical scrolling, When i use //"scrollY": 400, //"scrollX": true, Then my serverside search is not working at all, means while input value in box, nothing happening. As soon as i mask above codes, search works fine, Any defect or problem? Thanks,

I've read about orthogonal data (https://datatables.net/examples/ajax/orthogonal-data.html) and nested objects (https://datatables.net/examples/ajax/objects_subarrays.html). Datas are provided via ajax. The question is how to combine this types together - I need to print out elements of array with orthogonal data, something like this: [ {type:customer, name: Name1, phone: [phone1, phone2], email: email1}, {type:supplyer, name: Name2, phone: [phone3, phone4], email: email2}, {type:customer, name: Name3, phone: phone5, email: [email3, email4] ] I've tried to use custom js function test for Column rendering: 'render' = 'test()' but unsuccesfully, it generates error: Uncaught TypeError: a[i[j]] is not a function, may be because data is provided by ajax.