Report Definition Question
I am building a report definition(In a work class) that lists the case types in the application along with the case ID prefix. I will need to add pyLastReservedID (pc_data_uniqueID) as a column in my report definition. How do I get that ?
Pegasystems Inc.
US
Cognizant
US
Mahesh- Thank you for your response.
I couldn't find any report definitions under Data-UniqueID class. I created one to pull pyPrefix and pyOrganization, but the table "pc_data_uniqueID" doesn't have the organization populated. I see null organization for all the records in the table.
Cognizant
US
I tried creating a report under Data-UniqueID to pull the pyOrganization, pyPrefix and pyLastReservedID, Later I joined this as a sub-report in my main report by using join conditions mainreport.pyWorkIDPrefix=SubReport.pyPrefix. But, that throws me below error.
Pegasystems Inc.
US
Sravya - pyWorkIDPrefix is not being optimized so you are not able to use this property in sub report filter that is the reason you are facing this error, probably you can check in the log file for the respective error.
Pegasystems Inc.
US
Adding output of the report screenshot which shows the error about unoptimized property.
Pegasystems Inc.
US
Sravya - may i know which version of pega you are using?
IT
US
Pega 7.2
Hi Sravya,
You can have a look into the Data-UniqueID.DataUniqueIDList report definition.
Data-UniqueID(pc_data_uniqueID) -> contains pyOrganization and pyPrefix as keys
So in your case you can add a join to this table with the help of pyOrganization AND pyPrefix keys in your main report and try to fetch the pyLastReservedID from the joined table.
Hope this might help you to achieve your requirement.
Regards
Mahesh