Is it possible to apply this filter?

Is it possible to apply this filter?

mpdatampdata Posts: 10Questions: 2Answers: 1

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.

This question has an accepted answers - jump to answer

Answers

  • kthorngrenkthorngren Posts: 20,149Questions: 26Answers: 4,736
    Answer ✓

    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

  • mpdatampdata Posts: 10Questions: 2Answers: 1

    Thanks. It was helpful.

This discussion has been closed.