Create a report

[Shashi K]

My requirement is create a report to how many similar changes have gone multiple CABs, not showing single records of CAB name.

so I have write the script and calling into the report but its not working. please help for this Thankyou.

function getDuplicateValues(table, field){

    var dupValues = [];

    var ga = new GlideAggregate(table);

    ga.addAggregate('COUNT', field);

    ga.addNotNullQuery(field);

    ga.groupBy(field);

    ga.addHaving('COUNT', '>', 1);

    ga.query();

    while (ga.next()) {

        dupValues.push(ga[field].toString());

    }

    return dupValues;

}

[Dr Atul G- LNG]

Hi @Shashi K 

You mean , you want to see changes which presented in different cab. I guess no need to write script.

or my understanding is wrong?

[Shashi K]

No I want single record with multiple cab

ex:

[Dr Atul G- LNG]

Hi @Shashi K 

With comma you want to show multiple cabs right. 

It is possible with scripting but I am not coder here. Also as a best practice some time we need to use platform as it is, you can get the report with multiple lines , i am sure that must work.

Avoid code, if possible. 

[Shashi K]

How to do that?

[Dr Atul G- LNG]

Hi @Shashi K 

You already showed me in above screen shot. What else is missing here.