Is it possible to apply this filter?

mpdata

Hello,
I am trying to implement filters in my page from this URL.
https://editor.datatables.net/examples/inline-editing/serverSide.html

How to configure a filter so that when opening the table you get:
- To display for each city in the Office column only a record that has the last date (most recent date) in the Start date column. Then I want to sort them by column Salary.

Filter result:

Thanks.

kthorngren

To display for each city in the Office column only a record that has the last date (most recent date) in the Start date column.

Since you are using server side processing your server script will need to return only the data you want. If you have a SQL like database then maybe this SO thread solution will help you to return the max date for each office.

Then I want to sort them by column Salary.

You can use the order option to set the initial table order.

Kevin

mpdata

Thanks. It was helpful.