Print Thread
Filter My Invalid objects + Triggers folder
#61638 05/15/20 09:21 AM
Joined: Jun 2018
Posts: 46
Ukraine, Odessa
B
Buzz_ss Offline OP
Member
OP Offline
Member
B
Joined: Jun 2018
Posts: 46
Ukraine, Odessa
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 :
[quote]owner = user
and status = 'INVALID' [/quote]

How can I change this definition for fix this issue?

Thanks


Sergiy Buzadzhi
Re: Filter My Invalid objects + Triggers folder
Buzz_ss #61639 05/15/20 02:34 PM
Joined: Aug 1999
Posts: 22,220
Member
Offline
Member
Joined: Aug 1999
Posts: 22,220
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".


Marco Kalter
Allround Automations
Re: Filter My Invalid objects + Triggers folder
Buzz_ss #65299 01/23/24 06:27 PM
Joined: Aug 2009
Posts: 18
Frisco, TX
Member
Offline
Member
Joined: Aug 2009
Posts: 18
Frisco, TX
Just noticed this is still an issue (or reappeared) in 15.0.4. The workaround Marco provided still works.

Re: Filter My Invalid objects + Triggers folder
Buzz_ss #65301 01/24/24 10:31 AM
Joined: Aug 1999
Posts: 22,220
Member
Offline
Member
Joined: Aug 1999
Posts: 22,220
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.

Last edited by Marco Kalter; 01/24/24 10:36 AM.

Marco Kalter
Allround Automations

Moderated by  support 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.090s Queries: 14 (0.038s) Memory: 2.5086 MB (Peak: 3.0420 MB) Data Comp: Off Server Time: 2024-05-17 07:20:20 UTC
Valid HTML 5 and Valid CSS