Table of Contents

• Title and Copyright Information
• Preface
  • Audience
  • Dedication
  • Related Documents
  • Conventions
  • About the Author
• Introduction
  • Browser-Based Enterprise App Development
  • Model-Driven, Direct Data Access
  • Extensible, Powerful Components
  • Responsive, Polished User Interface
  • Complete Application Platform
  • Open, Agent-Ready APEXlang
  • Spec-Driven App Scaffolding
  • Pricing and Deployment Options
  • Active, Helpful Community
  • App Development as a Service
  • Learning Resources and Free Workspaces
• Working with Local Data
  • Database Concepts Primer
    • Database Tables
    • Structured Query Language (SQL)
      • Basic SQL Statements
      • SQL Mentor at Your Side
    • Database Views, Triggers, and Packages
      • Database Views
      • Database Triggers
      • Database Packages
  • Working with Sample Data
  • Installing a Sample Dataset
  • Importing Data from a File
  • Creating Data Models with Quick SQL
  • Creating a Data Model Using Natural Language
• Simplifying User Experience Design
  • Starting a New Application
  • Creating Pages Quickly
  • Working in Page Designer
    • Key Page Designer Areas
      • Rendering, Layout, and Property Editor
      • Configuring Settings with Property Editor
      • Configuring Dynamic Behavior
      • Validation, Processing, and Branching
      • Searching Your Page
      • Help on Any Setting at Your Fingertips
    • Page Layout Based on Template with Slots
    • Adding Regions in Page Designer
    • Adding Items in Page Designer
  • Running and Iteratively Editing Pages
  • Adding Interactivity to Pages
  • Universal Theme Design System
    • Theme Styles
    • Universal Theme Reference App
    • The Role HTML and CSS Play to Format Data
  • Report Columns and Form Items
    • Configuring Report Region Columns
    • Synchronizing Column Changes
    • Deleting or Commenting Out Columns
    • Page Items in a Form Region
    • Flexible Form Page Item Layout
  • Cascading, List-Driven Items
    • List-Driven Items Available
    • Defining the List of Values
      • Defining a Local List of Values
      • Additional Shared LOV Features
      • Converting Local LOVs to Shared
    • Configuring Cascading Lists
  • Simple Layout for Any Screen Size
    • Flexible Grid of Columns and Rows
    • Templates and Options Set Look and Feel
      • Page Template Sets the Scene
      • Region Template Styles a Section
      • Item Template Controls the Label
    • Nest Regions to Create Any Layout
  • Launching Like Native Apps
• Referencing Data Values in Pages
  • Using Data Values in HTML Expressions
  • Using Data Values in Template Directives
  • Directives Reference in Your Dock
  • Using the Context-Sensitive Help Tab
  • Using Data Values in SQL and PL/SQL
    • Working with Page and App Data Values
    • Working with Column Data Values
    • Values Bind as Strings
      • Working with Data Values as Numbers
      • Working with Data Values as Dates
      • Working with Delimited Values
        • Working with Delimited Number Values
        • Working with Delimited String Values
    • Using Data Values in Named Program Units
    • Configure Items to Submit and Return
• Visualizing and Analyzing Data
  • Listing Data with Classic Reports
  • Personalizable Interactive Reports
  • Flexibly Styling and Acting on Data
  • Info Tiles Using Cards
  • Info at a Glance with Charts & Dashboards
    • Choosing a Chart Type
    • Defining Chart Series
    • Including Related Data on a Chart
  • Showing Data on Maps
    • Choosing a Map Layer Type
    • Adding a Layer of Points
    • Conveying Quantities with a Heat Map
    • Simplifying Points and Distance
    • Distance from a Point of Reference
  • Placing Events on a Calendar
    • Configuring a Basic Calendar
    • Adding Create and Edit Links
    • Changing Events with Drag and Drop
    • Joining In Additional Info Using a View
    • Enhancing Event Display
  • Exploring Hierarchical Data in a Tree
    • Configuring a Basic Tree Display
    • Tracking and Remembering Selection
    • Adding Icons to the Tree
    • Parent/Child Data in a Tree
  • Dynamically Formatting Data
    • Generating HTML Tags to Present Data
    • Using CSS for Styling
    • Referencing Page Item Values
• Enhancing Search for End-Users
  • Narrowing a Search Using Facet Filters
    • Defining Your Facets
    • Configuring Range Facets
    • Behavior of Multiple Selections
    • Counts, Dependency, and Charts
    • Working with Multi-Value Columns
    • Displaying Facets in Add Filter Dialog
    • Finding Text Across Columns
    • Showing Filter Chips and Total Row Count
  • More Space for Results with Smart Filters
    • Defining Your Filters
    • Smart Filters User Experience
    • Configuring Suggestions
    • Even More Space for Search Results
  • Unified Search Results Across Sources
    • Defining a Search Configuration
    • Using Search Configurations
    • Search Results Formatting Options
      • Custom Search Region Row Template
      • Custom Search Configuration Template
  • Showing Search Results in Other Regions
    • Custom Unified Search Experience
    • Showing Filtered Data in Another Region
      • Getting Filtered Data Primary Keys
      • Using Filtered Data Primary Keys
      • Refreshing the Target Region
  • Using Page Items for Query by Example
    • Using Null Display Value
    • Filtering on a Page Item’s Value
    • Filtering on a Multi-Selection Page Item
    • Optimal Approach to Query by Example
    • Disabling Warn on Unsaved Changes
• Adding Functionality with Plug-ins
  • Reusable Components Using HTML Skills
    • Template Component Overview
    • Custom Attributes for Data and Settings
    • Slots Enable Component Composition
    • Applying Template Using Directives
    • Controlling Component Availability
    • Templates Comprising the Component
    • Presenting Grouped Data
    • Configuring Pagination Support
    • Enabling Row Selection
    • Attribute Scopes and Availability to Templates
    • Action Positions and Action Templates
    • Defining Files and File URLs to Load
  • Using a Plug-in from apex.world
    • Tracking Employee Training Status
    • Downloading and Importing a Plug-in
    • Configuring the Kanban Plug-in
• Understanding Page Flow & Session State
  • Navigating to Business Functions
  • App Options in the Navigation Bar
  • Configuring a Wizard Page Flow
    • Creating a Multi-Step Wizard
    • Multi-Step Wizard in Page Designer
    • Shared List Defines Wizard Pages
    • Branches Link Pages to Define Flows
    • Render, Submit, Branch, Repeat
      • Wizard Example Page Lifecycle
      • Computing Values on Render or Submit
      • Validating Submitted Data
      • Custom Processing on Render or Submit
      • Best Practice Use of Invoke API
      • Making Almost Any Element Conditional
  • Additional Page Flow Features
    • Understanding AJAX and Redirect
    • Breadcrumbs Visualize Drilldown Path
    • Modal Dialogs and Drawers
  • Understanding Session State Management
    • Use Cases for Temporary Storage
    • Session Context for Temporary Values
    • How APEX Manages User Session State
    • User-Specific Temporary Storage
    • Clearing Session State
      • Clearing State with Link Target Settings
      • Clearing State with a Page Process
    • Application Items
    • Using Temporary Collections
      • Key Collections Concepts
      • Tips for Maintainable Collection Use
    • Temporary Files
    • Inspecting Session State for Debugging
  • Studying a List and Edit Flow
    • Creating List and Edit Pages
    • Running the List and Edit Pages
    • Linking to the Edit Page
    • Retrieving Existing Row by Primary Key
    • Memory Only Storage for Form Page Items
    • Saving Changes with a Page Process
    • Conditional Database Action Buttons
    • Refreshing List On Dialog Close
• Editing Data in a Grid
  • Getting to Know the Interactive Grid
  • Editing Collection Data with a Grid
  • Understanding and Customizing Grid Behavior
• Working with Master/Detail Data
  • Reviewing Master/Detail Wizard Patterns
  • Configuring Master/Detail Grids
  • Showing Master/Detail Data Side by Side
  • Drilling Down to Edit Master and Details
