Request: explain plan tree view cells selectable

[koja]

It would save me a lot of time if the cells in the tree-view of the explain plan result pane would be individually selectable.
The html tab stays blank btw. (Bug?)

 

[Marco Kalter]

What exactly do you mean by "individually selectable"?

The HTML page seems to work fine. 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 15 Beta\plsqldev.exe" DebugSQL

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

 

[Claus Pedersen]

I can reproduce the blank HTML page in beta 5. I am using dark theme, style=Glow.
Mail sent to support.

 

[koja]

Hi Marco, if I "select" a cell in the explain plan tree view and right click I have the option to copy, but that copies the entire explain plan. I'd like to be able to copy an index name, table name or filter predicates.

If I switch the tab from tree to HTML, the html stays empty and stays empty when I re-execute the explain plan. Tabs text and XML display information in both cases.

 

[Marco Kalter]

Okay, thanks for clarifying. We're looking into the blank HTML plan.

 

[Claus Pedersen]

From the bug fix list in beta 7:

Edge html viewer did not work in Plan Window and Test Window

In the explain plan window, I still get a blank (all-white) HTML tab page.
Should the quoted fix for beta 7 have fixed the explain plan HTML tab? In that case, it still doesn't work...

I am using beta 7, dark theme, style=Dark Outlet Media

 

[Marco Kalter]

This works fine for me in Beta 7 in dark mode, both 32 bit and 64 bit. Can you let me know if you have the "Use internal HTML viewer" option disabled (Preferences > User Interface > Options)?

 

[Claus Pedersen]

The option Use internal HTML viewer is disabled. Should I use the Install MS Edge viewer button? I already have Edge and Edge Webview installed.

 

[fraenkg]

I can confirm the behavior. If the option "Use internal HTML viewer" is switched off, an empty HTML tab is shown (all white). Even if the MS Edge - Ruintime is installed. At least the installer tells me that WebView2 is already there for all users.
Everything works as expected using the internal viewer.

 

[Marco Kalter]

We'll investigate.

 

[Marco Kalter]

Can you let me know if the Report Window displays result sets, or if this is also blank for you?

 

[fraenkg]

In contrast to the HTML output for "Explain Plan", result data is shown in the report. However, these are displayed in black and white and dark mode is not selected.
The display of the results of a report window is independent of the "Use internal HTML viewer" setting. However, the type of representation changes somewhat (different font?)

 

[Marco Kalter]

This is exactly the problem we fixed in Beta 7. Can you go to Help > About and check if the version is 15.0.0.2047?

 

[fraenkg]

The version I'm testing with is (15.0.0.2047) Beta (64 bit) on Windows 10 Pro 21H1

 

[Marco Kalter]

We'll have a fix available for this in Beta 8 tomorrow.

 

[Claus Pedersen]

Solved in beta 8