TOC : Script API > JavaScript > JavaScript API > GeneralScript > CalculatedField > Method >

 

IsDataSetValueNull

<< 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 :

 

GetDataSetValue

 

JavaScript Events