Search

Hi All, I want to define the maximum width and height for all cells. At present, I'm using with ColReorderWithResize in the Datatable. The problem comes when a larger string comes in one of the column, Datatable expands the cell height or width automatically and that changes the layout. I want that string to use the ' overflow : hidden ' like property in order to make the string display go behind the next column OR achieve something like http://jsfiddle.net/gtRnn/ .. Whenever the column is resized then the data in the cell should show up OR wrapped up with trailing '..'. How can I do this with ColReorderWithResize? Any help is appreciated ! Regards

I've tried a million combinations. I initialize the datatable on document ready; $('#occTableData').dataTable({"sPaginationType": "bootstrap"} ); Here's the HTML: ID Title Description Status Company Account Amount Assigned To Here's the javascript function. You can see the commented out section. I've tried that also.; function populateData() { // Populate Row Data $.ajax( { type: "GET", url: 'api/occ/occStage.htm', data: 'userId='+userId, contentType: 'application/json; charset=utf-8', dataType: "json", success: function(adata) { // $("#occTableData").empty(); /// $("#occTableData").append('IDTitleDescriptionStatusCompanyAccountAmountAssigned To'); occData = adata; /* $.each(adata, function(index,item) { alert(item.title); $("#occTableData").append(''+ ''+item.occStageId+''+ ''+item.title+''+ ''+item.description+''+ ''+item.statusCd+''+ ''+item.companyCd+''+ ''+item.accountId+''+ ''+item.amount+''); $("#occTableData").datatable().fnAddData([item.occStageId,item.title,item,description,item.statusCd,item.companyCd,item.accountID,item.amount,item.assignedToUserid]); }); */ $('#occTableData').dataTable( { "sDom": "<'row'<'span6'l><'span6'f>r>t<'row'<'span6'i><'span6'p>>", "sPaginationType": "bootstrap", "oLanguage": { "sLengthMenu": "_MENU_ records per page" }, "aoColumns": [ { "mDataProp": "occStageId" }, { "mDataProp": "title" }, { "mDataProp": "description" }, { "mDataProp": "statusCd" }, { "mDataProp": "companyCd" }, { "mDataProp": "accountId" }, { "mDataProp": "amount" }, { "mDataProp": "assignedToUserid" } ] }); // $('#occTableData').dataTable().fnAddData([adata]); } // end success }); // end populate OCC data } Here's the JSON data; [{"occStageId":"628","parentOccStageId":"628","instanceOrder":null,"accountId":"100050","companyCd":"RSS","createdDtTm":"2013-05-02","postByDt":"2013-05-02","createdByUserid":"c0123456","createdByName":"sudha Kukkala","billCycleCd":"R16","statusCd":"WORKING","amount":"-200.00","creditOrDebit":"C","chargeCd":"ADJPYMT","title":"occ new","assignedDtTm":"2013-05-02","assignedToUserid":"c0123456","assignedToName":"sudha Kukkala","billPeriodDt":null,"invoiceNo":null,"svcPlanCds":null,"description":"occ new","groupCd":"QAWH","fullName":null,"custAcct":null,"carrierId":null,"opcAccountId":null,"opcChargeCd":null},

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