slow Filter columns

[matejj]

First I have to say that new Filter columns option is great.

The problem is that clicking on filter options Primary key/Unique key/Foreign key freezes Developer for about 20 seconds.
Maybe this is connected to the problem i have in Developer 12. Here clicking on grid after select takes few second to move focus to grid. I disabled Show dictionary info in result grid and that solved the problem in v12.

 

[Marco Kalter]

To obtain some more diagnostic information, can you modify the PL/SQL Developer shortcut and add the DebugSQL parameter? For example:

"C:\Program Files\PLSQL Developer 13\plsqldev.exe" DebugSQL

Reproduce the problem and send me the debug.txt file that is generated in the %APPDATA%\PLSQL Developer 13 directory (e.g. C:\Users\\AppData\Roaming\PLSQL Developer 13).

 

[Claus Pedersen]

I agree, a most useful feature.

One issue though: the filter is cleared each time you press F8.
There is no history on the filter, so you have to type your selection again. This especially an issue if you use e.g. the Auto Refresh feature.
This must be fixed.

I have some further enhancement requests:

• Make the filter work with wildcards or regular expressions.
  Alternatively, make a filter dropdown with options like "Starts with", "Ends with", "Is equal to", "Contains", "Does not contain" with default value "Contains" (like it's working today)
• Make a history dropdown with previously used filters

 

[Marco Kalter]

I have added this to the list of enhancement requests.

 

[Claus Pedersen]

Thank you for the reply.

I think that the issue with clearing the filter each time you press F8 is a bug, so please treat it as such.

Thanks in advance.

 

[matejj]

I sent you debug.txt in PM.

On the side note. In Preferences I have Allow multiple connection unckecked, but in log file it say: Allow Multiple Connections: True.

 

[Claus Pedersen]

Beta 3 solves the issue that the filter was cleared when pressing F8. Thumbs up

There is also now a history dropdown. But I am having trouble figuring out, when the input is saved.
I have the following select: SELECT * FROM user_objects
When I enter e.g. "obj" in the filter field, PLD shows the 5 corresponding columns in the grid. I then enter "tim" in the filter and two columns are shown. This is OK. But when I enter the history, I can not see "obj" or "tim". Sometimes, when I enter a new filter string, the old string is saved, but not always. When I press the three dots and press Apply in the "column filter options" dialog, then my filters are sometimes saved (with entries like Name="qty"). But my 'simple' filters entered directly in the filter line, are not always saved. When is the filter text saved in the history?

Update: it seems that the history is only saved when you leave the text field to enter e.g. the text pane or the data grid. Is this correct?

 

[Marco Kalter]

That is indeed correct. Since the filter is applied immediately as you type, the only appropriate moment to add it to the history is when you leave the filter field.

 

[Claus Pedersen]

Or pressing Enter could also save the filter.

But I get the idea and that explains it.