<< Click to Display Table of Contents >> Navigation:  »No topics above this level« TOC : Script API > JavaScript > JavaScript API > Component > Band > DataSubBand > Method >   GetDataSetCNT

 

 

Gets the number of dataset rows.

 

 

 

Prototype :

 

double GetDataSetCNT

(

        [ string DataSetPath ],

        [ string DistinctFieldName ],

        [ string ConditionFieldName ]

)

 

 

 

Arguments :

 

 

 

 

Reference :

 

Refer to GetDataSetValue function for how to set the field path.

 

Refer to GetDataSetSUM function for using DistinctFieldName and ConditionFieldName.

 

If set FieldPath using dataset of the data sub band itself, GetDataSetCNT will return the same value as its parent band case. The parent bands of a data sub band are the data band or group header/footer band. Therefore, refer to the GetDataSetCNT function of the data band or group header/footer band.

 

 

 

Example :

 

//ODI name : Sample, dataset name : Orders

  _TraceLn(This.GetDataSetCNT("Sample.Orders"));

 

//ODI name can be omitted

 _TraceLn(This.GetDataSetCNT("Orders"));

 

//Dataset path can be omitted or set to null or ""

  _TraceLn(This.GetDataSetCNT());

  _TraceLn(This.GetDataSetCNT(null));

  _TraceLn(This.GetDataSetCNT(""));;

 

//specify DistinctFieldName

  _TraceLn(This.GetDataSetCNT("", "Region"));

 

//specify ConditionFieldName

  _TraceLn(This.GetDataSetCNT("", "", "Flag"));

 

//specify DistinctFieldName and ConditionFieldName

  _TraceLn(This.GetDataSetCNT("", "Region", "Flag"));

 

 

 

Available Events :

 

OnBind,  OnStartBind

 

 

 

See also :

 

GetDataSetSUM