• Controlling Access with Users and Roles
  • Requiring Authenticated Access to a Page
  • Authenticating Access with APEX Accounts
  • Assigning Users to Roles
  • Shaping Experience with Rules and Roles
    • Declaring Authorization Scheme Rules
    • Authorizing Menu Access
    • Authorizing Page Access
    • Authorizing Page Item or Column Access
    • Authorizing Button Access
    • Authorizing Edit Link Column Access
    • Experiencing Authorization in Action
  • Enabling Row-Level Data Security Policy
    • Using SQL and PL/SQL Authorization Rules
      • Defining Authorization Rule with SQL
      • Using PL/SQL for an Authorization Rule
    • Enabling Row-Level Data Security
      • Ensuring Execute Privilege on DBMS_RLS
      • Defining the Security Policy Function
      • Adding and Enabling the Security Policy
      • Referencing Other Context Information
  • Refining Salary Review with Data Security
    • Switching to Data Security-Enabled View
    • Driving Read-Only with Authorization Rule
    • Adjusting Salary Review Page Access
    • Enabling Salary Review Menu for Managers
    • Testing Enhanced Salary Review Page
  • Integrating an External Identity Provider
    • Defining Users in an IAM Domain
    • Creating Groups in an IAM Domain
    • Assigning IAM Domain Users to Groups
    • Configuring Confidential App for APEX
    • Defining Credential for Identity Provider
    • Authenticating with an External Provider
    • Enabling Groups in Post-Auth Procedure
    • Sourcing App Groups from Custom Code
    • Switching Authorization Rules to Custom
    • Making Social Sign-in the Current Scheme
    • Experiencing External Identity Provider
  • Exploring Context for Authorization Rules
• Applying Artificial Intelligence
  • Configuring a Generative AI Service
  • Exploring Data with Natural Language
  • Defining an Agent to Achieve a Goal
  • Creating an Agent-Driven Chatbot
  • Generating Text to Save Users Time
  • Finding by Meaning with Vector Search
• Integrating Remote Data
  • Using Remote Oracle and MySQL Data
    • Referencing a REST-Enabled SQL Service
    • REST-Enabled SQL Service URL
    • Using a REST-Enabled SQL Service
  • Configuring Secure Web Credentials
  • Using REST APIs as Data Sources
    • Using a Simple HTTP REST Data Source
    • Service URL Uses Remote Server
    • Data Profile Helps Turn JSON Into Rows
    • Retrieving Remote Data Page by Page
    • REST Operations and Database Actions
    • Configuring a Request Body Template
    • Supply and Return Values with Parameters
  • Invoking a REST Operation Declaratively
  • Using REST APIs in Code
    • Processing REST Source Rows in Code
      • Querying REST Source Rows in Code
      • Modifying REST Source Rows in Code
        • Inserting a REST Source Row in Code
        • Updating a REST Source Row in Code
        • Deleting a REST Source Row in Code
    • Invoking a REST Operation Programmatically
      • Configuring REST Source for Invocation
      • Invoking REST Operation in Code
    • Calling REST APIs Without a Data Source
  • Extra Fusion Apps, ORDS, OData Features
  • Additional REST Data Source Features
    • Caching a GET Operation’s Response
    • Synchronizing Data Locally
    • Adding Computed Data Profile Columns
    • Configuring Default Filtering and Sorting
    • Filter, Sort, Join, or Aggregate Remote Data
      • Understanding the JSON_TABLE Query
      • Locally Filtering and Sorting Remote Data
      • Using Custom SQL Involving Remote Data
    • Creating a Custom REST Source Plug-in
  • Debugging REST API Errors
