Search

Is it possible to know when the ajax call comes to the server if the call is thrown by pagination, filtering or sorting?

Hi, im using this code from this Forumpost to highlight the filtered data. which means if i type "as" it highlights all "as" in the table. works fine so far. but if i search for "nb" or "am". the script makes also the "&" and " " visible and higlighted. how can i modify the regex or something else so it ignores these expressions? Because in the table i have things like "Multi & Media" which the script does to: "Multi & Media if i type in "am" http://live.datatables.net/ukapoc/10 <-- in this case he don't finds the amp when tiping "am"... but he shows & if i search for &... i dont get it...its the same code as mine O.o Here is the fiddle, but i don't know how to make it complete work :/ http://jsfiddle.net/exk9h/1/ [code] // HIGHLIGHT FCT jQuery.fn.dataTableExt.oApi.fnSearchHighlighting = function(oSettings) { // Initialize regex cache oSettings.oPreviousSearch.oSearchCaches = {}; oSettings.oApi._fnCallbackReg( oSettings, 'aoRowCallback', function( nRow, aData, iDisplayIndex, iDisplayIndexFull) { // Initialize search string array var searchStrings = []; var oApi = this.oApi; var cache = oSettings.oPreviousSearch.oSearchCaches; // Global search string // If there is a global search string, add it to the search string array if (oSettings.oPreviousSearch.sSearch) { searchStrings.push(oSettings.oPreviousSearch.sSearch); } // Individual column search option object // If there are individual column search strings, add them to the search string array if ((oSettings.aoPreSearchCols) && (oSettings.aoPreSearchCols.length > 0)) { for (var i in oSettings.aoPreSearchCols) { if (oSettings.aoPreSearchCols[i].sSearch) { searchStrings.push(oSettings.aoPreSearchCols[i].sSearch); } } } // Create the regex built from one or more search string and cache as necessary if (searchStrings.length > 0) { var sSregex = searchStrings.join("|"); if (!cache[sSregex]) { var regRules = "(" , regRulesSplit = sSregex.split(' '); regRules += "("+ sSregex +")"; for(var i=0; i<regRulesSplit.length; i++) { regRules += "|("+ regRulesSplit[i] +")"; } regRules += ")"; // This regex will avoid in HTML matches cache[sSregex] = new RegExp(regRules+"(?!([^<]+)?>)", 'ig'); } var regex = cache[sSregex]; } // Loop through the rows/fields for matches jQuery('td', nRow).each( function(i) { // Take into account that ColVis may be in use var j = oApi._fnVisibleToColumnIndex( oSettings,i); // Only try to highlight if the cell is not empty or null if (aData[j]) { // If there is a search string try to match if ((typeof sSregex !== 'undefined') && (sSregex)) { this.innerHTML = aData[j].replace( regex, function(matched) { return "<span class='filterMatches'>"+matched+"</span>"; }); } // Otherwise reset to a clean string else { this.innerHTML = aData[j]; } } }); return nRow; }, 'row-highlight'); return this; }; [/code]

Hi, not work bStateSave with date-range. How to fix it?

I'd like to apply filtering to the column in

sides, and also have filters on the columns (on

approach the problem of filtering a data table given

/* Define two custom functions (asc and desc) for string sorting */ $(document).ready(function() { oTable = $('#listing').dataTable( { "bProcessing": true, "bServerSide": true, "sAjaxSource": "master_distributor/productsList.php", "aoColumns": [ { "mData": "product_name" }, {"mData": "product_id"}, { "mData": "parent_id","sClass": "txtCenter" }, { "mData": "action",'bSortable': false,"sClass": "txtCenter" } ], }).columnFilter({ aoColumns: [ { type: "text"}, { type: "text" }, { type: "text" }, null ] }); } ); In above i want to add action as a column in my datatable. but it is not working. Here action is the json resoponse from my ajax page

Hi Allan, I am using colvis and multi search together, but it has some issue though.. Cases: 1. If I uncheck 'Rendering Engine', and use multi-search for Engine Version (e.g. with data data 6 or 7), it wont give any data. 2. for multi-serach for CSS grade, it wont search at all I've created jsfiddle. Please hav a look... http://jsfiddle.net/AmsJy/10/ Great Thanks....Cheers !!

Hi guy's first of all great work thanks for this... In my web page am using more data tables in a page with tabs, I Want search one search for all data tables in page... So i used fnFilter all api... its reloved my problem, but.. when i am search it searches all tables in all tabs.. i need to search only visible tables on a page (current tab).. eg: i have 3 tables in each tab.. all are having same class for data table. and also each tab tables contains another class by tab name.. if am using [code] oTable.fnFilterAll(this.value); [/code] it searches all tables in all tabs... using this [code] var tables = $.fn.dataTable.fnTables(true); [/code] i can get the tables i want.. that means currently visible tables. but i don't know how to use this results in fnFilterAll method help me to resolve this... thanks

using datatable individual column filtering plugin,here am adding date-range