create table with same schema in postgres

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, data types, and constraints as the source table. However, it will not copy the indexes, triggers, rules, or default values from the source table. If you want to include those as well, you can use some optional parameters after the LIKE clause. For example, if you want to copy the indexes and default values, you can use:

CREATE TABLE customers_backup (LIKE customers INCLUDING INDEXES INCLUDING DEFAULTS);

You can also use EXCLUDING or INCLUDING ALL to specify what to exclude or include from the source table. For more details on the syntax and options of the LIKE clause, you can refer to the Postgre documentation

hope this helps you create a table with the same schema in PostgreSQL.

How to check a class has lock enabled or not using function in Pega

 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.

Below are the records in the table, we try to update the instance in this table.

In the activity, we used this function to check the class has Allow locking enabled or not at runtime, if it is enabled, we are taking lock on the page using Obj-Refresh-And-Lock method.

In Tracer, we can able to see the when condition becomes true, since the class has Allow locking enabled.

Hope this helps during our development. Thank you!

To know more on Obj-Refresh and Lock method, go through the below article

https://docs-previous.pega.com/reference/87/obj-refresh-and-lock-method

How to view the saved tracer file offline

 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" link, scroll to the bottom, and download the tracerviewer zip file.

                                                                                                                                                                    

Click on the highlighted link.

Click on the pega-tracerviewer-3.4.1.Zip downloadable file

Once the file is downloaded. extract the file.

Go to the location bin inside the extracted file and click on the below highlighted batch file.

Tracer viewer tool will open.

Now let me open the pega and run a sample tracer and click on save in tracer and extract the jar file.

Click on save in tracer to save the tracer file.

Now go to Pega Tracer viewer and click on file -> Load pega tracer file menu and select the extracted file

Select the xml file and click open

Now, we can able to view the downloaded tracer file

Thanks for reading!

How to use Log Category to debug issues in Pega

 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 the log level to DEBUG in pxDeclarativeReporter.Save.Index

Click on Reset at 3 dot and change to DEBUG and submit

Now lets see how it is working..

In Data-Admin-Operator-ID class, we have a declare index rule, this rule will trigger when we are saving a operator with the skill.. lets update the operator with a skill and save.

Added skill English and save

Now log should have the information about this declare index details.

Go to Configure -> System -> Operations -> Log -> Log files

Open the pega Logs

In Log file, we can able to view the log information about the logger

We can able to see , in skill page list 1'st index is changed

Similarly, we can able to change the logging level to DEBUG for other log cateogory and debug. Once we have completed the debug, we have to change the log level to ERROR back.

How to get the JSON of a page in Pega using data transform

 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.

How to convert GMT datetime value to EST datetime value in Pega

 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:

Populating a page under pyWorkPage with data and using on the next assignment

 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 submit, we should keep the updated page inside the pyworkpage (to review in second assignment), so called a data transform on modal dialog flow action post processing

In the data transform copying the data from primary(D_CustomerList.pxResults(3)) to a page inside pyWorkPage

page property using under pyworkpage

on submitting modal dialog, updated data is populated under pyworkpage

Submit and move to next screen

in the next assignment(opened from wb) also has the page.

Second Assignment Configuration:

Reusing the same section displaying inside the modal dialog , to display the data present in the pyWorkPage.UpdatedCustomerInfo

In the second assignment, Updated data is displaying

On Approval, we can update the data present in the UpdatedCustomerInfo page to datapage.

DCR (Dynamic Class Referencing) using configuration sets.

Hello Frendz,

In this post, we see about #Dynamic class referencing using the configuration sets.

Starting pega 8.6 configurations sets are available in pega app studio , We can use to reference the class dynamically. In this post we see how we can create a child case using the configuration sets.

 This Demo is created by using pega version 8.6

     ·         Navigate to app studio , in left pane click on settings à Configurations à Manage Configuration

     ·         Click on manage configurations à Add the desired name , here we named it as “DCR”

     ·         Click on Add Configurations, screen will be prompted with pop up to enable the settings.

       

        

The configuration set not only to reference the class to create the case, we can make use below option in our configurations set , In Pega 8.7 we will have another one option called, “Constant as per production level”        

 In Pega 7x version we used to create Data transform, Data page, and Property to extend the referencing to other case types.  Starting 8.6 pega provided the new capabilities to refer the configurations sets to reference dynamically.

Now let’s see where these instances will be available in pega after created.

Switch to Dev studio, navigate to App explorer, click on the class Data-Configuration-Setting to see the instance

                

Now let’s see how to reference those in our case type.

Open any activity/Data transform to open the expression builder,

You will see additionally one option to see the “configurations” click on that and select your configuration set to get the reference as shown in right side.

Copy the entire value and keep it.

Now here we are going to see how to make use of that copied value into case type.

Here we have Raise Concern – Parent case, We are going to call the “Bound Up Concerns” child case by using the configuration set reference.

Used the create case step to refer the configuration set.

Now Let’s run the case and see our child case is created. As shown below it is created our child case as well.😊

Hope this example helps you in comprehending configuration sets.

Reference Links:

Configuration sets - PegaWiki

Creating a configuration set | Pega