• Exposing APIs for Integration
  • Reviewing Action Items API Requirements
    • Exploring Action Item Teams Example
    • Understanding the Integration Scenario
  • Reviewing REST API Basics
    • Reviewing HTTP Methods for REST APIs
    • Inspecting JSON Syntax
    • Constructing JSON in SQL
    • Working with JSON in PL/SQL
      • Parsing JSON in PL/SQL
      • Treating an Element More Specifically
      • Constructing JSON in PL/SQL
      • Serializing JSON in PL/SQL
  • Planning Your ORDS Service Module
    • Choosing a Schema Alias
    • Identifying URL Templates in a Module
    • Choosing GET Handlers to Read Data
    • Creating a View for GET Handlers
  • Using SQL Developer Web REST Designer
    • Accessing SQL Developer Web REST Designer
    • Navigating ORDS Service Definitions
  • Creating and Testing Read-Only APIs
    • Defining a Read-Only Collection Query
    • Testing Handler with curl or Postman
    • Filtering/Paging Collection Query Endpoints
    • Configuring a Collection Item Handler
  • Enforcing Business Logic in REST APIs
    • Reviewing Rules for Data Changes
    • Defining Text Messages for Errors
    • Using Text Messages in Pages and PL/SQL
    • Handling Errors in a Common Way
    • Coding Business Rules for Reuse
    • Experiencing Validation Failure in UI
    • Receiving Validation Error in REST API
  • Controlling REST API Behavior Completely
    • Providing Complete Set of ORDS Handlers
    • Using Handler Bind Variables
    • Keeping PL/SQL Handlers Maintainable
    • Defining Explicit Handler Parameters
    • Reusing Common REST API Handler Code
    • Reading and Writing Binary Content
  • Layering Packages for Modularity
    • Studying API Handler Package Layers
    • Examining Core Action Item API Logic
      • Constructing or Querying an Action Item
      • Retrieving Action Items with Paging
      • Modifying Action Items with Pre/Post Logic
        • Populating PL/SQL Records from JSON
        • Saving Action Item Data to Tables
        • Defaulting and Validating Pre/Post-Save
        • Coordinating the API Helper Code
      • Inspecting the Core Action Item API Body
  • Simplifying REST APIs in Oracle 26ai
    • Using JSON Type and Duality Views
      • Storing and Accessing JSON Type Data
      • Defining JSON Relational Duality View
      • Querying JSON Relational Duality View
      • Modifying JSON Using a Duality View
      • Flexing the Duality of Duality Views
      • Preventing Lost Updates with ETAG
      • Comparing _id and RESID in Duality View
    • Exploring ORDS AutoREST for Duality View
      • Enabling AutoREST for a Duality View
      • Exercising Duality View AutoREST Endpoint
      • Enforcing More Complex Business Logic
    • Configuring ORDS Handlers for 26ai API
    • Seeing How Duality View Simplifies Logic
      • Saving JSON Using SQL Without Parsing
      • Transforming JSON Declaratively in SQL
      • Processing and Accessing JSON Easily
      • Querying Predefined JSON Structure
      • Inspecting the Core 26ai Action Item API
  • Securing APIs with Role-Based Access Control
    • Defining ORDS Role and Privileges
    • Issuing OAuth Client for Authentication
    • Using REST API with an OAuth Client
• Geocoding Addresses
  • Geocoding with User Confirmation
    • Producing GeoJSON from Coordinates
    • Avoiding SQL Expression Update Error
    • Identifying Address Text Fields
    • Confirming an Address Interactively
    • Extracting Coordinates for Storage
    • Unprotecting Client-Set Hidden Items
    • Exploring Additional Page Features
      • Clicking Map Point to Open Edit Dialog
      • Refreshing Region on Dialog Close
      • Stretching to Fill Vertical Space
        • Stretching Vertically Using CSS
        • Inspecting Potential Stretch Targets
        • Calculating Height in Inline CSS
        • Applying Vertical Stretch in a Dialog
      • Preventing Enter Key from Submitting
      • Triggering Geocoding with Enter Key
      • Including Context Info in Dialog Title
      • Providing App-Wide Helper Functions
        • Adding Static Application JavaScript File
          • Using JavaScript Namespace Template
          • Comparing Namespace to PL/SQL Package
        • Including Helper Functions in All Pages
      • Using Translatable Text in JavaScript
  • Geocoding in the Background
    • Selecting Items for Server-side Geocoding
    • Referencing Coordinates Item Values
    • Processing Collection of Matches
    • Configuring Match Mode
