Clarity Service Management

Expand all | Collapse all

Avoid duplicate row aggregation. Boxi to JasperStudio

  • 1.  Avoid duplicate row aggregation. Boxi to JasperStudio

    Posted 02-15-2019 11:09 AM

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



  • 2.  Re: Avoid duplicate row aggregation. Boxi to JasperStudio

     
    Posted 02-17-2019 08:37 PM

    I must be missing part of the story here, but my immediate thought is - why you would want to select these from the activity log when they are all 'cr' fields?  Select them from 'cr' and the need to use 'distinct' goes away.  And the query should perform better over time, since 'alg' typically grows several times faster than 'cr'.

    Hope that helps,

    Regards,

    James