<< Click to Display Table of Contents >> Navigation: »No topics above this level« TOC : Script API > JavaScript > JavaScript API > GeneralScript > CalculatedField > Method >IsDataSetValueNull |
Indicates whether the field value is null.
Prototype :
bool IsDataSetValueNull
(
string FieldPath
)
Arguments :
FieldPath |
Field Path setup depends on the field type |
Reference :
Data field or ODI parameter field created only in the dataset can be used for the field path argument.
Field path should not be set to the field itself.
Setting the field path according to the field type.
? Data field
Set the field path in the form of "field-name" or "dataset-name.field-name".
The dataset name can be the data set which include the given field or the master set of the data set including the given field.
? ODI parameter field
Set the field path in the form of "OZParam.field-name".
? Form parameter field
Set the field path in the form of "OZFormParam.field-name".
OZFormParam can be omitted for a form calculated field.
? System field
Set the field path in the form of "OZSystem.field-name".
Page_Of_Total and Total_Page are not available.
Example :
//Data field(field name : Price)
This.SetFieldData(This.IsDataSetValueNull("Price"));
//Data field(masterset name: Code, field name : Name)
This.SetFieldData(This.IsDataSetValueNull("Code.Name"));
//ODI parameter name(ODI parameter field name : TotalAmount)
This.SetFieldData(This.IsDataSetValueNull("OZParam.TotalAmount"));
//form parameter name(parameter field name : Quantity)
This.SetFieldData(This.IsDataSetValueNull("OZFormParam.Quantity"));
//system field
This.SetFieldData(This.IsDataSetValueNull("OZSystem.Time"));
Available Events :
All Events
The IsDataSetValueNull function can be used in all events. But the Data Field and the ODI Paramater Field returns the wrong value or script error, depending on the event. Restrictions on the event, please refer to JavaScript Events topic. |
See also :