Posts
Getting Run Control and Operator ID in an Application Engine
- Add a State Record not unlike TL_RUNCNTL_AET to the AppEngine.
- Add a SQL Step:
SQL.Fetch: object isn't open on a select
“SQL.Fetch: object isn’t open on a select”
How To Create A Custom Kibana Dashboard
See this attached document which goes through the entire process, step-by-step.
PeopleCode method to move a file
PeopleCode method to move a file using Java
Creating a New Navigation Collection as a New Homepage Tile
How to create a new navigation collection, and add it to a Homepage as a Tile.
Recursive SQL to Generate a List of Dates
This returns all dates for the past year and is an example of a simple SQL recursive CTE or sub-query refactoring, or as I call it a “with statement”.
Recursive CTE View of a Tree
An example of recursive CTE SQL to query a Tree.
How To Migrate Fluid Forms
PeopleSoft doesn’t really give up how to migrate Fluid Forms. There are some posts on Oracle support, but I’ve found some discrepencies. This is a living document on how to migrate them.
The Correct Way to Delete PeopleSoft Fluid Forms
I’ve had immense difficulty tidying up and migrating Fluid Forms. This post is a living document on how to delete unwanted Forms, migrate Forms, and tidy up orphaned rows.
Viewing Images
If doing this often I’d copy the page we are about to go to, and make my own component. This is perfectly good for “one time” however.
PeopleTools Colour Scheme
Instructions and background on the Solarised colour scheme.
Aggregating rows into a list. Oracle SQL.
select listagg(field_name, ', ') within group (order by field_name) from ps_some_table
How to Create Sibling Records in a Stand-alone Rowset
This is not often used, and rather difficult to find any information on.
PeopleCode to Default Effective Sequence
Copy Pasta.
Formatting Names using SQL
You’ve got a list of names and they are all in upper or lower case. How do you format “MCDONALD” to “McDonald”? What about all those Middle Eastern, Asian names?
A Name Formatter for User Description Field
Example of formatting names, where we have a list of first names (sometimes many), a last name (sometimes long), and a short field to fit it all into.
All Records in a Component
SQL for All Records in a Component.
An Application Engine Log File
A nice little extension of the
File
API Object to use it as an Application Engine log file. It can be disabled for performance (writing log files is incredibly slow). Automatically handles running on the client.Consuming a REST Service
The code for calling a REST service is thankfully very simple. There is a much, much longer way to call a REST service where you create Documents, sub Documents, Messages, Service Operations and on and on and on, but this example uses the .ConnectorRequest method found in the
%IntBroker
Class. There is an example and a little more information here in PeopleBooks.A Delivered, PeopleCode Dictionary Object
There is a delivered AppClass that acts as a Dictionary, or Key:Value array.
A Simple REST Call
Two examples of a simple REST call in PeopleCode.
Reading JSON with PeopleCode
Building on the example at Cedar Hills I refactored it into a complex data type of
Animal
, contained in anArray of Animal
:Blank Lines at end of Files
By default, it seems, files created in PeopleCode have an extra blank line at the end. This is because it is using line feed (char 10) and carriage return (char 13).
Get All AppClasses in an AppPackage
This example code creates an array of all AppClasses in an AppPackage. Useful for some patterns that use multiple classes of the same type.
Implementing Full Calendar in PeopleSoft
FullCalendar is an open source jQuery plugin that I really wanted to use in an application I was building. I ended up creating a wrapper for it to be used in PeopleSoft.
How To Download a File From The Server Using PeopleCode
There’s no obvious way to download a file object that is in your code. The
PTFP_FEED:UTILITY:Utility
class has a very handy function for doing exactly this, viewStringAsAttachment.Using IN() in SQL
We can’t combine bind variables and the “IN” clause, but there is another way.
Extending the PeopleCode API
The premise of a class being open for extension, but closed for modification extends (ha) to PeopleCode’s API too. Record, Field, Rowset and the rest of the gang are all open for extension.
About This Blog
After years of fighting with Blogger and WordPress I have finally stumbled across Jekyll and GitHub Pages.
subscribe via RSS