whodb icon indicating copy to clipboard operation
whodb copied to clipboard
verified publisher icon clidey

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

Open ajpanton opened this issue 1 year ago • 1 comments

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?

ajpanton avatar Dec 16 '24 09:12 ajpanton

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 :)

hkdeman avatar Dec 19 '24 15:12 hkdeman

Thank you for reporting this issue and sharing the detailed steps. I have tested this in the new UI and can confirm that the problem no longer occurs, the number of pages updates correctly after applying a filter, and rows display consistently. I have also recorded a video as proof of the fix. Since the issue is resolved in the latest version, this can be closed @modelorona .

https://github.com/user-attachments/assets/924b0004-199e-4222-8680-84928a67c53f

AnanyaJhaldiyal avatar Aug 28 '25 18:08 AnanyaJhaldiyal

Thank you for reporting this issue and sharing the detailed steps. I have tested this in the new UI and can confirm that the problem no longer occurs, the number of pages updates correctly after applying a filter, and rows display consistently. I have also recorded a video as proof of the fix. Since the issue is resolved in the latest version, this can be closed @modelorona .

Screen.Recording.2025-08-28.235102.mp4

cool thanks! we can close this issue then once release is out

modelorona avatar Sep 02 '25 12:09 modelorona