[BUG] - Filter, number of pages stays the same

[ajpanton]

Describe the bug
When viewing a table (Postgres), the number of pages don't change when I filter by some condition. Even when filtering it down to just one row, the number of pages stays the same. Now, when browsing through the pages, this one single filtered row will randomly disappear and randomly appear on any of those pages.

To Reproduce
Steps to reproduce the behavior:

1. Open a table (Postgres) so large it has multiple pages.
2. Filter by, say, id=2000, which brings the number of rows down to 1.
3. See how the number of scrollable pages at the bottom stays the same.
4. Now click through those pages, and see that row id=2000 randomly show up or disappear, sometimes even on page 1.

Expected behavior

1. Number of pages to correspond with how many items there are even when filtering.
2. Consistent showing of items on each page. This may get fixed by fixing the previous one?

[hkdeman]

Hello hello! Thank you for pointing out the bug and for trying WhoDB!

Another great observation. Will add this to our backlog and update the issue as soon as there is a PR :)