Recently Updated Pages
SMTP Failed on Process Scheduler
If you are seeing messages like this in your message log when running a process through the proce...
Getting current time in HHMMSS Format
Here's how to get the current time in the format HHMMSS from the current time: Local &strCur...
Setting a Date to Null in PeopleCode
To set a date to null in PeopleCode either use the SetDefault() function (deprecated) or the SetD...
Configuration Manager Command Line
Configuration manager (pscfg.exe) includes a number of command line options. These can be display...
Viewing Component Level PeopleCode
There are a few ways to view PeopleCode at the component level (component, component-record, comp...
Redirect To Login Page
When you access the root level of your PeopleSoft site, you normally get a web server message tha...
Dates in SQR
There are two main ways to store and use dates in SQR: Store them as a character string in a st...
URLs to Hyperlinks
As a follow on to the Email Mailto Links Regex article, this article gives an example of a People...
Bootstrap Mode
Bootstrap mode uses a database user to login to the database. In this mode Datamover can perform ...
The Connect ID
The connect ID is used from PeopleTools 8+ and was implemented to replace the need for PeopleSoft...
Recruitment Verity Search
Recruitment verity search involves running a number of application engine programs (e.g. HRS_SRCH...
Filtering Upgrade Options
App designer allows you to filter the upgrade options for your project definitions. To use this f...
Data Being Added Conflicts with Existing Data
While developing a page with multiple scrolls levels, and especially when using a grid, you may g...
Creating Excel Files
With SQR, you were always limited to writing CSV files, unless you had some sort of overpriced th...
Open New Window PeopleCode
Sometimes you need to open a new window to a PeopleSoft page and when that windows opens you lose...
Long Running Processes
The following query can be used to identify any long running processes from the process request t...
Dynamic From SQL
This is how you can use a dynamic table name in the from clause of SQL called by PeopleCode. Fir...
Data Mover Script Templates
Data mover is probably the best way to export and import data between PeopleSoft databases and th...
FieldChange Event Does Not Fire
A FieldChange PeopleCode event may not fire on a field if the component is set to deferred proces...
The at @ Meta Operator
The @ (at) meta operator is a very useful meta programming operator in PeopleCode. When applied, ...