Recently I was asked to provide a list of Public PSQueries available in the system.
Upon investigating I found out that OPRID field in PSQRYDEFN would be blank if a PSQuery is public.
So all you have to do is
Upon investigating I found out that OPRID field in PSQRYDEFN would be blank if a PSQuery is public.
So all you have to do is
SELECT * FROM PSQRYDEFN WHERE OPRID = ' '