TablePlus-Windows icon indicating copy to clipboard operation
TablePlus-Windows copied to clipboard

Make the Windows version remember the last filter setting when adding a new filter

Open natesilva opened this issue 4 years ago • 2 comments

Please answer the questions below, it helps us to track the issue.

  1. Which driver are you using and version of it (Ex: PostgreSQL 10.0): MySQL 5.7

  2. Which TablePlus build number are you using (the number on the welcome screen, Ex: build 81): build 182 - Windows

  3. The steps to reproduce this issue:

    1. Open a table view.
    2. Open the Filters header/panel.
    3. Select "Raw SQL" and enter a query like state = 'NY' (or some query that makes sense for your table)
    4. Press the minus (-) button to remove that filter.
    5. Press the plus (+) button to add another filter.

On the Mac, the new filter will have "Raw SQL" already selected (or whichever field/criteria you had used last). This even persists across app restarts.

On Windows, it resets to the first selection criteria, which for my DB tables is usually id Contains.

Feature request:

  • Make the Windows version work like the Mac version.
    • If I remove all the filter criteria, the next time I add a filter criterion it should default to the same setting I used last time, such as Raw SQL.

Use case

I often find myself clicking the filter dropdown and scrolling to the bottom to select "Raw SQL". Or if I am filtering by specific field, like id =, then it keeps defaulting back to Contains and I have to re-select =.

I wish it would remember what I used last time.

natesilva avatar Oct 27 '21 20:10 natesilva

Hi @natesilva thank you for the feedback. However, I could not reproduce the issue. If you press the + button, TablePlus will clone the current filter, it works just the same way as the macOS filters.

huyphams avatar Oct 28 '21 00:10 huyphams

Ah I see, you remove all the filters and then want to keep the last settings.

huyphams avatar Oct 28 '21 00:10 huyphams