Question
For Pega Express Trilal, "Service Request" Case Type it is not possible to create a custom made report based on "Product" field.
For Pega Express Trial, on the "Service Request" Case Type it seemed not possible to create a custom made report based on the "Product" field.
I found out how to do it (Product is a reference field with subfields); and one way is to create a report column products is to use the concatenate function of empty string "" with .Product.Name.
I wonder if there is a different way? Better way? I tried to refer to .Product.Name but it did not work. I tried to use a calculated field but it turned out empty.
I am not a specialist in reporting and this seems to be an interesting question/problem to leave recorded.
This post has been archived for educational purposes. Contents and links will no longer be updated. If you have the same/similar question, please write a new post.
I'm not familiar with the Pega Express "Service Request" case type, and I'm not sure what exactly you are trying to do with the report, but it sounds like you may want to use a Declare Index:
https://pdn.pega.com/sites/pdn.pega.com/files/help_v731/procomhelpmain.htm#rule-/rule-declare-/rule-declare-index/main.htm?Highlight=declarative index
From the above help page:
An index can improve search and reporting access for properties that cannot be exposed as database columns because they are embedded within an aggregate property.