Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 Bryan Chen (BryanC97)
Infosys Limited
US
BryanC97 Member since 2017 4 posts
Posted: Jun 4, 2018
Last activity: Jun 6, 2018
Posted: 4 Jun 2018 17:05 EDT
Last activity: 6 Jun 2018 20:24 EDT
Closed
Solved

How to export all properties of a class to an excel sheet?

GEGEMU-FW-ACMSFW-Int-OES-OESEntry-OESOrderEntrn539531366

Some of the classes like the one above have hundreds of properties, with no instances, no key, all unoptimized properties.

I've tried running a report definition to export an excel sheet showing all the properties in that class, but it feels like a dead end since it doesn't seem possible.

I'm looking for a solution to export a report on properties to an excel spreadsheet to analyze redundant properties and such. Anyway to do this?

To see attachments, please log in.
Dev/Designer Studio
Reporting

Accepted Solution

Posted: 6 years ago
Posted: 5 Jun 2018 1:09 EDT
Krishna Chaitanya Abburi (KC-Abburi)
LTI Mindtree

LTI Mindtree
IN

Hi

Could you create Report definition in "Rule-Obj-Property" and pass "Applies to class of Property" as parameter to this report definition.

In Filter section check "pyClassName" with "Applies to class of Property" as shown in attached file

Please use below columns in Report definiton

Show More

Hi

Could you create Report definition in "Rule-Obj-Property" and pass "Applies to class of Property" as parameter to this report definition.

In Filter section check "pyClassName" with "Applies to class of Property" as shown in attached file

Please use below columns in Report definiton

  1. pyDescription
  2. pyStringType
  3. pyMaxLength
  4. pyClassName
  5. pyPropertyName
  6. pxCreateOpName
  7. pyRuleSetVersion
  8. pxCreateDateTime
  9. pyPropertyMode
  10. pyPageClass

After executing report defintion export results to excel sheet.


Show Less
To see attachments, please log in.

Accepted Solution

Posted: 6 years ago
Posted: 5 Jun 2018 1:09 EDT
Krishna Chaitanya Abburi (KC-Abburi)
LTI Mindtree

LTI Mindtree
IN

Hi

Could you create Report definition in "Rule-Obj-Property" and pass "Applies to class of Property" as parameter to this report definition.

In Filter section check "pyClassName" with "Applies to class of Property" as shown in attached file

Please use below columns in Report definiton

Show More

Hi

Could you create Report definition in "Rule-Obj-Property" and pass "Applies to class of Property" as parameter to this report definition.

In Filter section check "pyClassName" with "Applies to class of Property" as shown in attached file

Please use below columns in Report definiton

  1. pyDescription
  2. pyStringType
  3. pyMaxLength
  4. pyClassName
  5. pyPropertyName
  6. pxCreateOpName
  7. pyRuleSetVersion
  8. pxCreateDateTime
  9. pyPropertyMode
  10. pyPageClass

After executing report defintion export results to excel sheet.


Show Less
To see attachments, please log in.
Posted: 6 years ago
Posted: 5 Jun 2018 8:53 EDT
Ujjwal Kumar Shukla (UjjwalShukla_GCS)
PEGA
Senior Manager, Technical Support
Pegasystems Inc.
IN

Hi There,

Even in that case a report can be formed with applies to class as rule-obj-property and then using required filter.

Thanks,
Ujjwal

To see attachments, please log in.

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice