title: Fixed rows sorting in datatables
body: <p>I want to establish some fixed rows in head of the datatable. </p>
  
  <p>This is my datatable settings: </p>
  
  <pre><code>var oTable = $('#transactions').dataTable( {
      "aaSorting": [ [0,'desc'] ],
      "bFilter": false,
      "bSort": true, 
      "aaSorting": [[3,'desc']], // default search colums
      //            "aaSortingFixed": [[3,'desc']],
      "bPaginate": true,
      "bProcessing": true,
      "sPaginationType": "full_numbers",
      "asStripeClasses": [ 'monitoring-table-new' ],
      "bAutoWidth": false,
      "aoColumns": [
          {   "sType": "custom",
              "sClass": "td-date-size-cell",
              "fnRender": function ( oObj, sVal ) {
                  return '&lt;div class="monitoring-head-new leadencolor"&gt;&lt;div class="form-border"&gt;&lt;span class="date"&gt;&lt;em&gt;' + sVal + '&lt;/em&gt;&lt;/span&gt;&lt;/div&gt;&lt;/div&gt;';
              }
          },
          {   "sType": "custom",
              "sClass": "td-transaction-size-cell",
              "fnRender": function ( oObj, sVal ) {
                  return '&lt;div class="monitoring-head-new leadencolor"&gt;&lt;div class="form-border"&gt;&lt;span class="transaction"&gt;&lt;em&gt;' + sVal + '&lt;/em&gt;&lt;/span&gt;&lt;/div&gt;&lt;/div&gt;';
              }
          },
          {   "sType": "custom",
              "sClass": "td-client-size-cell",
              "fnRender": function ( oObj, sVal ) {
                  return '&lt;div class="monitoring-head-new leadencolor"&gt;&lt;div class="form-border"&gt;&lt;span class="client"&gt;&lt;div&gt;' + sVal + '&lt;/div&gt;&lt;/span&gt;&lt;/div&gt;&lt;/div&gt;';
              } 
          },
          {   "sType": "custom",
              "sClass": "td-value-size-cell",
              "fnRender": function ( oObj, sVal ) {
                  return '&lt;div class="monitoring-head-new leadencolor"&gt;&lt;div class="form-border"&gt;&lt;span class="value"&gt;&lt;em&gt;' + sVal + '&lt;/em&gt;&lt;/span&gt;&lt;/div&gt;&lt;/div&gt;';
              }
          },
          {   "sType": "custom",
              "sClass": "td-status-size-cell",
              "fnRender": function ( oObj, sVal ) {
                  return '&lt;div class="monitoring-head-new leadencolor"&gt;&lt;div class="form-border"&gt;&lt;span class="status"&gt;&lt;div&gt;' + sVal + '&lt;/div&gt;&lt;/span&gt;&lt;/div&gt;&lt;/div&gt;';
              }
          },
      ],
      "sAjaxSource": '&lt;?php echo url_for('@test?sf_format=json'); ?&gt;',  
  
  } );
  </code></pre>
  
  <p>I have done in the following way: </p>
  
  <pre><code>   jQuery.fn.dataTableExt.oSort['custom-asc']  = function(x,y) {
          if (x.indexOf("MY VALUE") != -1) return -1; // keep this row at top
          if (y.indexOf("MY VALUE") != -1) return 1; // keep this row at top
  
          return ((x &lt; y) ? -1 : ((x &gt; y) ?  1 : 0));
      };
  
      jQuery.fn.dataTableExt.oSort['custom-desc'] = function(x,y) {
          if (x.indexOf("MY VALUE") != -1) return 1; // keep this row at top
          if (y.indexOf("MY VALUE") != -1) return -1; // keep this row at top
  
          return ((x &lt; y) ?  1 : ((x &gt; y) ? -1 : 0));
      };
  </code></pre>
  
  <p>This will keep in top position the rows which have "MY VALUE" in text. But the problem is that when I sort on other column, the "fixed" row is not remaining on top of the table.</p>
  
  <p>Any solutions?   </p>