Search

please help .... how to do this.. via datatables jquery

am having dynamic drop downs on one column. if i type those text from drop down on search filed, is it possible to retrieve all rows that which dropdown has that text as selected. Tell me a way to do this.

Hello, I've a web site, that display some data with dataTables. The user can filter those data to do a subset selection. My problem is, by clicking on a button (for example), to extract the filtered data (in fact the first column) to do a php treatment. If I can obtain those data, I can then use an Ajax script, it's not a problem. My problem, is how do the extraction ? For example, simply, clicking on a button, how can I have an alert box with those data ? Any tutorial is welcome ! Thank a lot, Sohnic

Hello Friends! through each record I get the entire column, but I get just those on page 1 as possible to obtain all records of a column of all pages? greetings and thank you very much

ok, i have a databable being populated, which contains a reference field. I also have ASP.NET repeater, which displays subset of the items being displayed in the datatable, which also happens to have the reference field. I've marked the repeater reference as a hyperlink, and want ot know if it is possible, to filter the datatable based upon the value of the item being selected in the repeater?

edit -please delete-

I have a form used for time tracking. We have a control at the top of the form to navigate from one week to the next or to the previous week. Because some weekly entries can be quite long, I am using pagination. However, if I want to navigate to another week, I have to first move to the last page of entries. Otherwise, the data does not refresh. Any suggestions?

So I have the following code which works: [code] var a = $("#sample_1").dataTable().fnAddData( [ domEle['AGENCY_NAME'], domEle['ADVERTISER_NAME'], domEle['CAMPAIGN_NAME'], domEle['STRATEGY_NAME'], domEle['IMPRESSIONS'], domEle['CLICKS'], domEle['PC_CONVERSIONS'], domEle['PV_CONVERSIONS'], domEle['ADJ_PV_CONVERSIONS'], domEle['eCPM'], domEle['eCPA'], domEle['eCPC'], domEle['MEDIA_COST'], domEle['TOTAL_SPEND'], ]); [/code] However I want to display the columns in the order which is returned in AJAX so I want to change it to this: [code] var a = $("#sample_1").dataTable().fnAddData( [ $.each(data['columns_order'], function(key, value){ domEle[data['columns_order'][key]['fieldy']], }); ]); [/code] But I keep getting the following error "Uncaught SyntaxError: Unexpected token ) ", can anyone help? Cheers

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