Query keeps pagination when using filters

[RazmikSaghoyan]

• Laravel Version: 7
• Nova Version: 3
• PHP Version: 7.2

Steps to Reproduce:

• Open a resource
• Go to the second page
• Use a filter where you have less than the per-page limit but you know you should have results
• You have an empty table
• When you use the filter, the query keeps the limit 26 offset 25 from the pagination and returns an empty table even if you have results

[jbrooksuk]

@davidhemphill I think we've discussed this issue previously, but I can't remember the decision we made?

[stale]

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions.

[navidnadali]

Hi @jbrooksuk @davidhemphill @crynobone is there any plans for this? I think due to our use case we are coming up against it a lot where filtering shows an empty table due to offset not being reset

[crynobone]

@navidnadali I marked it as discussion so that we can discussed what's the suitable "Expected Behavior" for this issue, if it's something that the team comfortable with then we could come out with a solution.