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?
Accepted Solution
Crochet Technologies
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
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
- pyDescription
- pyStringType
- pyMaxLength
- pyClassName
- pyPropertyName
- pxCreateOpName
- pyRuleSetVersion
- pxCreateDateTime
- pyPropertyMode
- pyPageClass
After executing report defintion export results to excel sheet.
Infosys Limited
US
The only thing I didn't use was .pyDescription .
Other than that, it works exactly as expected! Thanks a ton.
Crochet Technologies
IN
Hi
We can also use pyDescription.
Thanks
Pegasystems Inc.
IN
Hi There,
Please use RD pxLoadRelevantRecords, you can customize this to achieve the required.
Thanks,
Ujjwal
Crochet Technologies
IN
Hi
This Report definition is available in 7.3.1 but not in 7.1.9
Thanks
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