title: How can I get jQuery DataTables to sort on hidden value, but search on displayed value?
body: <p>I have a simple DataTables grid which contains date columns. I have provided two values for the date in my JSON data set, one for display and one specifically designed so that DataTables can sort it. My web application allows users to choose a bunch of different date formats, so it needs to be flexible.</p>
  
  <p>This is my JSON data that DataTables gets from from the web server via <code>sAjaxSource</code>.</p>
  
  <pre><code>{
    Reports : [
      { Date: { Sort = "20101131133000", Display : "11/31/2010 1:30 PM" } }, 
      { Date: { Sort = "20100912120000", Display : "1200 EST 2010-09-12" } }, 
    ]
  }
  </code></pre>
  
  <p>It is easy to tell DataTables to sort based on the <code>Date.SortValue</code> property and to make the <code>Display</code> property visible to the user by using <code>fnRender()</code>. So this gets me halfway to my goal.</p>
  
  <pre><code>var dataTableConfig = {
    sAjaxSource: "/getreports",
    sAjaxDataProp: "Reports",
    aoColumns: [
      { mDataProp: "User" },
      { mDataProp: "Date.Sort", 
        bSortable: true, 
        sName: "Date", 
        bUseRendered: false, 
        fnRender: function (oObj) {
          return oObj.aData[oObj.oSettings.aoColumns[oObj.iDataColumn].sName].Display;
        }
      }
    ]
  };
  </code></pre>
  
  <p><em><strong>Here's my problem.</em></strong> I want to allow the user to enter a filter (using the built-in filter input that DataTables provides) based on the displayed value, but they cannot.</p>
  
  <p>For example. If a user entered "EST", they would get zero results because datatables filters based on the value specified in <code>mDataProp</code> not based on the value returned from <code>fnRender</code>.</p>
  
  <p>Can anyone help me figure out how to sort AND filter a date column? Thanks.</p>