how to filter a orthogonal data

andreoliveirasilva

Hi, i am new using dataTables, so, i am sorry if this question has a obivious answer. I am using orthogonal data to create my table that contains columns like date and money. i am using render like this:
...
"columnDefs": [ {
render: {
_: "display",
sort: "sort",
filter: "filter",
}, "targets": renderColumn
}],

Its everything working correctly, sorting, displaying and searching. But i am having problem when i try to filter a column of type date, throught a select dropdown list.

I filter all columns using the following command:

• > table.columns(columnName":name").search(valueToFilter).draw();

and it works fine with all columns, except the ones that uses orthogonal data.

my select list has values like: "24/10/2016", "15/09/2016", etc.
and i would like to click one of these values from the list and show only the rows with the date clicked. When i use the search box, i works correctly, but when i try to use the function i mentioned it does not work, and it shows 0 (zero) results.

Does anyone knows how to fix it?

Thank you,

André