Search

Hi mColumns option allows us to specify the columns that we have to export as an array of integers. but is there an option that also allows us to specify the order in which the columns must appear in the exported csv ? For eg if I specify mColumns as [2,1,0] then I would like my 3rd column to appear first,2nd columns to appear 2nd and 1st column to appear third.

Hi, I have extended the "ColVis" plugin with a new feature that I called "iMaxRows". It will ensure that the number of rows in the dropdown list created by the "ColVis" button will not exceed the maximum limit defined by "iMaxRows". This is particularely helpful when dealing with tables that have a large number of columns, as it prevents the dropdown list from becoming way too high to be nice and useful. Since I was a bit at a loss how to provide you with the modified "ColVis.js" I decided to paste it into the "DataTables live" feature. You should be able to view my updated "ColVis.js" code and a working live demo here: http://live.datatables.net/ipoduq/3/edit (Click on "Render" to see the live demo, then modifiy the value of "iMaxRows" in the "Code" to see how it effects the live demo) I'm keeping my fingers crossed that the above "DataTables live" thingy works out for everyone :-) Otherwise please inform me how else to provide the file. Some notes on my coding: * the "iMaxRows" option does NOT enfore the given number of rows, it just uses the value as a limit, the buttons for the columns will simply flow into the extra columns and quite often you end up with 1 row less than what "iMaxRows" specifies * the "[STWI]" markers exist only to make searching for my changes easier, feel free to remove them Regards, Stephan

Hi, I am using editable datatable where i have a clear button. On click of this clear button i need to clear the data entered in a particular column (say 4th). How do i do it? Thanks Ajay

Hi, I am looking for help to develop a custom pagination plugin that looks something like this. First Prev 1 2 3 .... 33 34 Next Last [When on Page 1] First Prev 1 2 .....15 16 17.... 33 34 Next Last [When on Page 16] Can someone let me know if someone has implemented something similar to this?

http://imgur.com/g6dSM - screenshot If you click the search button first time, that appears. If you click search a second time, it looks fine. Anybody seen this before? It only happens on IE8 or lower. There are no script errors.

In the database I'm reading from, I have a "status" column. Essentially it is storing a, open and closed option for a row. I have an image I want to use for the open status and for the closed status. Right now open = 1 in the database and closed = 2. I'm using a slightly modified version of the server scripting for php (http://datatables.net/development/server-side/php_mysql) I'm wondering how I would incorporate such a change when I'm using code like the above link shows. And the way you explain to me how to do this; would it affect searching in anyway? Because I will have another column that is item names, and in the column it actually displays the items image. Would the searching of the item be affected then?

Dear Sir, I am a Mechanical engineer with zero programming knowledge, can anyone suggest me how to have this done like this page for my data http://datatables.net/extras/tabletools/ I want filtered results to be made with search option dialog box . Data: http://jsfiddle.net/prabuk1985/rCChX/embedded/result/ http://jsfiddle.net/prabuk1985/rCChX/ Regards, prabu

Hi, I am very new to Data Tables. I am developing an application in Struts 1.2. I have seen an example in the web site for Server Side Processing at http://datatables.net/release-datatables/examples/data_sources/server_side.html I am having exactly same kind of requirement in my application. Can I get any such example written in Struts instead of PHP? Thanks in advance.

Dear all, can you help me to focus in in last row input element when dynamically add new row. Here is my code for new row [code] var addId = myTable.fnAddData([ '', 'elemtn2', 'element3']); var theNode = myTable.fnSettings().aoData[addId[0]].nTr; theNode.find('.item_name').focus() //not working [/code]

Hi All, I am very new at DataTables, and just recently installed it. I am using the COLDFUSION server-side processing version of the script. I would like to convert my RACE_DATE field from "0000-00-00 00:00:00" (YEAR, DAY, MONTH HOUR:MINS:SECOND) to "00/00/0000" or "00-00-0000" (MONTH, DAY, YEAR) format. I am using the following sAjaxSource code: [code] SELECT #listColumns# FROM #sTableName# WHERE OR #thisColumn# LIKE ORDER BY , #listGetAt(listColumns,(url["iSortCol_"&thisS]+1))# #url["sSortDir_"&thisS]# SELECT COUNT(#sIndexColumn#) as total FROM #sTableName# {"sEcho": #val(url.sEcho)#, "iTotalRecords": #qCount.total#, "iTotalDisplayRecords": #qFiltered.recordCount#, "aaData": [ , [,"-""#jsStringFormat(version)#""#jsStringFormat('' & qFiltered[thisColumn][qFiltered.currentRow] & '')#""#jsStringFormat('' & qFiltered[thisColumn][qFiltered.currentRow] & '')#""#jsStringFormat(qFiltered[thisColumn][qFiltered.currentRow])#"] ] } [/code] Please help... tried searching, which resulted in 5ish hours of nothing. I would deeply appreciated it! Thanks! Vic