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'
)