Issue with report definition - Display Page List properties on a Single Column
Scenario.
We have a page list which list
We have a page list that contains the list of Trees that ordered by a user. Once user can order maximum 3 trees.
There is a report definition that extract the case IDs along with the trees that are requested by users.
Report columns comes as follows
Case ID | First Name | Tree Name 1 | Tree Name 2 | Tree Name 3
T-001 | John | Lemon | Lime | Mango
Tree name 1,2,3 has been defined in the report definition as follows.
TreeList(1).TreeName
TreeList(2).TreeName
TreeList(3).TreeName
These values are directly retrieved from Blob column.
Since this report gives rule warnings for Property optimization, we did the property optimization for TreeName property.
Created a declare index rule and for new cases, the values are saving to index table.
To retrieve the values from Index table, did the index join to the report definition and now the optimization issue is resolved but the
data is displayed as follows.
Case ID | First Name | Tree Name 1 | Tree Name 2 | Tree Name 3
T-001 | John | Lemon | Lime | Mango
Scenario.
We have a page list which list
We have a page list that contains the list of Trees that ordered by a user. Once user can order maximum 3 trees.
There is a report definition that extract the case IDs along with the trees that are requested by users.
Report columns comes as follows
Case ID | First Name | Tree Name 1 | Tree Name 2 | Tree Name 3
T-001 | John | Lemon | Lime | Mango
Tree name 1,2,3 has been defined in the report definition as follows.
TreeList(1).TreeName
TreeList(2).TreeName
TreeList(3).TreeName
These values are directly retrieved from Blob column.
Since this report gives rule warnings for Property optimization, we did the property optimization for TreeName property.
Created a declare index rule and for new cases, the values are saving to index table.
To retrieve the values from Index table, did the index join to the report definition and now the optimization issue is resolved but the
data is displayed as follows.
Case ID | First Name | Tree Name 1 | Tree Name 2 | Tree Name 3
T-001 | John | Lemon | Lime | Mango
T-001 | John | Lemon | Lime | Mango
T-001 | John | Lemon | Lime | Mango
How we can bring the report to display the trees in a single row after index join. (data has to be displayed as it was before)
Case ID | First Name | Tree Name 1 | Tree Name 2 | Tree Name 3
T-001 | John | Lemon | Lime | Mango
Coforge
AU
We have tried with remove duplicates option but it does not work.
The attachment is same as the issue description.
Areteans Technology Solutions Pvt. Ltd.
IN
@ASANTHAW As in your declare index the data is stored in multiple rows hence you getting data like this format. Here we can try 2 things 1. Change the report structure have only 3 columns a. Case I’d b. First name c. Tree name. This will be flexible and easy to maintain if in future the order requirement change from maximum 3 trees to n number of trees. 2nd option is to create 3 columns in index table and store the page list value in a single row format. Can define in index like this .treename(1)= tree name 1 and .treename(2)=tree name 2….
Coforge
AU
@AmarTiwari , Thanks for the suggestion, I will check this approach.