Recent Activity
PeopleCode
AddToDate
AddToDate is a PeopleCode built-in function for manipulating a date in PeopleCode. You can use i...
An Object of class APIObject failed to deserialize
You might see this error in your .tracesql logs. Apparently this happens if you are performing p...
PeopleCode Statement Number
Most errors and logs will point you to a particular PeopleCode statement number. But how do you f...
Page Data is Inconsistent with Database
During development you may come across the following error: Page data is inconsistent with datab...
Web Server URI
If you need to retrieve the web server URI for rending images in HTML emails try this method Get...
Generate Formatted XML
PeopleCode includes a class library for working with XML documents called XMLDoc. There are a nu...
Stop PeopleCode Processing for Debugging
A blunt, but useful method for debugging PeopleCode is to use the inbuilt Error function to stop ...
SearchClear
You can use the SearchClear() method which is part of the Field class to clear search values on a...
Remove HTML Tags with Regex
The following is a rudimentary example of how you can remove HTML tags via PeopleCode using Regex...
Pausing Execution
There isn't a delivered way to pause the execution of PeopleCode. However, there are two alterna...
GetImageURL
GetImageURL is a nifty PeopleCode iScript (Response class) method that returns a URL for an image...
Default a Search Field Value
This is a simple trick but can be easy to forget. If you want to use the default value of your fi...
Searching PeopleCode for Message Catalog Entries
One of the best reasons to export PeopleCode to a file is so that you can perform a search on it ...
Session Class
The Session Class is the root of the API classes provided by PeopleSoft. It provides access to co...
WriteToLog
Next time you need to do some in-line PeopleCode debugging, rather than the traditional approach ...
Setting the value of Reserved Field Names
If you are trying to set the value of a field through PeopleCode and that field happens to be NAM...
Rowset Sorting
The Rowset class includes a Sort method which can be used to sort items in the Rowset by one or m...
Standalone Rowset
In PeopleCode a standalone rowset is an independent rowset object not associated with the compone...
Hide SQL Errors with Try Catch Blocks
If you are working on any PeopleCode that involves inserting or updating data in a table, and you...
Check if a Directory Exists
How do you check if a directory exists on the application server? The following code is one way ...
Think Time Functions
Think-time functions are PeopleCode functions that suspend PeopleSoft processing to wait for an e...
Export PeopleCode to File
The Application Designer Find In... function allows you to export PeopleCode search results to a ...
Process Run Validation
You might have the need to perform some last minute validation before a user triggers a run contr...
Creating Cookies
The documentation in PeopleBooks regarding the Cookie class is a little unclear. Here's a simple ...
Required Fields Cue
If you are using PeopleCode to perform validation on a field that has to be entered by the user, ...
Showing and Hiding a Grid
The Rowset class contains two methods that can be used to show and hide all rows: ShowAllRows()...
Record Snapshot
The following is a bit of PeopleCode I came up with to get a snapshot of the contents of a given ...
Creating an Unique File Name
If you are working with files or file attachments in PeopleCode, you will typically want to creat...
The at @ Meta Operator
The @ (at) meta operator is a very useful meta programming operator in PeopleCode. When applied, ...
FieldChange Event Does Not Fire
A FieldChange PeopleCode event may not fire on a field if the component is set to deferred proces...
Dynamic From SQL
This is how you can use a dynamic table name in the from clause of SQL called by PeopleCode. Fir...
Open New Window PeopleCode
Sometimes you need to open a new window to a PeopleSoft page and when that windows opens you lose...
Creating Excel Files
With SQR, you were always limited to writing CSV files, unless you had some sort of overpriced th...
Data Being Added Conflicts with Existing Data
While developing a page with multiple scrolls levels, and especially when using a grid, you may g...
URLs to Hyperlinks
As a follow on to the Email Mailto Links Regex article, this article gives an example of a People...
Viewing Component Level PeopleCode
There are a few ways to view PeopleCode at the component level (component, component-record, comp...
Setting a Date to Null in PeopleCode
To set a date to null in PeopleCode either use the SetDefault() function (deprecated) or the SetD...
Getting current time in HHMMSS Format
Here's how to get the current time in the format HHMMSS from the current time: Local &strCur...
Copying Rowsets
I find that you often need to create and manipulate standalone rowsets. Sometimes you can get the...
Modals
Secondary pages are modal in that they require some sort of user intervention (e.g. clicking an O...
Effective Sequence PeopleCode
There are cases where you'll need to automatically increment the value of an effective sequence (...
Commenting Tips
This article provides some advice about commenting code. Its not specific to PeopleSoft, but the ...
Convert Emails to MailTo Links
The following PeopleCode function finds email addresses (using a regular expression) and encloses...
Transfer
Transfer is one of those PeopleCode functions that needs more explanation and some better example...
Tracing and Debugging
In the set trace flags on the signon page use Each Statement or you can configure this through: ...
Encryption
The following functions are provided as built-in functions in PeopleCode for encryption/decryptio...
Multilevel Rowsets
A multi-level rowset is one that has a parent-child-grandchild relationship structure. Such rowse...