• Uploading, Viewing, and Downloading Files
  • Reviewing Break Room and Referrals Pages
    • Sharing Photos in the Break Room
    • Submitting a Referral to Earn a Bonus
    • Studying Supporting Tables and Views
  • Storing Employee ID in an Application Item
    • Defining an Application Item
    • Computing an Application Item at Login
    • Referencing the App Item Value
  • Uploading an Image to a BLOB Column
    • Configuring Upload Image Item Source
    • Controlling Image Upload User Experience
    • Enlarging Image Upload Icon Preview
    • Configuring Application-Wide Style Rules
    • Posting a Break Room Photo
  • Displaying BLOB Column Images
    • Showing BLOB Column Images on Cards
    • Previewing Image in a Form Region
    • Displaying BLOB Images in Classic Reports
    • Using BLOB Images in Interactive Reports
    • Including BLOB Images in Content Row
    • Viewing BLOB Images in Search Results
    • Showing BLOB Images in Interactive Grid
      • Using GET_BLOB_FILE_SRC for Image URL
      • Configuring Reference Image Page Item
      • Serving Inline BLOB Images with a Page
      • Using an Inline Image Serving Page
      • Weighing X01 Against a Secure Page Item
        • Understanding Implications of Using X01
        • Downloading Image with Secure Page Item
        • Generating Image URL with Secure Item
        • Experiencing URL Checksum Protection
    • Using BLOB Column Image URLs Anywhere
  • Uploading a File to a BLOB Column
    • Selecting an Open Job to Add Referral
      • Using Trigger Actions to Set Selected Job Info
      • Adjusting UI When Selected Job Changes
    • Passing Client-Side Data to Dialogs
      • Opening Server-Generated Dialog URL
        • Generating Dialog URL on the Server
        • Opening Dialog URL Passing Client Data
      • Passing Client Data Directly to Dialogs
        • Defaulting URL Template Page Items
        • Substituting Client-Side Data in Dialog URL
        • Opening Dialog, Passing Client-Side Data
        • Unprotecting Dynamic Client Arguments
    • Configuring File Upload to a BLOB Column
    • Ensuring the Automatic DML Process
    • Controlling File Upload Item Behavior
    • Submitting a Job Referral CV
  • Previewing BLOB Column PDF Files Inline
    • Creating PDF Viewer Template Component
    • Serving an Inline PDF from a BLOB Column
    • Using PDF Viewer in Job Referrals Page
    • Allowing Embedding from Same Domain
  • Downloading a File for Offline Use
    • Configuring Single-File Download Action
    • Downloading ZIP Archive of Multiple Files
  • Uploading Multiple Images or Files
    • Handling Temporary Uploaded Files
      • Controlling Retention of Temporary Files
      • Referencing Temp Files by Unique Name
      • Displaying Temp File Names and Types
      • Processing Temporary Uploaded Files
      • Deleting Temporary Uploaded Files
    • Posting Multiple Break Room Photos
      • Configuring Multiple File Image Upload
      • Experiencing Post Multiple Photos Flow
      • Using a Collection to Capture Image Titles
      • Joining Collection with Temp Files Table
      • Preparing and Saving Images with Titles
        • Organizing Application Logic in a Package
        • Clearing Collection to Start the Process
        • Preparing Collection to Enter Photo Titles
        • Previewing Images in a Grid to Enter Titles
          • Toggling UI Based on Collection Contents
          • Serving Inline Temp Images for Preview
          • Entering Images Titles in a Grid
          • Invalidating Required Queried-Null Titles
          • Saving the Posted Images with Titles
  • Using an OCI Object Bucket for Files
    • Understanding Object Bucket URL Format
    • Defining OCI Web Credential for REST APIs
    • Listing Buckets with REST Data Source
    • Using REST Data Source for Bucket Files
    • Serving Inline File from Object Bucket
    • Browsing and Selecting Bucket Files
      • Displaying Bucket Files with Content Row
      • Configuring Content Row for Bucket Files
      • Enhancing REST Data with SQL Expressions
      • Defining and Using Global Substitutions
      • Configuring Selection, Paging, and Avatar
    • Storing an Uploaded File in Object Bucket
    • Exploring Pre-Authenticated Requests
      • Understanding Object Bucket Visibility
      • Creating Pre-Authenticated Requests
      • Using Pre-Authenticated Requests
• Loading External Data
  • Exploring External Data Examples
  • Creating a Data Load Definition
  • Augmenting Data Load Profile Columns
  • Generating and Using a Data Loading Page
    • Creating a Data Loading Page
    • Using a Data Loading Page
    • Understanding Data Loading Pages
      • Specifying the File and Uploading It
      • Validating the Uploaded File Type
      • Letting User Select Worksheet
      • Previewing External Data Before Loading
      • Loading Data with Native Page Process
  • Parsing Data Without Data Load Definition
  • Loading Multiple Files Including ZIPs
    • Adding XML, CSV, JSON Data Load Definitions
    • Setting File Upload to Handle Multiple Files
    • Processing Multiple Uploaded Files
    • Uploading Multiple Data Load Files
• Grouping Logic and Background Execution
  • Exploring Employee Excellence for HR Reps
  • Outlining Logic Using Execution Chains
    • Setting Up Context After Submit
    • Making Processing Conditional
    • Sequencing Child Processes
    • Nesting Execution Chains
    • Choosing Descriptive Process Names
  • Offloading Work to the Background
    • Configuring Chain to Run in Background
    • Outlining the Award Review Process
    • Printing Personalized Certificate
    • Emailing User with Attachments
    • Push Notifying User on Opted-in Devices
  • Serializing Background Process Jobs
  • Understanding Cloned Session State
    • Isolating Background Session State
    • Configuring Temporary File Handling
  • Reporting Background Progress
    • Reporting Background Process to Users
    • Accessing Background Process Status
    • Querying Progress of Background Process
    • Showing Background Process Progress Bar
    • Stretching Classic Report’s Last Column
    • Clamping Text to a Fixed Number of Lines
  • Loading Data in the Background
  • Limiting and Throttling Background Jobs
  • Adjusting Resources for Background Jobs
  • Debugging Background Processes
    • Reviewing App Background Processes
    • Investigating Background Process Errors
    • Viewing Background Process Session State
• Executing Repetitive Processing
  • Understanding Key Automation Concepts
  • Exploring an Automation Example
    • Winning Salary Increase Every Saturday
    • Identifying Automation Rows to Process
    • Configuring Supporting Automation Logic
    • Defining Automation Actions in Sequence
    • Establishing an Automation’s Schedule
      • Using Interval Builder to Schedule Job
      • Using More Complex Schedule Expressions
    • Running an Automation on Demand
    • Viewing the Automation Log
• Notifying End Users
  • Displaying Success and Error Messages
    • Configuring Success and Error Messages
    • Using Validations for Multiple Errors
      • Validating By Returning True/False Result
      • Validating By Returning Error Text
    • Auto-Dismissing Success Messages
    • Showing Messages with Dynamic Actions
    • Showing Messages Programmatically
      • Adding an Error Message in PL/SQL
        • Enforcing Rules with Read-Consistency
        • Applying Aggregate Constraints with SQL
      • Displaying Messages with JavaScript
    • Customizing Error Message Display
      • Studying Default Error Message Behavior
      • Specifying an Error Handling Function
      • Examining Error Handling Function Code
      • Logging Error Info for Troubleshooting
      • Experiencing Custom Error Handling
  • Sending Emails with Templates
    • Setting Up Default From Email Address
    • Sending Email Without a Template
    • Defining Email Template with Directives
    • Using Email Template and Placeholders
    • Sending Emails from Business Logic
  • Delivering Push Notifications
    • Enabling Push Notifications in an App
    • Generating Key Pairs for Push Notifications
    • Letting Users Manage Notification Settings
    • Opting-In to Receive Push Notifications
    • Pushing a Smile to a Colleague
    • Overriding Notification Target Link
    • Pushing Notification from Business Logic
