Database Query Useful in Pega

This Post is about the Database query useful in pega and how to use them.
Everytime we need to deploy code to higher environment , we need to do certain validations to make sure all the rules are deployed and no retrofits are needed.this post is going to help me with the database queries in single page.

Click the button to copy the syntax

Function	To check if value exist in Pagelist
Syntax
Notes	Return true, if the value that has been passed as input is in the property that is in pagelist exist and false otherwise For example: @IsInPageList("ApplyJobs","pyLabel",D_ABC.pxResults) @IsInPageList("Jon Snow","Name",.CandidateList) @IsInPageList(.pyUserName,"Name",.CandidateList)

Function	check if any of the page has the match
Syntax
Notes	Returns true, when any of the page has the match. For example: @IsInPageListWhen("IsAvailable",D_ABC.pxResults) @IsInPageListWhen("IsAvailable",.CandidateList)

Function	To get count if value exact match with property in Pagelist
Syntax
Notes	Returns count of the pages which has the match. For example: @countInPageList("ApplyJobs","pyLabel",D_ABC.pxResults) @countInPageList("Jon Snow","Name",.CandidateList) @countInPageList(.pyUserName,"Name",.CandidateList)

Function	To get count of Pagelist matching when condition
Syntax
Notes	Returns count of the pages which has the match. For example: @countInPageListWhen("IsAvailable",D_ABC.pxResults) @countInPageListWhen("IsAvailable",.CandidateList)

Function	To check if on all pages contains exact match with property in Pagelist
Syntax
Notes	Return true, if on all pages contains exact match with property in Pagelist \ For example: @IsInEachPageofList("ApplyJobs","pyLabel",D_ABC.pxResults) @IsInEachPageofList("Jon Snow","Name",.CandidateList) @IsInEachPageofList(.pyUserName,"Name",.CandidateList)

Function	To check if on all pages in Pagelist Pagelist matching when condition
Syntax
Notes	Returns true, if the when condition evaluates to true for every page of the pagelist. For example: @IsInEachPageofListWhen("IsAvailable",D_ABC.pxResults) @IsInEachPageofListWhen("IsAvailable",.CandidateList)

Function	To check the length of Pagelist
Syntax
Notes	Returns Length of the pagelist. For example: @LengthOfPageList(D_ABC.pxResults) @LengthOfPageList(.CandidateList)

Function	Get the index in Pagelist
Syntax
Notes	Returns the index of the first entry in the pagelist. Returns -1 if no match found. For example: @IndexInPageList("ApplyJobs","pyLabel",D_ABC.pxResults) @IndexInPageList("Jon Snow","Name",.CandidateList) @IndexInPageList(.pyUserName,"Name",.CandidateList)

Function	Get the index in Pagelist, if any of the page has the match
Syntax
Notes	Returns the index of the first entry in the pagelist , when any of the page has the match. Returns -1 if no match found. For example: @IndexInPageListWhen("IsAvailable",D_ABC.pxResults) @IndexInPageListWhen("IsAvailable",.CandidateList)

Function	check value of one property on each page of the Page List with the operand and value specified
Syntax
Notes	Option_here can be ANY/ALL. Does not create any additional pages. Returns true if all/any of the values meet the comparison. Returns false if the property contains no pages For example: @entrySatisfiesCondition(.Invitees().age, ">", 45, "ANY")

Function	To sort the pagelist based on property
Syntax
Notes	Option_here can be Ascending/Descending.. Returns sorted order in the same pagelist For example: @pxSortPageList(CaseType.pxResults,".pyCaseTypeClass","Ascending")

Please comment , if you need any function to be included here

Read more

Delete Unwanted Branches in Pega Application

Introduction

One common issue in development teams is forgetting to delete branches after they have been merged. Over time, these unused branches clutter the application, making branch management more difficult.

A common way to identify unwanted branches is to:

• Open each branch individually.
• Check whether it contains any rules.
• Delete the branch if it is empty.

While this works, it is time-consuming, especially in applications with many branches.

This article shows a simple enhancement that displays both the branch creator and the number of rules directly in the Branch landing page, making it much easier to identify branches that can be safely removed.

---

How It Works

The solution uses the following out-of-the-box (OOTB) components:

• Data Page: D_pxBranchContent
• Activity: pzBranchLandingContent
• Section: pzBranchesLabel
• Section: pyDescriptionLabel

The enhancement displays additional information for every branch in the Branch landing page:

• Branch creator
• Number of rules in the branch

This allows you to quickly spot branches that contain 0 rules, which are typically safe candidates for deletion.

---

Step 1: Update the Branch Display Section

Open the pzBranchesLabel section.

Include the pyDescriptionLabel section.

Configure its source to use the D_pzBranchContent data page and pass the following parameter:

• Branch ID: .pyBranchID

This enables the section to display additional information retrieved from the data page.
Also make sure , you have selected the Defer Load Contents. It opens the application rule faster.

---

Step 2: Modify the Activity

Open the activity:

pzBranchLandingContent

Navigate to Step 7.

Update the logic to populate the pyDescription property with the following value:

pyLanding.pxCreateOpName + "_" + pyLanding.pyCount

Where:

• pxCreateOpName = Name of the operator who created the branch
• pyCount = Number of rules present in the branch
  
  
  
  
  
  
  
  
  

---

Result

After making this enhancement, each branch displays information similar to:

JohnSmith_0

or

MaryJones_24

This immediately tells you:

• Who created the branch
• How many rules it contains

Branches with 0 rules can be quickly identified and cleaned up without opening each branch individually.

Branches which can be safely removed from the application

---

Benefits

• Saves time when reviewing branches.
• Makes branch cleanup much faster.
• Helps identify stale or unused branches.
• Improves overall branch management.
• Uses existing OOTB components with only a small customization.

---

Conclusion

Instead of manually opening every branch to check whether it contains rules, this lightweight customization surfaces the most useful information directly on the Branch landing page.

By displaying the branch creator alongside the rule count, developers and administrators can quickly identify unnecessary branches and keep the application clean with minimal effort.

Read more

Workbasket Restriction By Roles

 Each Workbasket will have roles 

 If the user has the roles specified in Workbasket, he will be able to access the items in workbasket 

 Now for User and Manager , say workbaset is -> ApprovalWB

 

For the User . the role is 

 

Org:User

 

For the Manager  , the role is 

Org:Manager

 

Now , if the provide the ApprovalWB with  role (Org:Manager)

Then the User will not be able to access the items in ApprovalWB But he will be able to push the item to ApprovalWB 

Read more

Display Files from a Server Path in Pega Using an Activity and Java Step

 In some enterprise applications, you may need to display the list of files and folders available in a server directory directly inside a Pega application. This can be useful for:

• Monitoring batch file drops
• Viewing integration files
• Validating document uploads
• Supporting admin utilities
• Troubleshooting file-processing jobs

This article explains how to create a Pega Activity that reads files from a server directory using Java and stores the results into a Page List for UI display or further processing.

Use Case

The requirement is simple:

Read all files and folders from a server directory and display:

• File name
• Folder name
• File size
• File creation date/time

The solution uses:

• A Pega Activity
• Java Step
• Code-Pega-List
• pxResults
• Java File APIs

To display the files in the server path Create Activity and add these steps

Java used for this activity

try { 
  ClipboardPage PLPage = tools.createPage("Code-Pega-List" , "");
  ClipboardPage ResultPage = tools.createPage("Data-", "");
   oLog.infoForced("[FilesInDirectory] try block started "); 

		java.io.File fileContents[] = new java.io.File(Directory).listFiles();
		if (fileContents != null) {
			for (int i = 0; i < fileContents.length; i++) {
				   if(fileContents[i].isDirectory())
        {
            ResultPage.putString ("pyLabel", "[FilesInDirectory] Folder: "+fileContents[i]);
tools.findPage("PLPage").getProperty("pxResults").add(ResultPage);

          oLog.infoForced("[FilesInDirectory] Folder: "+fileContents[i]); 
        }
				 else
         {
           //long fileSize = fileContents[i].length();
           ResultPage.putString ("pyLabel", "[FilesInDirectory] File: "+fileContents[i]);
           ResultPage.putString ("pyNote", "[FilesInDirectory] size(bytes): "+fileContents[i].length());
           
           
           // Getting the file creation datetime
 java.nio.file.Path filePath = fileContents[i].toPath();
 java.nio.file.attribute.BasicFileAttributes attrs = java.nio.file.Files.readAttributes(filePath, java.nio.file.attribute.BasicFileAttributes.class);
      java.nio.file.attribute.FileTime creationTime = attrs.creationTime();
             
         // Adding the creation time to the ResultPage
        ResultPage.putString("TempSelectedEffectiveDate", "[FilesInDirectory] Creation Time: " + creationTime.toString());
           
           

        tools.findPage("PLPage").getProperty("pxResults").add(ResultPage);
           oLog.infoForced("[FilesInDirectory] File: "+fileContents[i]);
         }
				}
			}   
  oLog.infoForced("[FilesInDirectory] try block Ended "); 

			
} catch (Exception ex) { 
	oLog.error("[FilesInDirectory] catch block expected", ex);
}

Read more

Download files From the Server Path in Pega

In many Pega applications, there are scenarios where files are generated dynamically and stored temporarily on the server. Users may then need to download these files directly from the application UI. One practical approach is to create a custom Activity that reads the file from the server path and streams it to the browser for download.

This blog explains how to implement file download functionality in Pega using Java steps inside an Activity.

Use Case

Suppose your application:

• Generates PDF reports
• Creates Excel exports
• Produces temporary documents on the server
• Stores files in a shared directory

You can allow users to download these files directly using a Pega Activity.

Solution Overview

The implementation works as follows:

1. Pass the server file path as a parameter
2. Read the file from the server
3. Convert the file into a byte array
4. Use tools.sendFile() to stream the file to the browser
5. Optionally delete the file after download

Add a Java Step

Add a Java step inside the Activity and use the following code

Java used for this activity

