Filter My Invalid objects + Triggers folder

[Buzz_ss]

Hello

I have found little issue in object browser.

Reproduce:
1)Choose "My Invalid objects" in filter combobox.
2)Try expand folder "Triggers"

In this case I receive error :
"ORA-00918: column ambiguously defined".

Now in "where clause" for "My Invalid objects" it is written :

owner = user
and status = 'INVALID'

How can I change this definition for fix this issue?

Thanks

 

[Marco Kalter]

We'll fix this!

To fix this you can start PL/SQL Developer without connecting, go to Configure > Object Browser Filters, select the "My invalid objects" filter, and change "status" to "o.status".

 

[fyzm7357]

Just noticed this is still an issue (or reappeared) in 15.0.4. The workaround Marco provided still works.

 

[Marco Kalter]

We'll fix it for 15.0.5!

Correction: it's already fixed, but the fix will not help for pre-existing filters. It will only help for new PL/SQL Developer users.