• Producing Pixel-Perfect Reports
  • Setting Your App’s Remote Print Server
  • Printing Report with an Excel Template
    • Formatting Data in Excel with Tags
    • Creating Layout for Document Template
    • Defining Report Query Sources
    • Assigning Sources a Data Loop Name
    • Using SQL Features in Report Sources
    • Inspecting the Report Query JSON
    • Printing Report from a Page
    • Experiencing Report Generation as a User
  • Customizing Reports with Word Template
    • Formatting Data in Word with Tags
    • Setting Layout Data Loop Name
    • Overriding PDF Layout of Report Regions
    • Downloading Customized Report PDF
• Translating Your Application
  • Exploring Woods HR Pages to Translate
  • Enabling the First Translation Language
  • Understanding Initial Text Message Sync
  • Exporting and Importing Translations
  • Determining User’s Preferred Language
  • Experiencing App in Another Language
  • Translating Text as Your App Evolves
    • Adding a New Text Message
    • Using the Text Messages Picker
    • Entering New Text Directly Inline
  • Synchronizing Text Messages Anytime
  • Editing Translations in a Filterable Grid
  • Centralizing Reusable UI Text
• Understanding Application Lifecycle
  • Identifying Application Artifacts
  • Exporting and Importing Applications
  • Working with Multiple Environments
  • Isolating Changes with Working Copies
  • Tracking Changes with Source Control
  • Summarizing Lifecycle Recommendations
• Working with APEXlang
  • Why APEXlang Matters
  • Using APEXlang with AI Coding Agents
  • Exporting APEXlang from App Builder
  • Importing APEXlang in App Builder
  • Reading APEXlang Syntax
  • Using App Builder and External Tools Together
  • Editing APEXlang in Visual Studio Code
  • Using SQLcl with APEXlang
  • APEXlang Inside App Builder
  • Understanding APEXlang Deployment Files
  • Upgrading APEXlang Source with a New APEX Release
