PeopleSoft - Query PSQRYDEFN

How to check if a Query is Public or Specific to user?
Select * from psqrydefn where qryname = 'your query'
From the above select, is OPRID column blanks? If it is not, then it is not a public query and only the operator listed for the row can see the query. Make it a public query and everyone can see it.
To find out all of the records being used in the Query use the below query...
SELECT * FROM PSQRYRECORD WHERE QRYNAME = 'name of query trying to find' ;

 

0 comments: