How to Make a Private PeopleSoft Query to Public using Update SQL

How to Make a Private PeopleSoft Query to Public using Update SQL

How to Make a Private PeopleSoft Query to Public using Update SQL. You can update Oprid is blank of all record relation

UPDATE PSQRYBIND SET OPRID = ‘ ‘WHERE OPRID = ‘OLD_USER’ AND QRYNAME = ‘NEW_USER’;
UPDATE PSQRYBINDLANG SET OPRID = ‘ ‘WHERE OPRID = ‘OLD_USER’ AND QRYNAME = ‘NEW_USER’;
UPDATE PSQRYCRITERIA SET OPRID = ‘ ‘WHERE OPRID = ‘OLD_USER’ AND QRYNAME = ‘NEW_USER’;
UPDATE PSQRYDEFN SET OPRID = ‘ ‘WHERE OPRID = ‘OLD_USER’ AND QRYNAME = ‘NEW_USER’;
UPDATE PSQRYDEFNLANG SET OPRID = ‘ ‘WHERE OPRID = ‘OLD_USER’ AND QRYNAME = ‘NEW_USER’;
UPDATE PSQRYEXPR SET OPRID = ‘ ‘WHERE OPRID = ‘OLD_USER’ AND QRYNAME = ‘NEW_USER’;
UPDATE PSQRYFIELD SET OPRID = ‘ ‘WHERE OPRID = ‘OLD_USER’ AND QRYNAME = ‘NEW_USER’;
UPDATE PSQRYFIELDLANG SET OPRID = ‘ ‘WHERE OPRID = ‘OLD_USER’ AND QRYNAME = ‘NEW_USER’;
UPDATE PSQRYRECORD SET OPRID = ‘ ‘WHERE OPRID = ‘OLD_USER’ AND QRYNAME = ‘NEW_USER’;
UPDATE PSQRYSELECT SET OPRID = ‘ ‘WHERE OPRID = ‘OLD_USER’ AND QRYNAME = ‘NEW_USER’;

More suggestion:
– You Create a PUBLIC ps query by clone of the PRIVATE ps query
– Rename ps query from PRIVATE or PUBLIC query
– Delete a query

Reference:https://hexaware.com/blogs/how-to-make-a-peoplesoft-private-query-public/