• Automating Business Processes
  • Automating a Process with Workflow
    • Using the Diagram and Activities Palette
    • Surveying the Native Activities
    • Connecting and Routing Activities
      • Adding an Activity from the Palette
      • Naming a New Activity
      • Changing a Connection’s Target Activity
      • Fine-Tuning Line Slope with Anchor Dots
      • Moving Connections with Grab Handles
      • Adding a Connection Between Activities
      • Bending a Connection with Elbow Dots
      • Adding Next Activity from Existing One
      • Configuring a Switch Connection
      • Inserting Activity Between Existing Ones
      • Moving a Group of Activities
      • Bringing Connections in Front of Activities
    • Resolving Errors Before Saving a Workflow
    • Associating a Table with a Workflow
    • Retrieving Data for an Activity
    • Defining Parameters and Variables
      • Creating a Workflow Parameter
      • Creating a Workflow Variable
    • Understanding Background Execution
    • Getting Approval or User Input in a Workflow
      • Assigning Work to a User’s Task Inbox
        • Deciding if Task Needs an Outcome
        • Associating a Table with a Task
        • Accepting Input Values in Parameters
        • Determining Task Participants
          • Setting Static Task Participants
          • Assigning Participants Dynamically
          • Passing Participants in a Parameter
          • Accounting for Vacations or Absences
        • Understanding Task States
        • Creating Task “Inbox” Page for Users
          • Tailoring Task List to Purpose
          • Showing Only Current Application Tasks
          • Including Extra Columns in Task List
          • Limiting Which Types of Tasks Appear
          • Joining Extra Tables into Task List
        • Collecting Data Using a Human Task
          • Defining Updatable Task Parameters
          • Controlling Parameter Visibility
          • Parameterizing the Task Assignee
          • Creating the Human Task Instance
          • Passing Workflow Parameter to a Task
          • Assigning Task Parameters to Variables
        • Using and Tuning the Task Details Page
          • Viewing Work Items You Requested
          • Adding a Task Details Page
          • Viewing Tasks Requiring Your Attention
          • Requesting More Info for a Task
          • Responding to Requests for Information
          • Editing Updatable Parameters
          • Completing an Action Task
          • Inspecting Overall Workflow Status
          • Fine-Tuning a Task Details Page
        • Letting an Initiator Approve a Task
        • Handling Time-Sensitive Tasks
          • Letting an Initiator Approve a Task
        • Reacting to Task Change Events
          • Choosing Event for an Action
          • Accessing Task Information
          • Notifying Assignees on Create
          • Updating Columns on Completion
      • Waiting for a Signal to Continue
        • Enabling Deep Linking to a Specific Page
        • Generating Page URL for Notification
        • Emailing User a Page Link
        • Delivering Push Notification with Page Link
        • Waiting Until Application Logic Continues
        • Navigating to Page Using Email Link
        • Retrieving Title and Activity Labels
        • Signaling to Continue and Returning Data
        • Inspecting Resulting Workflow Instance
        • Evaluating Benefits of Using Tasks Instead
    • Identifying Workflow Participants
      • Configuring Static Workflow Participants
      • Determining Participants Dynamically
      • Passing in Workflow Participants
    • Listing Workflows and Viewing Details
  • Exploring Patient Onboarding Example
    • Understanding the Current Process
      • Inquiring About a Procedure
      • Onboarding the Patient Manually
    • Identifying Automation Opportunities
    • Starting a Patient Onboarding Workflow
    • Associating the Patients Table
    • Configuring a Meaningful Title
    • Building Patient Onboarding Visually
      • Applying Activities to Patient Onboarding
      • Evaluating Spatial Distance with an API
      • Switching Path Using a Condition
      • Predicting Results with Machine Learning
        • Finding Best Algorithm for Your Data
        • Predicting Patient Onboarding Outcome
      • Visualizing Workflow Progress
      • Awaiting Completion of a Human Task
      • Emailing Users a Rejection
        • Emailing or Push Notifying Users
        • Using Email Template with Placeholders
        • Querying Activity Data On Demand
        • Receiving the Rejection Email
      • Provisioning a New User Account
        • Invoking the Provision Account API
        • Inserting Account Creation Request
        • Scheduling Create New Account Job
        • Handling New Account Requests
        • Notifying User of Temporary Password
        • Receiving New Account Email
      • Waiting Until Patient Completes Profile
        • Waiting Indefinitely for a Custom Signal
        • Completing the New Patient Profile
        • Signaling the Workflow to Continue
        • Understanding Onboarding is Complete
  • Automating Business Entity Lifecycle Logic
    • Learning the Medical Procedure Lifecycle
    • Seeing the Medical Procedure Lifecycle
    • Modeling the Medical Procedure Lifecycle
    • Starting the Lifecycle Workflow
    • Following a Medical Procedure Lifecycle
      • Launching Woods Clinic Application
      • Scheduling a Medical Procedure
      • Receiving Medical Procedure Schedule
      • Discharging Patient After Procedure
      • Preparing Pixel-Perfect PDF Invoice
        • Printing Documents from a Workflow
        • Retrieving Invoice Data
        • Formatting the Invoice in a Layout
        • Generating the Data-Driven Document
      • Reviewing Invoice with Insurance Provider
      • Regenerating Invoice in Background
      • Invoicing Patient for the Balance
      • Acknowledging Receipt of Payment
      • Confirming the Lifecycle is Complete
    • Notifying Workflow of Data Changes
      • Understanding Lifecycle Event Strategy
      • Simplifying Event Management
      • Adding Events Using a Trigger
      • Processing Events with an Automation
      • Continuing a Waiting Lifecycle Workflow
  • Maintaining Workflow Processes
    • Importing vs. Deleting an Application
    • Recognizing Development Mode
    • Debugging Business Process Logic
      • Querying Recent Debug Messages
      • Enabling Debug Tracing Proactively
      • Viewing Debug Trace Information
      • Adding Custom Debug Messages
    • Accessing Workflow and Task Data
    • Understanding Task and Workflow Purging
    • Activating an In Development Workflow
    • Deploying Workflows to Production
    • Deleting a Workflow with No Instances
    • Removing Development Instances