Deleting Portal User favorites
By Chris Malek | Tue, Jan 4, 2011
Here is a SQL that will delete user portal favorites. You may need this if a user has favorited a component that does not exist or that you no longer want them to favorite because you hide it or removed it from Structure and content.
DELETE PSPRUFDEFN where PORTAL_OBJNAME IN ('xxx', 'yyy');
Article Categories
Author Info
Chris Malek
Chris Malek is a PeopleTools® Technical Consultant with two decades of experience working on PeopleSoft enterprise software projects. He is available for consulting engagements.
About Chris Work with ChrisProduct
PeopleSoft Simple Web Services (SWS)
Do you need a quick way to create web services?
Introducing a small but powerful PeopleSoft bolt-on that makes web services very easy. If you have a SQL statement, you can turn that into a web service in PeopleSoft in a few minutes.
Book
Integration Broker - The Missing Manual
I am in the process of writing a book called "Integration Broker - The Missing Manual" that you can read online.