How to make filter records show in the same page which belong to other pages
Im using a grid with filter and pagination.
When i filter on any column, it only shows the filtered records in the current page. I have to click next on the pagination every time to navigate to the next pages and see the filtered records in the 2nd,3rd...etc pages. I'm wanting to display all the filtered records as do we show the normal records. I dont have to navigate to each of the pages to see a single or two matched records in each pages. Instead show them in the current page as much they can accomodate in the page size.