Clarity Service Management

Expand all | Collapse all

How to concatenate values from rows JASPER STUDIO

  • 1.  How to concatenate values from rows JASPER STUDIO

    Posted 02-19-2019 10:38 AM
      |   view attached

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



  • 2.  Re: How to concatenate values from rows JASPER STUDIO

    Posted 02-19-2019 04:31 PM

    Hi Damian,

     

    Perhaps the link below helps?

     

    list of comma separated values | Jaspersoft Community 

     

    Thanks,

    Scott