Browser Folders for

[Uwe]

Hello,

I want to define my own Browser Folder using a specific where clause. How can I make this apply to the user I choose from the user list?
If I omit the owner in the WHERE clause objects of _all_ users are shown. If I apply 'owner = user' only objects are shown of the user I logged on with.
I would like to use something like 'owner = '.

Is there a way?

Regards
Uwe

 

[Marco Kalter]

A user-defined browser folder where clause can refer to :browser_user and :browser_filter to include the currently selected user and filter. I see this is not documented, which we will fix.

For example: owner = :browser_user

 

[Uwe]

Very nice! Thank you!

 

[Hilarion]

It'd be nice if :browser_user was also usable in browser filter definitions (NULL if "" is selected). It'd require PL/SQL Developer to recognize that this bind variable is used and not apply additional filters for the browser user selected.

For example one of my browser filters is "My objects + SYS objects" which has "where" clause declared as "owner in ( user, 'SYS' )". It worked fine when there was no browser user selection available and works OK now, when "" is selected. If you choose any other option in browser user filter, then either only objects for that user are shown (if you selected current user as "" or by name or selected "SYS") or none are shown (if you chose some other non-sys user).
What I'd like to have is ability to define that filter "where" clause like "owner in ( nvl( :browser_user, user ), 'SYS' )" which would make the filter work as intended (show all objects of selected user plus all objects of SYS user or - when "" is chosen - show all objects of current user and all objects of SYS).