How to wrap script in a script include a call from a report created through the report designer

[AndersBGS]

Hi all, 

I have created below script which reference a database view in a custom scoped app, where dt_dashboard.sysid reference the dashboard sysid. I need to populate this script (or similar) in a script include which I then call from a report created through the report designer. How to do this in the best way?

var dashboards = new GlideRecord('x_431699_dashboard_items');
dashboards.addNotNullQuery('dt_dashboard.name');
dashboards.orderBy('dt_dashboard.name');
dashboards.query();

gs.info('---> ' + dashboards.getRowCount());

var dashboardList = [];
while(dashboards.next()) {
     dashboardList.push(dashboards.dt_dashboard.name.trim());
}

var arrayUtil = new ArrayUtil();
dashboardList = arrayUtil.unique(dashboardList);

gs.info('---> ' + dashboardList.length);

for (var i = 0; i < dashboardList.length; i++) {
     gs.info('---> ' + dashboardList[i]);

}

The report on the dashboard whiteout any filtration looks like below:

The database view for dashboard is configured as below:

Basic need is, I need to query the unique values from the database view and create a report for this.

@Technomonk @Tai Vu @Ankur Bawiskar @Community Alums 

Best regards

Anders

[Ankur Bawiskar]

@AndersBGS 

to call script include from report condition, it should be client callable

[AndersBGS]

Hi @Ankur Bawiskar ,

It is, but I still doesn't get any values:

Best regards

Anders

[Ankur Bawiskar]

@AndersBGS 

please share the script section

Also how are you calling it in report filter condition?

[AndersBGS]

Hi @Ankur Bawiskar 

Complete script from script include:

function getUniqueDashboardNames() {
    var dashboards = new GlideRecord('x_431699_dashboard_items');
    dashboards.addNotNullQuery('dt_dashboard.sys_id');
    dashboards.orderBy('dt_dashboard.sys_id');
    dashboards.query();

//&    gs.info('---> ' + dashboards.getRowCount());

    var dashboardList = [];
    while(dashboards.next()) {
         dashboardList.push(dashboards.dt_dashboard.sys_id.trim());
    }

    var arrayUtil = new ArrayUtil();
    dashboardList = arrayUtil.unique(dashboardList);

//    gs.info('---> ' + dashboardList.length);

//    for (var i = 0; i < dashboardList.length; i++) {
//         gs.info('---> ' + dashboardList[i]);

   return dashboardList;
    }


// Call the function to get the unique dashboard names
var uniqueDashboardNames = getUniqueDashboardNames();

 Condition from the report:

Script from the condition:

javascript:DashboardItemScriptInclude.getUniqueDashboardNames();

Best regards

Anders