Show Operator Name in report thru linked property
Hi All,
We have a reference property named PerformedBy. It stores the operator performing the assignment.
Property is of type User reference. We are able to show the user full name in the UI simply by referencing .PerformedBy.pyUserIdentifier.pyUserName
Now, we need to show that name also on a report.
Simply referencing the property as above shows an empty column in the report.
We also tried several class joins, however no luck there.
Can you advise what is the way I can show the Full name of the operator's profile stored in the PerformedBy property?
Accepted Solution
Louis Dreyfus Company
BG
UPDATE: Actually the issue was with the Join setup in Data Access tab of the report.
Upper environments contained data, and the join condition was setup like this:
Switching the "Type" to "Include all rows in this class" solved the issue completely.
Updated: 7 Oct 2021 2:40 EDT
Louis Dreyfus Company
BG
Indeed that is the initial approach I went for and got no results. However the issue appears to be with the property itself.
Creating the class-join works in Dev environment where I have the property optimized for reporting.
However when transferring the product to upper environment, I don't get any report results.
Manually optimizing the property directly in the upper environment & cleaning up the test case type records resolves the issue.
I'll look more into it, however I think the product rule may require additional setup to have the optimization transferred during deployment.
Thanks for your time on this.
Regards,
Petar Hr.
Accepted Solution
Louis Dreyfus Company
BG
UPDATE: Actually the issue was with the Join setup in Data Access tab of the report.
Upper environments contained data, and the join condition was setup like this:
Switching the "Type" to "Include all rows in this class" solved the issue completely.