Yes, as these properties are used regularly by PRPC itself, e.g. for displaying the worklist, or for statistics on the dashboard. So these properties are already pre-exposed in the table and you do not need to optimise them yourself.

You should be able to scroll to find the property in the Navigation Panel (left side) even with a large number of properties.

Bill Rathert

How to find out which property is optimized and which is not?

e.g.

Need to create a report with case id and purchase order id then which property should be optimized?

Saurabh

All of the properties out of the box are exposed by Pega 7, meaning they all occupy a column in the resulting DB table.  The only properties we need to expose are properties that we create to hold values in the cases we create.  Both the Case ID and Purchase Order ID should be able to be looked up using the pxInsName property, you can find it on the pyWorkPage on the clipboard.

An example of a property that would need to be exposed would be, suppose we have a Candidate case and we want to figure out how many candidates are Married, Single, Divorced or Domestic Partnership.  That property Marital Status is defined by us and as such the values are stored in the pzPVStream (or the blob).  We would want to expose that property so we don't have to search the blob field for each record to find this information.

Hope this helps,

Sean

Pega Academy Support Team

yeah it helps.

Thanks

Hello Sean

I have a requirement where I need to generate a Report for all the properties that are exposed in my applocation. 

how do I achieve this ?? Is there any wizard available through which I can get a list of all the properties that are exposed in PRPC 6.2 sp 2??

Charu

Unfortunately I am not aware of any report.

Sean

Pega Academy Support Team

Sean

Is it atleast possible to find it in any way ..?? I need to collect this data and pass it to DB team.