PSQuery Date Math
by PSQuery is a great tool for PeopleSoft ad hoc reporting. But it does have a challenge when it comes to working with Dates.
Use MetaSQL to manipulate dates in PSQuery
Category: PeopleTools
Creating Materialized Views in PeopleTools
Use Materialized Views to improve poor performance of complex SQL Views
PSQuery Record Security
… questions about which roles and permission lists have access to a specific record can be a trip down the multiple rabbit holes.
Search Record Overrides
Overriding the search record allows us to use the same component in different situations without modifying that component.
We can reuse a component for a specific user group with a targeted search record that doesn’t affect that same component with other users by attaching that component to a different menu and overriding the search record there.
IsMenuItemAuthorized?
IsMenuItemAuthorized() is a delivered PeopleCode function that tells us, True or False if the current user has access to a specific page.
Expand your Binds …with PeopleCode
PeopleCode has two little gem functions that expand binds: ExpandBindVar and ExpandSqlBinds.
At first glance, these two functions look similar. A cursory glance at PeopleBooks show that they both expand binds in strings. Even the parameter list is the same (not). But how they are used is two very different situations and are not interchangeable.
PSAdmin.io Conference – 2023
This year, psadmin.conf will be an in-person conference held on May 22-24, 2023 in Minneapolis, MN.
Building a PeopleSoft Image – OCI Marketplace
Great post by Dan Iverson at PSAdmin.IO with a step by step walk through of building a PeopleSoft image in your Oracle Cloud account (OCI).
PeopleTools Object Owner ID
Most PeopleTools objects allow a developer to classify and organize the object by the Owner ID field on the Object’s Properties page. This value doesn’t affect the object and is more Information Only. However, it does help during development and upgrades by providing the developer an idea of where this object is used.