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: