Create table with same schema in postgres: To create a table with the same schema as an existing table, you can use the LIKE clause in the CREATE TABLE statement. The LIKE clause specifies the name of the source table that you want to copy the schema from. For example, if you have a table named customers and you want to create a new table named customers_backup with the same schema, you can use:  CREATE TABLE customers_backup (LIKE customers); In the below screenshot, we can see we have created a new table like pc_LinkAttachment This will create a new table with the same column names ..read more

 Hi Friends, we all know how to update an instance using activity. If a class is lock enabled ,we have to open the instance with lock and then we have to update. If a class is not lock enabled, without using lock we can open and update. Now, if I wants to know whether the class has lock enabled or not at runtime, how to know that? In Pega we are having a function isPageClassLockChecked to achieve this, lets see how to use this in our activity. We have to use the function like below. @isPageClassLockChecked(tools,ExamplePage) This is a data class where Allow locking is enabled ..read more

 Hi Friends, in this post we will see how to install the tracer viewer tool and view the saved tracer file offline. As per the Read.md file instructions, for running this tool, we have to have minimum java 11 installed in the system. Make sure minimum java 11 is present in the system by running the below syntax in the cmd prompt.   In the below URL, we can able to view the documentation about the tracer viewling tool GitHub - pegasystems/pega-tracerviewer: The tracer viewing tool helps users understand and debug Pega tracer files. To download the tool, click on the "release" lin ..read more

 Hi Friends, In this post we will see how to use the Log Category to debug the issues. In Admin studio, Under resources, we have an option Log Category, using this we can debug issues There are many useful log categories, by reading the description, we can able to understand about the log category usage. Now assume, I am facing a problem with a declare index rule, In pega there is a log category to enable to log for declare index,  Default log level is ERROR, we have to update the log label to DEBUG to view the log message related to declare index in the log file. Updating th ..read more

 Hi Friends, In this post we will see how to get the JSON of the page using data transform. In a customer Information casetype, I have created 2 case Opening the Workobject and keeping in the CustomerInformation page. Select additional configuration option as JSON during data transform creation In the Top element structure, select Object and Select Auto-map all data checkbox. Before calling the data transform, provide parameter value Param.executionMode as "SERIALIZE" In the tracer, we can able to see the JsonData after the data transform execution in the parameter page ..read more

 Hi Friends, In this post, we will see how to convert a data time value in GMT to EST. Assume I have a data time field named InputDateTime, In this field, the value is like  Now I want to convert the date value from GMT to the corresponding EST value,  we can use the expression below to convert the GMT to EST. @FormatDateTime(.InputDateTime,"","","en_US") Output value is like below ..read more

 We have a data type with some records    Created a case with 2 assignments, First assignment we are listing all the records and updating the data on a record.  Second assignment we are routing to a workqueue for approval or reject  In the first screen , in a table layout displayed the customer data like below On clicking on row a modal dialog was opened Since the table layout source is data page, on opening the modal dialog, the data is displaying from the data page . Updating the first name from Francis to George After updated the data and ..read more

 Hi Friends, recently I saw a video about Query Runner in Pega Troubleshooting videos, I will share how I practiced in my system. Go through the video to get clear understanding about  Query Runner. Useful URLs: Troubleshooting Video Series | Pega Enabling and using Query runner to troubleshoot database issues | Pega Steps involved: Add required Role to the access group Execute select query and verify connection If faced any exception, debugging steps Adding Role to the Access Group: Open the access group and add PegaRULES:DatabaseAdministrator access role and save. Logo ..read more

 Hi Friends, recently I have learnt how to use segmented radio button. Radio button has 2 control format Standard Other  Segmented     In this post we will see the differences. Drag and drop the radio button in to the section. By Default orientation for the radio button is Vertical. and in UI radio button display looks like the below image. I have updated the orientation to Horizontal. In the UI, radio button looks like this. In Horizontal orientation, selected control format as Other and other control format as Segmented In the UI, radio bu ..read more

 Hi Friends, In this post we will see how to add CSS helper classes In W3Schools website, a exercise is present to display background image in UI. We will see how to do the similar kind of CSS changes in Pega using CSS helper classes W3Schools Try it editor URL: https://www.w3schools.com/css/tryit.asp?filename=trycss3_background_multiple Step 1: Download below image and upload to binary file Image to download: Upload the image to a binary file rule, I have provided binary rule name as paper and image of type jpg and directory is webwb. Path of this image is  webwb/paper.jpg ..read more