PeopleTools | Tracing options available to a developer
Tip 044: SQL Decode and Case Statements
SQL | Using the ‘Decode’ and ‘Case’ statements in queries.
Tip 043: IsUserInRole Function
PeopleCode | Using the IsUserInRole Function to check user security
Tip 042: Dynamic SQL Prompts
PeopleTools | Setting up a field prompt based on SQL text created dynamically
Tip 040: Setting Column Labels in Grids
PeopleCode | Changing the label for a column in a grid
Tip 039: Using Population Selection
PeopleTools | Using Population Select on a run control page.
Tip 038: SQL Selects in PeopleCode
PeopleCode | Options to perform a SQL select (including the dreaded SQLExec)
Tip 037: Creating a Microsoft Word document
PeopleCode | Creating a native Microsoft Word document
Tip 036: Introduction to File Layouts
PeopleTools | Defining a file layout and then accessing it in PeopleCode