ServiceNow CPQ scripting language reference
Summarize
Summary of ServiceNow CPQ scripting language reference
ServiceNow CPQ uses a JavaScript-like scripting language designed to dynamically modify field values and BOM data through rules and enrichments. Although it does not support the full breadth of standard JavaScript features, this scripting environment allows customers to implement powerful product configuration logic tailored to their needs. The scripting language is continually evolving, so customers should check regularly for new capabilities.
Show less
Supported Features
- Operators: Arithmetic (+, -, , /, %, ++, --), string concatenation (+, +=), assignment (=, +=, -=), comparison (==, ===, !=, !==, >, <, >=, <=), and logical (&&, ||) operators are supported.
- Objects: Arrays, strings, numbers, booleans, Maps, and Dates can be declared and manipulated. However, undefined, NaN, and null are unsupported. Date objects can be referenced and manipulated but not returned.
- Keywords: var, let, const, new, if, else if, else, for, for/of, and return are supported. While loops and unconditional loops with break are disallowed to prevent infinite loops. Functions are not supported, encouraging concise scripting or use of managed tables for complex logic.
Workarounds and Best Practices
- Unsupported operations like assignment multiplication/division (e.g., =, /=) should be rewritten explicitly (e.g.,
number = number otherNumber;). - Exponentiation uses
Math.pow(x, y);instead of the operator. - Type conversion helpers include
Array.toString()to convert arrays to strings, appending an empty string to numbers to convert to strings, and subtracting zero from numeric strings to convert to numbers. - Type checking can be done with
LGK.isNumber(value)returning a Boolean.
Accessing Object Properties
Properties of map objects (e.g., cfgRequest) can be accessed via dot notation or bracket notation (objectName.propertyName or objectName["propertyName"]). This flexibility enables dynamic property access, such as replacing repetitive if statements with table lookups that drive configuration logic.
For example, a managed table can store configuration mappings, and a script can look up values based on a field (like shipState) to set related Boolean and quantity fields dynamically. This approach simplifies scripts and makes them more maintainable.
Recommendations and Support
For complex or lengthy scripts, consider using managed tables with table queries to simplify logic and improve maintainability. If specific functionality is not described in this reference, customers should create a support case through the ServiceNow Support portal for assistance.
View the operators, objects, and keywords that ServiceNow CPQ supports, together with information about type conversion, type checking, alternative scripts for unsupported operations, and accessing object properties.
ServiceNow CPQ uses a JavaScript-like language to dynamically change the value of fields and BOM data via rules and enrichments. JavaScript is a complex language built over almost thirty years, and while we are unable to replicate every piece of functionality that a developer would normally expect while coding, ServiceNow CPQ scripting remains a powerful tool to assist in the dynamic configuration of products.
The capabilities of ServiceNow CPQ scripting are always expanding. Check back to see the most up-to-date features.
Supported operators
Arithmetic operators:
- +
- Addition
- -
- Subtraction
- *
- Multiplication
- /
- Division
- %
- Modulus
- ++
- Increment
- --
- Decrement
String operators:
- +
- Concatenation
- +=
- Addition assignment
Assignment operators:
- =
- Assignment
- +=
- Addition assignment
- -=
- Subtraction assignment
Comparison operators:
- ==
- Equal to
- ===
- Equal value and equal type
- !=
- Not equal to
- !==
- Not equal value nor equal type
- >
- Greater than
- <
- Less than
- >=
- Greater than or equal to
- <=
- Less than or equal to
Logical operators:
- &&
- And
- ||
- Or
Supported objects
Each object supported can be declared with the following:
- [ ]
- Array
- " "
- String
- ( )
- Number
- true | false
- Boolean
- { }, new Map( )
- Map
- new Date( )
- Date
undefined, NaN, and null are unsupported.
Supported keywords
varletconstnewifelse ifelseforfor/ofreturn
We do not support while or unconditional for loops with break, because of the risk of infinite loops halting performance.
We do not support functions, as the script itself should be small enough to be considered one function. If your script is long with many conditions and variables, consider creating a managed table and using a table query. For more information about using managed tables and table queries, see Matrix Loader: CSV table upload and Minimizing table queries.
Alternative scripts for unsupported operations
Assignment multiplication and division (/= or *=): number = number * otherNumber;, number = number / otherNumber;
Exponentiation (x**y): Math.pow(x, y);
Type conversion
Convert arrays to strings: Array.toString()
Convert numbers to strings: [number] + ""
Convert numeric strings to numbers: [string] - 0
.length does work for strings.Type checking
The following returns a Boolean value indicating whether an input is a number: LGK.isNumber(123)
Accessing object properties
You can access the properties of map objects such as cfgRequest in two ways.
objectName.propertyName
//or
objectName["propertyName"]This is helpful in order to replace large amounts of repetitive code with results from a Table Lookup, since the “propertyName” text could instead be replaced by a variable.
For example, consider a blueprint with the following fields associated with it, and a managed table named shipstatebooleantest.
- shipState
- boolean1
- boolean2
- boolean3
- quantity1
- quantity2
- quantity3
| id | shipState | trueBoolean | quantityTest | rowQuantity |
| 1 | Arizona | boolean1 | quantity1 | 1 |
| 2 | Maine | boolean2 | quantity2 | 2 |
| 3 | California | boolean3 | quantity3 | 3 |
Instead of having an identical if statement check what shipState is and setting the Boolean values and quantities accordingly, you could instead replace it with only one if
statement that sets the values based on the results of a table lookup.
In the following On Configure/Reconfigure script, if the shipState field has a value, the fields that are returned by the lookup function
are set. If the shipState field is blank, then all Boolean and quantity fields are set.
if (cfgRequest.shipState.value != "" && cfgRequest.shipState.value != null){
var fieldMapping = lookup("Select trueBoolean,quantityTest,rowQuantity from shipstatebooleantest where shipState = :value", { "value": cfgRequest.shipState.value });
console.log(fieldMapping);
if (fieldMapping != []){
cfgRequest[fieldMapping[0].trueBoolean].set("value",true);
cfgRequest[fieldMapping[0].quantityTest].set("value",fieldMapping[0].rowQuantity);
}
}
else{
var fieldMapping = lookup("Select trueBoolean,quantityTest,rowQuantity from shipstatebooleantest");
console.log(fieldMapping);
for (var row of fieldMapping) {
cfgRequest[row.trueBoolean].set("value",true);
cfgRequest[row.quantityTest].set("value",row.rowQuantity);ea
}
} If your instance of ServiceNow CPQ needs functionality not described here, create a support case by using the ServiceNow Support portal. For step-by-step instructions, see Create a case on Now Support for CPQ Customers.