Script evaluation of fields by data type
Script fields evaluate data based on the field type of the input.
| Type | Evaluates to in script | Example |
|---|---|---|
| String | The string | "dog" > "dog" |
| Decimal | A number with up to two decimal points | 12.34 > 12.34 |
| Integer | A number with zero decimal points | 12 > 12 |
| True / False | true or false |
|
| Date | A date formatted as yyyy-mm-dd | 2008-11-04 |
| Date-time | A day and time formatted as yyyy-mm-dd hh:mm:ss | 2008-11-04 06:46:20 |
| Duration | A date that is equal to January 1st 1970 00:00:00 + the amount of time of the duration being stored 주: This date corresponds to the system time zone. If a different user time zone has
been specified, the date and time value may appear different for that user. |
|
| Choice | Returns the contents of the value field for the sys_choice record associated
with that choice. See: Choice List for more information on returning the value
associated with a particular item in a choice list. |
 > "2" (Note that this value is is a string) |
| Journal | Returns a string of all entries made to that journal field. See Journal Fields for scripting of journal type fields | The web server is down > The web server is down |
| Reference | Returns the sys_id of the record that is referenced |
 > "287ee6fea9fe198100ada7950d0b1b73" |
| Image | Returns the path to the image |  > images/icons/image_name.gif |
| URL | Returns a string |  > "http://www.service-now.com" |
| Glide Lists | Returns a string of comma-separated Sys IDs |  > 5137153cc611227c000bbd1bd8cd2007,46d14f04a9fe19810142e40c6b071512 |
> true
> false
> "1970-01-01 00:00:00"
> "1970-01-02 02:03:04"