AnsweredAssumed Answered

How to concatenate values from rows JASPER STUDIO

Question asked by dmartinez80 on Feb 19, 2019
Latest reply on Feb 19, 2019 by johsc03

hi!
I need to take the value in each record ( business_management_hierarchy.parent_name) and concatenate this value to the previous value, Creating a list separated by commas which is shown in a column from a table. Is this even possible. I'm guessing I need to handle this with a Variable somehow.


How is this done in Jasper? in Boxi we did it with variables and expressions. But in Jasper we did not find how to do it.

Any ideas or suggestions are very welcome!

Thank you

 

 

SELECT distinct
configuration_item_child.asset_num,
business_management_hierarchy.child_name,
app_extx.zClasificacion,
configuration_item_child.class_type,
business_management_hierarchy.parent_name
FROM
ci_rel_type relationship_type,
app_extx,
nr configuration_item_child
INNER JOIN bmhier business_management_hierarchy
ON (business_management_hierarchy.child=configuration_item_child.id)
WHERE
(
relationship_type.id = business_management_hierarchy.ci_rel_type
AND
configuration_item_child.asset_num = app_extx.app_id
AND
configuration_item_child.asset_num = 'IT0033'
)

Attachments

Outcomes