Create scripted filters

The condition builder alone cannot create some filters, such as displaying a record set that depends on an unrelated table. If you know JavaScript, you can create JavaScript functions for use in advanced filters.

Before you begin

Role required: admin

Procedure

Create a new script include.
1. Navigate to System Definition > Script Includes.
2. Click New.
3. Fill out the form, and then select Submit.
Open the script include and, in the Script field, create a JavaScript function that returns an array of sys_ids.
- Ensure that the function uses the same name as the script include.
- Ensure that the script include is Active and Client callable.
Call the JavaScript function from the condition builder.
For more information, see GlideRecord queries and Script includes.

Example

A company provides intensive care for a group of customers. To track these services, the service manager needs a high-level journal and links to all incidents that the customers raise.

The company creates an application, Intensive Care, and a table, [u_intensive_care]. While the table contains a reference field for the customer name, there is no direct link to the user table. Thus, the manager cannot set up an incident list filter using the condition builder for customers who are under intensive care.

The solution is to write a JavaScript function that uses a GlideRecord query to build an array of user sys_ids in the [u_intensive_care] table, as shown in the sample code below. Call the function from the condition builder in the Incident table ([Caller] [is] [javascript:myFunction()]).

function myFunction ( ) { 
    var arrUsers  = [ ];
    gr  = new GlideRecord ( 'u_intensive_care' );
    gr. query ( ); 
    while (gr. next ( ) ) {
        arrUsers. push (gr. u_customer. toString ( ) ); 
    }
    return arrUsers;
}

Create scripted filters

Before you begin

Role required: admin

Procedure

Create a new script include.
1. Navigate to System Definition > Script Includes.
2. Click New.
3. Fill out the form, and then select Submit.
Open the script include and, in the Script field, create a JavaScript function that returns an array of sys_ids.
- Ensure that the function uses the same name as the script include.
- Ensure that the script include is Active and Client callable.
Call the JavaScript function from the condition builder.
For more information, see GlideRecord queries and Script includes.

Example

A company provides intensive care for a group of customers. To track these services, the service manager needs a high-level journal and links to all incidents that the customers raise.

function myFunction ( ) { 
    var arrUsers  = [ ];
    gr  = new GlideRecord ( 'u_intensive_care' );
    gr. query ( ); 
    while (gr. next ( ) ) {
        arrUsers. push (gr. u_customer. toString ( ) ); 
    }
    return arrUsers;
}

How search works:

Topics are ranked in search results by how closely they match your search terms

Create scripted filters

Create scripted filters

On this page

Create scripted filters

Create scripted filters

Log in to personalize your search results and subscribe to topics