User login
Sponsored links
Recent blog posts
- How to resubmit on Integration Broker message with DONE status
- Message cannot be changed. Message referenced in runtime tables (Doc ID 660969.1)
- PeopleSoft Object Type List
- PeopleSoft Data Integrity Error (124,85)
- Unwanted Save Warnings in Display Only Pages
- Breadcrumb SQL to find the Navigation path for the component in the PIA
- Application Designer Index naming convention
- How to create Trigger in DB2
- Emplid increment automatically
- How can we romove multiple duplicate rows of data printing under each Print command in SQR Program?
Delete PeopleSoft Query From the Database
Wed, 07/02/2008 - 7:33pm — Lepa
Of course, deleting by Query Name is not the only available option. So, feel free to modify the function to fit your needs.
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;
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
- Lepa's blog
- 15321 reads
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!
Unanswered Forum Posts
| Title | Under | Posted on |
|---|---|---|
| how to find missing sequence in GRID and print the mising sequence number while saving through peoplecode | PeopleSoft Technical | 09/11/2017 - 4:49am |
| How to add custom process in Paycycle PeopleSoft Accounts payable. | PeopleSoft Technical | 06/07/2017 - 4:39am |
| How to Pass XML String in SOAPDoc Parm | PeopleSoft Technical | 05/16/2017 - 10:35pm |
| Peoplesoft Web PIA installation | PeopleSoft Technical | 03/15/2017 - 2:20am |
Stay updated
CompShack is a user driven Dev2Dev IT community. Developers can ask questions, help answer questions, or just browse code and articles contributed by users. No registration required.
You can register if you want to contribute code samples, share your knowledge at your own blog, and become adored in the community!
About Lepa
Job title
Lead Application Developer
Poll
New forum topics
- PS HCM AWE - Transaction routing to Requestor for approval, when he is the Delegatee by his 1 up Manager
- how to find missing sequence in GRID and print the mising sequence number while saving through peoplecode
- How to add custom process in Paycycle PeopleSoft Accounts payable.
- How to Pass XML String in SOAPDoc Parm
- Send Email Option In Peoplecode
- ORA-01407: Cannot Update ('SYS ADM'.'PS STAGE TMP'.'DEPTID') to NULL
- AppEngine Performance issue
- Peoplesoft Web PIA installation
Recent comments
- PeopleSoft HRMS/HCM to Oracle Fusion HCM cloud conversion made e
6 days 3 hours ago - PeopleSoft HRMS/HCM to Oracle Fusion HCM cloud conversion
6 days 3 hours ago - Re: Displaying * (star) against the mandatory fields in a page
1 week 3 days ago - Re: Tooltip text in Peoplesoft
4 weeks 4 days ago - Re: Search Strings REGEXP_SUBSTR
5 weeks 6 days ago - Re: Scheduling a Process in PeopleCode
6 weeks 5 days ago - Re: Difference Between MsgGet, MessageBox, & MsgGetText ...
6 weeks 6 days ago - Re: Leading Zero Issue in CSV/Excel Formatterd Report
7 weeks 3 days ago - Re: Send Email Option In Peoplecode
13 weeks 4 days ago - Re: Asset Management: AP to AM Load AMPS1000 has some issue.
13 weeks 6 days ago
Comments
Thanks Compshack!!
How and where do you run this function in PeopleSoft?
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
Or you can do that and much more from PeopleTools > Utilities > Administration > Query Administration
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
Post new comment