Cannot restrict list to really useful ones

[Maxmix]

Hi,

Just found this wonderful option in the just installed PLSDv10!

However, I cannot make it working (always all db users are displayed).

This query works in SQL Window:
select * from all_users where
exists (select null from zmm.working_users_view zz where zz.username=all_users.username and not_syn_counter>0)

In bold is the text I am trying to enter in the "User selector where clause for sys.all_users view" field.

What could be reason?

 

[Marco Kalter]

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

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

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

 

[Maxmix]

debug.txt has helped. The problem was that the list of users is populated sometimes from ALL_USERS, and sometimes from DBA_USERS.

As soon as I rewrote the predicate as:

username in (select zz.username from zmm.working_users_view zz where not_syn_counter>0)

the filter works like a charm now.