question Re: Random Request Report in Developer forum

Random Request Report

kanielb1 — Thu, 18 May 2017 18:59:13 GMT

Is it possible to create a report that pulls random cases/requests based on the assigned to?

Or how could I create a page or module that would pull a random list of records based on the assigned to in a scoped application?

Re: Random Request Report

Pradeep Sharma — Thu, 18 May 2017 19:17:48 GMT

Hello Kaniel,

You can create a report and pull the results as per defined filter

.Reporting - ServiceNow Wiki

Re: Random Request Report

kanielb1 — Thu, 18 May 2017 19:22:38 GMT

I need something like a random ticket number generator...a way to pull a random ticket for audit purposes. Can this be done with a report?

Re: Random Request Report

kanielb1 — Mon, 22 May 2017 19:48:09 GMT

I found the following solution on another community post.

Create a UI Page:

[CODE]

<?xml version="1.0" encoding="utf-8" ?>

<j:jelly trim="false" xmlns:j="jelly:core" xmlns:g="glide" xmlns:j2="null" xmlns:g2="null">

window.onload = function() {

randomCase();

};

</script>

</j:jelly>

[/CODE]

Client Script:

[CODE]

function randomCase(){

var caseList = [];

var rec = new GlideRecord('table');

rec.addQuery('active', true);

rec.addQuery('investigator', 'IN', 'Name1,Name2,Name3,Name4');

rec.query();

while (rec.next()){

caseList.push(rec.getValue('number'));

}

var random = Math.floor((Math.random() * caseList.length));

var selected = caseList[random];

var txt = selected;

window.location = ("https://instance.service-now.com/nav_to.do?uri=x_whba_table.do?sysparm_query=number=" + selected);

}

[/CODE]

Re: Random Request Report

drjohnchun — Mon, 22 May 2017 20:46:31 GMT

Hi Kaniel - I've written a blog on And the winner is... Randomly Selecting GlideRecords, which shows how to select a set of random records using a Scripted Filter.

Hope this helps.

Please feel free to connect, follow, mark helpful / answer, like, endorse.

John Chun, PhD PMP

Re: Random Request Report

saschawildg — Fri, 11 Feb 2022 13:21:50 GMT

There is a Glide API to receive random data. Check this out:

https://github.com/saschawildgrube/servicenow-devtools/blob/master/update/sys_script_include_8bf245b3dbbbe490bc44d844ca9619c6.xml

The DevTools app contains a truckload of reusable scripts and
features to support your app development.

Fork at will!

Re: Random Request Report

sannavullamd — Tue, 12 Nov 2024 07:31:57 GMT

But how it pulls the report based on assigned to user here?