What is PX,PY,PZ Properties and Usage In PEGA PRPC - Harsha Trainings

[@asmakauser9647]

Hi harsha, what is aggregate property in pega and how to use n configure this?

[@HarshaTrainingsacademy]

In Pega, an aggregate property is a specialized property that allows you to perform calculations or aggregations on a group of values from a specified source. It is useful when you need to calculate the sum, average, minimum, maximum, or other aggregate functions on a set of values within a property. To use and configure an aggregate property in Pega, follow these steps: Create an Aggregate Property: Open your application in Pega Designer Studio. Go to the "Data" tab and select "Data Model." Create a new property or select an existing property where you want to store the result of the aggregate calculation. In the "Usage" field of the property, select "Aggregate." Configure the Aggregate Source: In the "Aggregate" property, go to the "Definition" tab. Under the "Source" section, select the class or data type from which you want to aggregate the values. It could be a data page, data transform, or a data source. Configure the Aggregate Function: After selecting the source, you need to specify the aggregate function that you want to apply to the values. Click on the "Add" button under the "Functions" section and choose the desired function (e.g., Sum, Average, Min, Max, etc.). Select the property or field from the source that you want to apply the function to. Save the aggregate property configuration. The aggregate property will now display the calculated value based on the aggregate function and the selected source. Here's an example to illustrate the usage of an aggregate property: Let's assume we have a "Customer" data type with properties "OrderAmount" and "OrderStatus." We want to calculate the total order amount for orders with the status "Completed." Create an aggregate property named "TotalCompletedOrders." Configure the aggregate source by selecting the "Customer" data type. Choose the "Sum" aggregate function and select the "OrderAmount" property. Add a condition under "Filters" to include only records where "OrderStatus" is equal to "Completed." Save the configuration. Aggregate properties are powerful tools in Pega for performing calculations and aggregations without the need for custom logic or report definitions. They simplify data processing and enhance the reusability of your application's data model.......!!!

[@arunkumarbairapu6960]

Hi Harsha, thanks for your valuable information.can you give a session on Kafka and que processor integration.

[@HarshaTrainingsacademy]

Hi Arun Kumar, Sure, I will try to do it by my level best... If you feel like our channel is delivering the good knowledge to students, dont forget to subscribe, like and share this with your friends. For Pega Training Please join or refer your friends at Harsha Traininigs, reach us on 9652532753

[@challa4518]

Thanks for your valuable information. How to retrieve file from shared folder with out using Java code?

[@HarshaTrainingsacademy]

Hi Eeshdar, Could you please explain about the requirement in details. So that can help you better on this.. If you feel like our channel is delivering the good knowledge to students, dont forget to subscribe, like and share this with your friends. For Pega Training Please join or refer your friends at Harsha Traininigs, reach us on 9652532753

[@jais3027]

Hi sir how to reffer a section at runtime dynamically... Thanks in advance sir

[@MrPraveensiva]

Whenever you embed a section in another section there are two options. One is the section name and the other is with the property reference. You should set the property name with section before loading. Then at the time of screen load, the specific section would get displayed. By this way, you can refer the section dynamically.

[@HarshaTrainingsacademy]

Hi Jai, You can do it by usnig Property refrence. If you feel like our channel is delivering the good knowledge to students, dont forget to subscribe, like and share this with your friends. For Pega Training Please join or refer your friends at Harsha Traininigs, reach us on 9652532753

[@jais3027]

Thank you praveen

[@tanyasingh2294]

Hi @Harsha I tried to so a property set on the utility shape like pxCreateOperator =ABC and it worked instead of my name it was showing ABC so how is it possible?I cant understand how pega is allowing this?

[@HarshaTrainingsacademy]

It seems like you are encountering a behavior in Pega where setting the property "pxCreateOperator" on a utility shape in a certain way is causing it to display "ABC" instead of your name. To understand why this is happening, let's break it down: 1.pxCreateOperator Property: In Pega, "pxCreateOperator" is a system property that typically stores the operator (user) who created a case or performed an action. It is automatically populated by Pega with the operator's name. 2.Utility Shape: A utility shape in Pega is often used for various purposes, including setting or manipulating properties during a case's lifecycle. Based on your description, it appears that you are setting the "pxCreateOperator" property on a utility shape to "ABC," and somehow, it's displaying "ABC" instead of your name. Here are some possibilities for this behavior: *Overriding the Default Value: It's possible that your utility shape configuration is overriding the default behavior of "pxCreateOperator." When you set "pxCreateOperator = ABC" within the utility shape, you are essentially telling Pega to use "ABC" as the value for "pxCreateOperator" instead of the operator's name. *Visibility Rules or Conditions: There may be visibility rules or conditions configured in your application that determine when "pxCreateOperator" is displayed, and these rules could be causing "ABC" to be shown under certain circumstances. *Data Transform or Activity: The utility shape might be part of a sequence that includes data transforms, activities, or other logic that sets the "pxCreateOperator" property to "ABC" for specific cases.

[@tanyasingh2294]

Thanks a lot @HarshaTrainingsacademy for providing a detailed solution

[@deepikajujjuru8384]

Hi harsha can you please explain about attribute based role/ security.

[@HarshaTrainingsacademy]

Hi Deepika, The question is small but the answer will be leagthy... I will try to make a video soon about this... If you feel like our channel is delivering the good knowledge to students, dont forget to subscribe, like and share this with your friends. For Pega Training Please join or refer your friends at Harsha Traininigs, reach us on 9652532753

[@deepikajujjuru8384]

Thank you harsha. Sure i will.and will be waiting for your video

[@mohanchowdhary1874]

How to connect external DB.

[@MrPraveensiva]

You can connect to the external database by configuring the database rule form in pega. Then you can create class and map it to the external database table with the class database table mapping.

[@HarshaTrainingsacademy]

Ho Mohan, We can connect to External DB in two ways 1. By using connection URL 2. By using connection pool... In all the above cases we need to create database rule. But creating database table rule is Optional depends on the pre query that you write in connect sql rules. If you feel like our channel is delivering the good knowledge to students, dont forget to subscribe, like and share this with your friends. For Pega Training Please join or refer your friends at Harsha Traininigs, reach us on 9652532753