Are you missing data in your Insights Dashboards?
by Insights (Kibana) Dashboards provide valuable information to your users … but it only works if ALL the data you think you are sending to Insights has actually arrived …and has been indexed.
Category: PeopleTools
PSQuery Date Math
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
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).