``` //Get the byte array from the parameter page
//String Stream=tools.getParamValue("FileStream");
FilePath = tools.getParamValue("FilePath");
//byte[] byteArray=Base64Util.decodeToByteArray(Stream);


java.io.File originalFile = new java.io.File(FilePath);
java.io.FileInputStream fileInputStreamReader=null;
byte[] bytes=null;
try{
if(originalFile.exists())
  {

         fileInputStreamReader = new java.io.FileInputStream(originalFile);
        bytes = new byte[(int)originalFile.length()];
   fileInputStreamReader.read(bytes);
fileInputStreamReader.close();
}
  else{
    ErrMsg="Uanble to open a file/file dooesn't exist:"+FilePath;
  }
}

catch(Exception ex){
  oLog.error("Error during opening the document in ProcessAutoCreateDocument activity:"+ex.getMessage());
  ErrMsg=ex.getMessage();
}
//Get the file name from the parameter page
pdfName=tools.getParamValue("FileName");


// download the file directly
String result=tools.sendFile( bytes,pdfName,false,null,true);
// delete file from path after download
//originalFile.delete();

Read more

Previous Business Date With Australia Day Light saving Logic

 
This post contains logic related to find the previous business day using the Data transform based on the calendar which is passed .

Extracted Table

#	Action	Target	Relation	Source
1	Set	Param.DateAEST	equal to	@DateTime.FormatDateTime(@DateTime.addToDate(@CurrentDateTime(),'0','0','0','0','0','0'),'yyyyMMdd','Australia/Sydney','en_AU')
2	Set	Param.PreviousBusinessDayAEST	equal to	@addDays(Param.DateAEST,-1,true,'AUDefault')
3	Set	Param.DateGMT	equal to	@CurrentDate('yyyyMMdd','GMT')
4	Set	Param.PreviousBusinessDayGMT	equal to	@addDays(Param.DateGMT,-1,true,'AUDefault')
5	Set	Param.DaylightSaving	equal to	@InDaylightSaving('Australia/NSW',@CurrentDateTime())
6	When	@CompareDates(Param.DateAEST,Param.DateGMT)
6.1	When	@equalsIgnoreCase(Param.DaylightSaving,true)
6.1.1	Set	param.StartDate	equal to	@addToDate(Param.DateGMT,'',13,'','')
6.1.2	Set	Param.PreviousBusinessDayStartDate	equal to	@addToDate(Param.PreviousBusinessDayGMT,'',13,'','')
6.1.3	Set	Param.PreviousBusinessDayEndDate	equal to	@DateTime.addToDate(param.PreviousBusinessDayStartDate,'1','','','')
6.1.4	Set	Param.PreviousDay	equal to	@DateTime.addToDate(param.StartDate,'-1','','','')
6.1.5	Set	Param.CutOffDate	equal to	@DateTime.addToDate(param.StartDate,'','','','')
6.2	Otherwise
6.2.1	Set	param.StartDate	equal to	@addToDate(Param.DateGMT,'',14,'','')
6.2.2	Set	Param.PreviousBusinessDayStartDate	equal to	@addToDate(Param.PreviousBusinessDayGMT,'',14,'','')
6.2.3	Set	Param.PreviousBusinessDayEndDate	equal to	@DateTime.addToDate(param.PreviousBusinessDayStartDate,'1','','','')
6.2.4	Set	Param.PreviousDay	equal to	@DateTime.addToDate(param.StartDate,'-1','','','')
6.2.5	Set	Param.CutOffDate	equal to	@DateTime.addToDate(param.StartDate,'','','','')
7	When	@equalsIgnoreCase(Param.DateAEST,Param.DateGMT)
7.1	When	@equalsIgnoreCase(Param.DaylightSaving,true)
7.1.1	Set	param.StartDate	equal to	@addToDate(Param.DateGMT,'',11,'','')
7.1.2	Set	Param.PreviousBusinessDayStartDate	equal to	@addToDate(Param.PreviousBusinessDayGMT,'',11,'','')
7.1.3	Set	Param.PreviousBusinessDayEndDate	equal to	@DateTime.addToDate(param.PreviousBusinessDayStartDate,'1','','','')
7.1.4	Set	Param.PreviousDay	equal to	@DateTime.addToDate(param.StartDate,'-1','','','')
7.1.5	Set	Param.CutOffDate	equal to	@DateTime.addToDate(param.StartDate,'','','','')
7.2	Otherwise
7.2.1	Set	param.StartDate	equal to	@addToDate(Param.DateGMT,'',10,'','')
7.2.2	Set	Param.PreviousBusinessDayStartDate	equal to	@addToDate(Param.PreviousBusinessDayGMT,'',10,'','')
7.2.3	Set	Param.PreviousBusinessDayEndDate	equal to	@DateTime.addToDate(param.PreviousBusinessDayStartDate,'1','','','')
7.2.4	Set	Param.PreviousDay	equal to	@DateTime.addToDate(param.StartDate,'-1','','','')
7.2.5	Set	Param.CutOffDate	equal to	@DateTime.addToDate(param.StartDate,'','','','')

Read more

Generic Decision Table For Reusable Email Configuration

Email notifications are a critical part of most enterprise applications.
Whether it’s:

• Case creation alerts
• Approval notifications
• SLA escalations
• Error communications
• Customer acknowledgements

Applications often require multiple email configurations spread across different flows and activities.

Hardcoding email details directly inside activities or utilities makes maintenance difficult and increases duplication.

A cleaner approach is to centralize email configurations using a reusable Decision Table.

This article explains how to build a Generic Email Decision Table in Pega that can be reused across the application to dynamically configure:

• Email recipients
• CC recipients
• Subject lines
• Correspondence rules
• Data transforms

 

Why Use a Generic Email Decision Table?

Without a centralized approach:

• Email logic becomes duplicated
• Changes require updates in multiple places
• Maintenance becomes error-prone
• Business teams cannot easily manage configurations

Using a Decision Table provides:

• Centralized email configuration
• Reusability across applications
• Easier maintenance
• Cleaner activities and flows
• Dynamic email behavior

Solution Overview

We will create a Decision Table named:

SendEmailByPurpose

This decision table will determine which email configuration to use based on a business purpose.

This Post talks about how to create a Generic Email Decision table which can be used across appliation to configure the Email parameters like To , CC , Subject and Body.

Lets Create a Decision table , SendEmailByPurpose

Sample Decision Table Configuration

pyPurpose	Evaluate	pyDataTransform	pyCorrForSendEmail	pySubject	pyTo	EmailString
CASE_CREATED	true	PrepareCaseEmail	CaseCreatedCorr	Case Created Successfully	.CustomerEmail	support@company.com
APPROVAL_REQUIRED	true	PrepareApprovalEmail	ApprovalCorr	Approval Required	.ManagerEmail	escalation@company.com
PAYMENT_SUCCESS	true	PreparePaymentEmail	PaymentCorr	Payment Successful	.CustomerEmail	finance@company.com

Input columns in Decision table 

pyPurpose → Identifier used to determine which email configuration should be triggered.

Evaluate → Condition column using @equals("true", current-value) to validate whether the rule row should be executed.

Output columns in Decision table 

• pyDataTransform → Stores the mapping Data Transform used to prepare email data before sending.
• pyCorrForSendEmail → Defines the Correspondence rule/template used for the email content.
• pySubject → Stores the subject line of the email.
• pyTo → Contains the primary recipient email address(es).
• EmailString → Contains the CC recipient email address(es). 
  

  Note: The above properties are sample properties and can also be implemented using custom properties based on your application design standards and business requirements.

Architecture Benefits

1. Centralized Email Management -All email configurations exist in one place.

---

2. Reduced Hardcoding - Activities remain generic and reusable.

---

3. Easier Maintenance - Business changes only require updating decision table rows.

---

4. Improved Scalability - Adding a new email type requires:New row/ No code changes

---

5. Better Governance - Email configurations become easier to audit and manage.

Conclusion

A Generic Email Decision Table is a powerful design pattern in Pega that helps standardize and centralize email notification management across applications.

By configuring:

• Recipients
• Subjects
• Correspondence rules
• Data transforms

in a reusable Decision Table, you can:

• Reduce duplication
• Simplify maintenance
• Improve scalability
• Build cleaner applications

The SendEmailByPurpose approach is especially useful in large enterprise applications where multiple email types and workflows need to be managed consistently.

Read more

Constellation Architecture

 Constellation Architecture


Pega 8.8 version

if alternate design system

Make the Right Decision

Create New Application using Constellation

Select Cosmos React

Get My Visa Application Name

Check the application stack

Preview the application for error message

Read more

Why Pega is using Constellation ?

 So why Pega is using Constellation ?

Configuration over customization
User Friendly Javascript Rendering 
Decopuled server(s) for UI codebase
Less Maintenance and smooth upgrade

Read more

Understanding of Kafka

What is Kafka ?

Distributed Streaming platform

Think of it as:
👉 Producers (send messages) → Kafka Broker (stores/distributes them in Topics) → Consumers (read messages).

Core Concepts

1. Broker – A Kafka server that stores and serves messages.

2. Topic – A logical category to which messages are published (like a folder).

3. Partition – A topic is split into partitions for scalability. Each partition is an ordered sequence of messages.

4. Producer – Application that sends messages to a topic.

5. Consumer – Application that reads messages from a topic.

6. Consumer Group – A group of consumers that share the load of reading messages from partitions.

To Understand what value is there in the partition.

Install KafkaTool and provide the details from tomcat\kafka-1.1.0.8\config\server.config -> listeners line

ClusterName - Kafka-1.1.0.8

Kafka Cluster Version - 1.1

ZookeperHost -> 192.168.4.21

ZookeperPort -> 9092

ChrootPath - > /

I have created a QP - ABCDEF which i can see it has created 6 partitions (0-6)
Each Partitions has Offset from start 0

Now simply queue three items to QP
The Queue items are exeuted and can see the partitions selected  1, 2, 3 and each ran once

Read more

Build a Beautiful Multi Timer Application Using HTML, CSS, and JavaScript

 Timers are useful in many day-to-day scenarios:

• Study sessions
• Workout routines
• Cooking
• Gaming breaks
• Productivity tracking
• Pomodoro sessions

In this article, we will build a modern Multi Timer Web Application using:

• HTML
• CSS
• JavaScript

The application allows users to:

• Create multiple timers
• Start, pause, and reset timers
• Delete timers
• Automatically change timer colors based on remaining time

Features of the Multi Timer Application

This timer application includes:

✅ Multiple independent timers
✅ Dynamic timer creation
✅ Start / Pause / Reset functionality
✅ Delete timer option
✅ Gradient UI design
✅ Responsive layout
✅ Color-changing alerts based on remaining time
✅ Smooth modern styling

---

Application Overview

The UI contains:

• Timer Name input
• Minutes input
• Seconds input
• Add Timer button

Each timer card includes:

• Timer title
• Countdown display
• Start button
• Pause button
• Reset button
• Delete button

---

Complete Source Code

HTML Structure

The HTML creates:

• Input section
• Timer container
• Dynamic timer cards 

Java used for this activity

  
  
  


  
Go and Play Timer

  

    
    
    
    
  

  


  

-

Read more

Pending Constellation

 

1. Flexible UI with Constellation - https://community.pega.com/blog/flexible-ui-constellation - Kamil Janeczek
2. Prescribed and flexible UI with Constellation - https://community.pega.com/blog/prescribed-and-flexible-ui-constellation - Kamil Janeczek
3. How Constellation works - from authoring to rendering - https://community.pega.com/blog/how-constellation-works-authoring-rendering - Piotr Jurkowski

Read more

Constellation hands on L4

 

Constellation Building Blocks

Constellation Architecture is made of several building blocks, which work together in harmony to help you crush complexity.

Client device

In traditional Pega UI, server does both the business logic and generating all of the UI markup

But in constellation , user browsers and devices to do the heavy lifting, by utilizing the Constellation orchestration layer.

the client device plays active and vital role, acting as the layer -This includes transforming JSON metadata into HTML code

server load is minimized, creating an even faster and more responsive user experience

Infinity server and DX API

In the Constellation architecture, the Pega Infinity Server acted as a brain holding the business rules, logic, and data, while the orchestration and presentation were handled by the user's device.

Communication between both sides is covered by the use of DX API [case data + UI metadata]

Constellation UI services

 UI-related tasks are separated into two separate services

App-static - a client application-specific UI static content delivery service

UI assets (images, custom components, localizations) authored by clients are application-specific

cloud-based multitenant service or as a deployable service known as the App-Static service

must be safely stored and protected

requires authentication for all APIs (for both read and write). Reading or writing of customer-generated content is covered by the signed token

PEGA CDN - Constellation Pega UI static content

JavaScripts generated by Pega and that are part of Pega Platform
The same service for all clients

can be made publicly available for quick access

read-only and does not require authorization

Messaging Service

the Messaging Service, which realizes a server-to-client push architectural component of Constellation

components-to-topics subscriptions made through the WebSocket connection

Infinity publishes data --> Message Broker through an HTTP REST connection.
The Message Broker then pushes --> browsers that registered

for example, charts that update in real-time, or a bell icon with a badge

Greater than the sum of its parts

The orchestration layer, the Infinity server, and the robust Messaging Service collectively deliver a faster, more responsive, and highly scalable user experience

Read more