Tuesday, August 12, 2014

Identifying a Public PS Query

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


SELECT * FROM PSQRYDEFN WHERE OPRID = ' '