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