Recently Updated Pages
Resolve Meta-SQL
Meta-SQL is really handy, it lets you write database independent SQL and there are some really ni...
Deleting Definitions
Occasionally you may create definitions in your development environment that you discover you no ...
Automatic Login
As a developer you need to sign in to application designer a LOT. Unless you have single sign on...
Getting the Current Environment
For security and consistency you should wrap code that is environment specific around logic that...
Writing a Date Expression
The following example returns the processing time for a process/job in the process request table....
Tracing and Debugging
In the set trace flags on the signon page use Each Statement or you can configure this through: ...
Tracing and Debugging
You can use the -TRACE option to trace the SQL executed by an application engine program. This ca...
Processes Stuck at Queued
There are a number of reasons why a process might be stuck at queued. The most obvious is that t...
Suppressing Files from the Report Repository
I once wrote an application engine to extract photographs from the PeopleSoft database (BLOBs) an...
Process Run Status
In the PeopleTools look at the translates on the field RUNSTATUS or use the query. select FIELDV...
Active Processes
Ever wondered where the active processes value on the server list tab comes from? Well it actual...
Only Application Engine Programs Stuck at Queued
You may find that only application engine programs are stuck at queued while other processes (SQR...
Message Catalog
The PeopleSoft message catalog (or catalogue) is used to store errors, warnings and information m...
Portal Registry
The portal registry is collective term used to describe the online navigational structure of the ...
State Records
This article goes through a basic example of how to populate data in an application state record....
Transfer
Transfer is one of those PeopleCode functions that needs more explanation and some better example...
Users with Recurrences
It can be quite useful to know which users have recurrences configured in the process monitor. Th...
Convert Emails to MailTo Links
The following PeopleCode function finds email addresses (using a regular expression) and encloses...
Commenting Tips
This article provides some advice about commenting code. Its not specific to PeopleSoft, but the ...
Dynamic Roles with PeopleCode Rule
Dynamic roles can be assigned using query rules, PeopleCode rules or directory rules. Using Peop...