How to remove filter criteria permanently ?

Hi there,

Please clarify on what you mean by "delete permanently". Where does it show up for you after you click on that "X"?

If I click on the X the filter will disappear and it resets the table. However, if I then click on the magnifying glass on the left all the filters come back including the one I just clicked X on. You can now select and use one of the old filters. I want to get rid of all these old filters, permanently. 

From what I see right now: you have to edit the config file manually and delete it there.

AFAIK it used to be possible in the past (at very least for the Find / Find in Path entries) .. but normal shortcuts (e.g. Shift+Del) do nothing right now (related tickets: https://youtrack.jetbrains.com/issue/IDEA-209105 and https://youtrack.jetbrains.com/issue/IDEABKL-7257)

To delete such entries manually:

1. Go to the workspace folder (where IDE keeps local workspace for your projects). On Windows that would be:

 C:\Users\USERNAME\AppData\Roaming\JetBrains\PhpStorm2020.3\workspace

Files there will have namea like 1SI9cIp48fphWJCq6cSqPakTIWf.xml etc.

2. Locate a file for desired project (e.g. sort by most recent date DESC). Make sure that the project is closed in IDE -- important otherwise all changes will be lost (overwritten when you close the project).

Alternatively look for the project ID in PROJECT_ROOT/.idea/workspace.xml file first, look for ```<component name="ProjectId" id="``` string there and then open a file with such ID from the aforementioned path.

3. In that local workspace file, look for ```com.intellij.database.editor.DatabaseTableFileEditorProvider``` text -- it will contain recent searches/filters for DB table viewer. Or just search there for the content that you want to remove.

An example from my test project:

    <entry file="das://f68368fa-2472-423e-af84-50c67636e91c/schema/test_wp_db/table/wp_options">
      <provider selected="true" editor-type-id="com.intellij.database.editor.DatabaseTableFileEditorProvider">
        <state lastOpenedTimestamp="1615507619237" presentationMode="TABLE" projectRestartId="89f053ff-4b7c-4522-ae10-19a6299a7b81" pageSize="500">
          <filtering>
            <filter text="" />
            <filter text="option_name = 'template'" />
          </filtering>
        </state>
      </provider>
    </entry>

In the above the recent filter entry was ```option_name = 'template'```.

Either delete the whole node or just single unwanted entry.