Posted: 24 Apr 2017 15:08 EDT Last activity: 16 Oct 2018 12:03 EDT
Concatenate a property of page list in a report definition
I have a report definition in which I need to concatenate a property.
What I'm saying here is if I have a Page AM which then has a page list LoanIssue. LoanIssue has properties LoanIssue.Level1 , LoanIssue.Level2 , etc ....
I call these like this AM.LoanIssue(1).Level1 , AM.LoanIssue(2).Level1, etc...
Is there a way to concatenate those values above into a single Text property in the report definition. I need this in a string value "AM.LoanIssue(1).Level1" + "," + "AM.LoanIssue(2).Level1" ....
I have created a Java Function that does the actual concatenation but I can't reference this in the RD. Is there any straight forward or perhaps different approach I can take here to meet requirements?
I am using version 7.2 and no longer have access to list views.
**Moderation Team has archived post**
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.
The RD allows you to specify a function for each line in the column source. Why can't you use the "concatenate" function to do what you want? Or, can you add your Java function to the library so that it appears as a choice in the function dropdown?
The Calculation functions are reserved for SQL functions I can't use those. What my java function does is loop through all index's and then concatenates on the fly. If i were to use the concatenate function from Embed-UserFunctions Sql functions I would have to specify index there. I want a dynamic concatenation where I can loop through the entire list.
This kind of functionality does not seem possible for report definitions. I have solved my issue by creating a place holder property strictly for the concatenation. After user enters level 1 issues and submits to move to next step I run a post processing data transform and then call the java function there setting my placeholder property to the results of the java function. When I display the report with the placeholder property it shows as expected.