NULL
This literal is used to clear the value of an existing field using SFM.
Configuration
In SFM Transaction Designer, this literal is available for configuration in Mapping Editor, Formula Editor, Source Object Update.
In Output Document Designer, this literal is available for configuration in Record Update.
Features and its Supported Field Types
|
Features
|
Supported Field Types
|
Business Context
|
|---|---|---|
|
Mapping Editor
|
All data types except checkbox in Value map
|
Use this literal to remove default user assignment from the record on SFM load, so that the end-user sets the correct value before Save and clear dispatch process details on the record to add the Work Order back to the Queue.
|
|
Source Object Update
|
Date, Datetime, Lookup, Number, and Text type fields
|
Use this literal to clear technician details on save or successful report generation.
|
|
Target Object Update/ Record Update
|
Date, Datetime, Lookup, Number, and Text type fields
|
Use this literal to clear technician details on save or successful report generation.
|
|
Formulas
|
Date, Datetime, Lookup, Number, and Text type fields
|
Use this literal to clear target field value like clearing error message of the field on successful Save.
|
Function $F.SETNULL() is listed under Logical category.
Delivery Screens and its Support for NULL Literal
1. This literal is respected only on web delivery pages.
• Lightning SFM Delivery: Supports NULL literal in Field and Value Mapping, Source Object Update. Form-Fill and Formulas do not support NULL literal.
• Lightning theme based (old UI) SFM Delivery: Supports NULL literal in Field and Value Mapping, Source Object Update, Formula, and Form fill.
• Output Document Delivery: Supports NULL literal in Record Update ( Target Object Update).
2. Mobile apps do not support this literal.
 |
This literal (NULL/SVMX.SETNULL) can be used in SFM Web Delivery pages only if they are configured in New Transaction Designer.
|