Sort by hidden column, filter by display column

smason

I know I need to use this: https://datatables.net/reference/option/columns.render
but there are no examples on there of what the HTML has to look like? My data tables are not generated by JSON, they are created from a regular HTML table. What attributes do I need to include in my table cells?

smason

I found out that I can just use the data-sort attribute on the <td> element?
Like on the following:

<table>
  <thead>
    <tr>
      <td>Name</td>
      <td>Age</td>
    </tr>
  </thead>
  <tbody>
    <tr>
      <td>John Doe</td>
      <td data-sort="37">2/1/78 (37 years old)</td>
    </tr>
    <tr>
      <td>Jane Doe</td>
      <td data-sort="35">12/1/80 (35 years old)</td>
    </tr>
  </tbody>
</table>

I found the anser here: https://stackoverflow.com/questions/7668047/how-can-i-get-jquery-datatables-to-sort-on-hidden-value-but-search-on-displayed