AnsweredAssumed Answered

Avoid duplicate row aggregation. Boxi to JasperStudio

Question asked by stitch626 on Feb 15, 2019
Latest reply on Feb 18, 2019 by camja06

We are migrating from Boxi to JasperStudio (CABI 6.4.3) and we can´t find in JasperStudio how to make the function  "Avoid duplicate row aggregation” that was available in Boxi before. We could use Distinct or group by , but the object layer of SDM (17.01) doesn´t let us use these functions with derived fields.

How to apply "Avoid duplicate row aggregation" in Table Element?

the query is:

 

SELECT
alg.request_ref_num AS ref_num,
alg.request_type_symbol as type_symbol,
alg.request_description as description,
alg.request_summary as summary,
alg.request_customer_combo_name as customer_combo_name,
alg.request_status_symbol as status_symbol ,
alg.request_group_name as group_name,
alg.request_open_date as open_date,
alg.request_resolve_date as resolve_date,
alg.request_request_area_symbol as request_area_symbol,
alg.request_configuration_item_name as configuration_item_name
FROM
alg
WHERE
alg.request_open_date
BETWEEN {d '2016-11-02 12:00:00 am'} AND {d '2016-12-02 12:00:00 am'}

Outcomes