Query

Managing PS Queries

There is a way to delete and rename queries as well as to change them from private to public quer...

Query Statistics

PeopleSoft provides the ability to track query statistics for PeopleSoft Queries such as the numb...

Find Custom PeopleSoft Queries

The following SQL identifies custom queries created in your system from the PSQRYDEFN PeopleTools...

Embedded SQL in PeopleSoft Query

Turns out that you can embed SQL into your PeopleSoft Query using the Meta-SQL operator, %Sql. He...

Writing a Date Expression

The following example returns the processing time for a process/job in the process request table....