Ask Question
Help Others
Home › Blogs › Lepa's blog

Delete PeopleSoft Query From the Database

Wed, 07/02/2008 - 7:33pm — Lepa
Your rating: None Average: 2.7 (3 votes)

There could be different reasons why a PeopleSoft developer would like to delete a query from the database. Upgrade clean up would probably be the most common one. Here is a function you can use to get you started.

Function DeleteQuery(&sQueryName As string)
   SQLExec("DELETE FROM PSQRYDEFN WHERE QRYNAME=:1", &sQueryName);
   SQLExec("DELETE FROM PSQRYSELECT WHERE QRYNAME=:1", &sQueryName);
   SQLExec("DELETE FROM PSQRYRECORD WHERE QRYNAME=:1", &sQueryName);
   SQLExec("DELETE FROM PSQRYFIELD WHERE QRYNAME=:1", &sQueryName);
   SQLExec("DELETE FROM PSQRYFIELDLANG WHERE QRYNAME=:1", &sQueryName);
   SQLExec("DELETE FROM PSQRYCRITERIA WHERE QRYNAME=:1", &sQueryName);
   SQLExec("DELETE FROM PSQRYEXPR WHERE QRYNAME=:1", &sQueryName);
   SQLExec("DELETE FROM PSQRYBIND WHERE QRYNAME=:1", &sQueryName);
   SQLExec("DELETE FROM PSQRYBINDLANG WHERE QRYNAME=:1", &sQueryName);
   /*Below tables are not availabe in older PS versions*/
   SQLExec("DELETE FROM PSQRYSTATS  WHERE QRYNAME=:1", &sQueryName);
   SQLExec("DELETE FROM PSQRYEXECLOG WHERE QRYNAME=:1", &sQueryName);
   SQLExec("DELETE FROM PSQRYFAVORITES WHERE QRYNAME=:1", &sQueryName);
End-Function;

Of course, deleting by Query Name is not the only available option. So, feel free to modify the function to fit your needs.

Bookmark/Search this post with
  • Buzz Up!
  • del.icio.us
  • Digg
  • Facebook
  • Google Buzz
  • Reddit
  • StumbleUpon
  • Technorati
  • Twitter
  • Yahoo
Please try to help out with unanswered topics on the forum. Chances are you have had the same issue/question some time in your IT career!

Comments

Have a question? Please ask it on the forum instead.
Thu, 07/03/2008 - 9:00am
#1
Guest's picture
Guest (not verified)
Re: Delete PeopleSoft Query From the Database

Thanks Compshack!!

How and where do you run this function in PeopleSoft?

Top
Thu, 07/03/2008 - 10:22am
#2
Lepa's picture
Lepa
User offline. Last seen 31 weeks 1 day ago. Offline
Joined: 06/23/2008
Posts: 591
Re: Delete PeopleSoft Query From the Database

Well, that depends on what you want to do. You can use the function behind a link on a page or you can call it from an Application Engine to delete queries in batch mode.

Give back to the community and help it grow!
* Help with unanswered forum questions and issues
* Register or login to share your knowledge at your own blog

Top
Tue, 08/19/2008 - 12:51pm
#3
Santis's picture
Santis (not verified)
Re: Delete PeopleSoft Query From the Database

Or you can do that and much more from PeopleTools > Utilities > Administration > Query Administration

Top
Tue, 08/19/2008 - 1:14pm
#4
Lepa's picture
Lepa
User offline. Last seen 31 weeks 1 day ago. Offline
Joined: 06/23/2008
Posts: 591
Re: Delete PeopleSoft Query From the Database

True if you are doing that online and not problematically. Thanks for the tip though, truly appreciate your feedback.

Give back to the community and help it grow!
* Help with unanswered forum questions and issues
* Register or login to share your knowledge at your own blog

Top